Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 49
This interactive session presents reference architectures and actual IT case studies for integrating Solid State Disk (SSD) into existing storage infrastructures to boost performance and enable virtualization especially in big data environments where data volumes are growing rapidly, and applications and users are demanding high-speed concurrent access.  Attendees will see how large database environments can be more strategic in their deployment of SSD and reap 10-fold performance acceleration without the need to reconfigure or move applications or data, without forklift hardware upgrades, and without changing data protection policies. This session will allow one-on-one Q & A with a technical architect. 
Speaker:

Session Type:
Regular Session

Track:
DBA I

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts.
This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI/Dev

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. Kathy  will use real-life case studies to demonstrate the techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA II

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

In this intro level session, we'll look at the basics of building a working SSAS Cube, and the basics of MDX calculations.  In constructing a working cube, we will cover key concepts for Analysis Services and MDX, and show you how to construct a basic cube and regular dimension, and a calculated member for Analysis.  We will pack as much information into this session so as to allow you to take away enough to be able to start building cubes and metrics on your own.   
Speaker:

Session Type:
Regular Session

Track:
Prof Dev

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

As a DBA there is a lot of simple, step-by-step work that has to be completed on a daily basis. And while it's obviously a necessary part of our job, it's not fun and it takes away from time we could spend doing more important, less urgent work. One attractive option is delegating work to others, thus allowing the DBA to focus on more attractive / important tasks. But how do we do so without compromising security or best practices? Using the tips and tricks presented in this session, you'll be able to spread your workload to junior personnel while still maintaining a sound security / audit model.
Speaker:

Session Type:
Regular Session

Track:
DBA I

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server on VMware???  Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA II

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine. To use the new Vertipaq engine you build a Tabular data model.  A new query language DAX (Data Analysis Expressions) is used to query the data, create calculations, measures, and KPI’s.This session is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded). We will import data from a SQL Server relational database into a tabular model project and create relationships between the tables. We will use DAX to create and manage calculations, measures, and Key Performance Indicators
Speaker:

Session Type:
Regular Session

Track:
BI 2012

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Career Success in Data Management during Turbulent Timesa; A workshop on issues and ideas that today's data professionals can do to build their careers and networking skills with other data management professionals. Workshop topics will include:• Demonstrating your expertise• Building a portfolio of your success stories• Getting others to sell your skills and business value• Building & extending your data management skill set• 10 Steps to highlighting you and your workBring your thoughts, ideas, and experiences.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof Dev

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Leadership coaching is the practice of using relational influence, the people kind, not the database kind J, to develop and empower leaders. You might be in a position of leadership today. You might be in a position of leadership tomorrow. Either way; we all have opportunities to lead in different ways as we go about our lives and careers. Learn some simple techniques that can help you lead through conversation.
Speaker:

Session Type:
Regular Session

Track:
Prof Dev

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Creating a Performance Baseline for a SQL Server should be the first task any DBA accomplishes when inheriting the instance.  The Performance Baseline provides a starting point for any performance optimization efforts, a point of reference for future performance comparisons, and documents the server and instance configuration.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA II

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover how one can create a PerformancePoint Services Dashboard using a SQL Server 2012 BI Semantic Model.
Speaker:

Session Type:
Regular Session

Track:
BI 2012

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Based on the teaching of the Kimball Group and Jack Olsen, learn about what data quality is and how to manage it in a data warehouse project.  See how Data Quality Services (DQS) fits into the cleansing and conforming steps of an ETL and how these new tools create a huge leap forward in how the organization can take active responsibility over their data.  This session will give hands on examples of common data quality problems and how to address them.  
Speaker:

Session Type:
Regular Session

Track:
BI 2012

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

This is 100% code session, where presenter will demonstrate system development live cycle. Starting from a database stored procedure and go to the user interface to display a result. Down the road I’ll demonstrate different techniques, how to create a stored procedure calling class from SQL Server using system tables. How to pass to the stored procedure different parameter types, such as XML or ADO.NET DataTable. 
Speaker:

Session Type:
Regular Session

Track:
Development

Level: Advanced

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily.
Speaker:

Session Type:
Regular Session

Track:
DBA I

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Exploring your data has never been easier with Power View included in SQL Server 2012.  Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool.  This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2012

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem.  We don't always know how to do this easily and consistently.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker:

Session Type:
Regular Session

Track:
DBA I

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will be introduced to the new and enchanced SQL Server High Availability and Disaster Recovery features in SQL Server 2012. I will demo the setup of an AlwaysOn Availability Group and show how an application can automatically reconnect following a failover. Additionally, I will show how to configure read-only secondaries and demonstrate the use of prioritizing the secondaries for access.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA II

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation looks behind the scenes of how SQL Server physically organizes the data on disk. We will talk about Heaps, B+Trees, RIDs, Keys, Seeks and Scans. The materials covered will allow you to make a more informed decision about what type of index to use when.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA\Dev

Level: Advanced

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

It's one thing to know how to write basic MDX code (and that's certainly important).  It's another to know how to incorporate MDX into SSRS applications, PerformancePoint Services applications, and other BI applications.  In this presentation, I'll show some of the intricacies, issues, and workarounds for using MDX code in OLAP applications.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI/Dev

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.
Speaker:

Session Type:
Regular Session

Track:
DBA\Dev

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 49
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids