Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 32
In this introductory level session, which is designed for DBAs with little or no knowledge of query execution plans, you will learn why execution plans are important, how they are created, learn about the different execution plan formats, discover different ways to produce them, find out about the difference between estimated and actual execution plans, and most importantly, learn the basics of how to read and interpret graphical execution plans. This includes taking a look at ten of the most commonly used execution plan operators, and finding out exactly what they mean.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so! Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

After Party
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time.  Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Ask the Experts Q&A
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

You're minding your own business in your corner office - well, no, you're a DBA, so it's just your cubicle - when somebody says, "Did you know about this SQL Server over here?"  Suddenly, you have to find out what the server's doing, how it was set up, and whether things are working correctly.  In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will talk about building a data warehouse using the SQL Server 2008 database and SQL Server Integration Services ETL product.   We will cover the basics of data warehousing, how to start the project, and look at how we can use the tools to solve a business problem using a real-world example.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

I will explain what is defensive programming, what are its advantages, and provide several simple real life examples that show how to use it. I will demonstrate how to develop robust Transact SQL code that correctly works in high concurrency environments, gracefully handles cases of unintended use, and is easy to maintain in changing environments. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The days of long, inefficient Business Intelligence (BI) and data warehousing projects are coming to an end. Customers need to ability to reap quick business value for their investments. In this session we will take a tour of methodologies, techniques, and technologies that enable a quick return on investment for the Microsoft BI platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many ways to performance monitor your SQL Server environment.  In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms.  Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information.  With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.  

Goals:
1.	Define the architecture for Extended Events
2.	Identify scenarios where Extended Event can be used to troubleshoot performance
3.	Demonstrate solutions to real-world performance scenarios
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can't promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The days of hiding amongst rows of servers, focusing purely on operational tasks are quickly coming to an end. This presentation will provide a high level overview of how to boost your value to your organization by automating the mundane operational tasks and focusing on supporting new development. Topics covered will include tools and techniques available for automation, integration with development teams and relationship management.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Indexed views are an often misunderstood and underused feature of SQL Server that more DBAs should learn to master. Essentially, an indexed view is a standard view that has been materialized (made physical) by adding a unique clustered index to it. When used appropriately, they can greatly speed query performance. In this session, you will learn the features and benefits of using indexed views, learn where indexed views work best, learn how to create indexed views, and review indexed view best practices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Clustering is a black box to many DBAs. Often, the IT dept configures & installs the SQL cluster then turns it over to DBAs to deploy databases and set up backup & maintenance plans. The problem is when things go wrong the DBAs are reliant on the IT dept when their time is better spent working on other things. The goal of this session is to discuss underlying aspects of SQL Server clustering. We will touch on OS and SQL Server issues as well as how it reacts differently being clustered vs non-clustered. We will also discuss the pitfalls of upgrading clustered databases and installing clusters from scratch including lessons learned from a real-world upgrade of a SQL Server cluster where the active and passive nodes are 1,200 miles apart!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

"You are a database guy, how do I write a query in MDX?" This is a question that many of you are probably hearing right now as your companies' database experts. As the amount of data access being delivered cubes in increasing every day your company is looking to you to help unlock that stored potential. You have used the query designers and profiler to build some really simple stuff, but now you need to really understand the language and figure how to do some more complex stuff. This session will help you take that journey from not understanding MDX to being an MDX Developer. This session will give you the core concepts of MDX and how to utilize them with clear concrete examples, along with the tools to get you there.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

These two tools are the key to successful performance tuning.  I’ll show you how to get started with these tools, how to slice and dice the results, and even how to data mine the results to look for interesting trends.  Whether you like to monitor performance with native tools or third party utilities, knowing how the native tools work will help you get better results out of your tools.  You'll learn why Perfmon is like a Nissan GT-R’s dashboard, what Perfmon counters to measure (and why), and how to use ClearTrace to get insight into your trace files.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Servers!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each tasks we will explore the benefits is using PowerShell over the standard method.  Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell. 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

At Microsoft we understand that in the current economic climate you are being asked to better manage your database environment and reduce costs; in essence, keep the lights on. We have pulled together best practices for not only keeping the lights on but helping you manage more SQL Servers with less time and expense. The focus of this presentation is around:
o o Management best practice: SQL Server Discovery
o Microsoft Assessment and Planning Toolkit (MAP) 
o MAP query and report analysis
o SQL Server 2008 management enhancements
o Policy Based Management
o Performance Data Warehouse
o Configure Resource Governor
o Management best practice: Cross Platforms
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Reporting Services has been around for a number of years now and the 2008 release provided DBAs and Developers with a truly enterprise class reporting platform. If your company had not embraced Reporting Services fully yet then now is the time!  Come see not only some of the new features that are available but also how to programmatically interface with the Reporting Services web services in order to extend your own custom applications!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 17

Time: 12:00 AM - 1:00 AM

Room: TBD

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