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