Spotlight Sessions

Spotlight session speakers have received high ratings and great reviews for previously delivered sessions at PASS Summit. These engaging and highly regarded speakers have been invited back by popular demand to present special 90-minute sessions.

* Note: Sessions subject to change.

Application & Database Development

10 Query Tuning Techniques Every SQL Programmer Should Know (AD-104-S)
SELECT statements have a reputation for being very easy to write – but hard to write very well....
Kevin Kline, Aaron Bertrand

How to Model and Implement a Hierarchy in SQL Server (AD-318-S)
One of the most common structures you will come across in the real world is a hierarchy (either a...
Louis Davidson

Maximizing Plan Reuse (AD-405-S)
When it comes to getting peak performance from SQL Server, too many people underestimate just how...
Andrew Kelly

Table Expressions: So Much More than CTEs (AD-322-S)
You use table expressions a lot but may not have given them much thought as a tool for query...
Rob Farley

These Aren't the Joins You're Looking for... (AD-319-S)
Ever write a query and find that the join doesn't quite do what you were wanting? You look at the...
Rob Farley

T-SQL: Bad Habits and Best Practices (AD-209-S)
Not 100% confident in your T-SQL coding skills? This session is for you! The most common bad T-SQL...
Aaron Bertrand

BI Information Delivery

BI Power Hour (BID-215-S)
The legacy continues. The Microsoft Business Intelligence team is excited to once again present the...
Matt Masson, Adam Wilson, Kasper de Jonge, Matthew Roche, Patrick LeBlanc, Riccardo Muti

Ninja Data Moves in Office 2013 (BID-216-S)
With the release of Excel 2013, many new features have taken what has always been the most popular...
Brian Knight

BI Platform Architecture, Development & Administration

Automate Your ETL Infrastructure with SSIS and PowerShell (BIA-210-S)
Much of your ETL process flow consists of packages that are very similar in structure, capturing...
Allen White

Data Mining in SQL Server Analysis Services (BIA-211-S)
Data mining is one of the key hidden gems in SQL Server Analysis Services, but it has traditionally...
Brian Knight

Reduce, Reuse, Recycle: Automating Your BI Framework  (BIA-315-S)
Quite frankly, some aspects of building out a business intelligence solution are tedious. As you...
Stacia Varga

What Is a BI DBA? (BIA-212-S)
In addition to the database engine, SQL Server offers a powerful business intelligence solution,...
Jorge Segarra

Cloud Application Development & Deployment

Query Performance Tuning for Azure SQL Database (CLD-309-S)
Just because you're using an Azure SQL Database doesn't mean you can avoid tuning queries....
Grant Fritchey

Windows Azure Deep Dive (CLD-310-S)
Don’t miss this deep dive spotlight session on all things Windows Azure from Microsoft Technical...
Mark Russinovich

Enterprise Database Administration & Deployment

Data Internals Deep Dive (DBA-502-S)
Often as DBAs, we learn backwards. You get a DBA job, and you have databases that have tables,...
Bradley Ball

Dos and Don’ts of Database Corruption  (DBA-320-S)
Database corruption is one of the worst things you can encounter as a DBA. It can result in...
Gail Shaw

How to Tell When Storage Is a Problem (DBA-208-S)
You suspect that storage has been slowing down your SQL Server, but you're not sure how to prove...
Kendra Little

Making the Leap from Profiler to Extended Events (DBA-209-S)
If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server....
Erin Stellato

Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (DBA-321-S)
When data distribution is heavily skewed, cardinality estimation (how many rows the query optimizer...
Kimberly Tripp

SQL Server 2014 and Sharks with Freakin’ Lasers (DBA-210-S)
SQL Server 2014 builds on the mission-critical capabilities delivered in prior releases by...
Dandy Weyn, Ari Schorr

SQL Server Archaeology: Dig into the Past with system_health (DBA-322-S)
Archaeologists dig to find meaning and historical facts about events that occurred in the past, and...
Jonathan Kehayias

Squeezing Top Performance from Your Virtualized SQL Server (DBA-323-S)
Just about anyone can click through a SQL Server installation and get it working, but more than a...
David Klee

Troubleshooting Clusters (DBA-324-S)
Whether you are new to clusters or have years of experience, you may still cross your fingers when...
Allan Hirt

Waits, Latches, and Spinlocks: Internals and Analysis (DBA-503-S)
One of the first things you should check when investigating performance issues is wait statistics,...
Paul Randal

Professional Development

Building a Better Team Through Feedback (PD-201-S)
Imagine trying to steer a car blindfolded. How about shooting a jump shot without being able to see...
Joe Webb

Never Have to Say "Mayday!!!" Again (PD-202-S)
December 1978: 10 people die in a commercial airliner. Why? Bad troubleshooting skills and poor...
Mike Walsh