Community Experts Picks
These must-see session lists were put together for this year's Summit by these well-respected members of the SQL Server community: Adam Machanic, Davide Mauri, Grant Fritchey, Brent Ozar, Rob Farley & Jessica Moss
Adam Machanic's "So You Want to Be a SQL Badass" PASS Summit Schedule
Tuesday, November 9
Identify and Fixing Performance Problems using Execution Plans (AD-371-S)
Grant Fritchey
Session on SQL developer tools (DBA-371-M)
Don Box
Best Practices for Data Warehousing with SQL Server 2008 and 2008 R2 (DBA-362-M)
Eric Hanson
Si Se Puede! Achieving Separation of Duties with SQL Server (DBA-448-M)
Il-Sung Lee & Lara Rubbelke
What Happened? Auditing, Tracking, and Change Monitoring Technologies in SQL Server 2008 (DBA-386-S)
Adam Machanic
Wednesday, November 10
CSS Update Queries - Under the Hood (90min) (DBA-588-C)
Conor Cunningham
The Incredible Shrinking Execution Plan (AD-311)
Rob Farley
High Performance Batch Processing in SQL (AD-313)
Simon Sabin
Inside SQL Server Latches (90 mins) (DBA-599-C)
Bob Ward
Thursday, November 11
Query tuning Tips (AD-475-S)
Itzik Ben-Gan
Expert Query Performance Troubleshooting (DBA-449-M)
Boris Baryshnikov
What's new in T-SQL in the Next Release of SQL Server (DBA-346-M)
Tobias Ternstrom
Seeking SQL Server Secrets (DBA-284-S)
Kalen Delaney
Friday, November 12
A Day of Doing Many Things at Once: Multitasking, Parallelism, and Process Distribution (AD-311-P)
Adam Machanic
Davide Mauri
Tuesday, November 9
SQLCAT: Designing scalable and complex Analysis Service Cubes: Lessons learned from the Field (90 mins) (BIA-499-A)
Denny Lee
Comparing PowerPivot with Analysis Services (BIA-412)
Chris Webb
Avoid Slow SSAS Queries: MDX Query Troubleshooting (BIA-413)
Craig Utley
Best Practices for Data Warehousing with SQL Server 2008 and 2008 R2 (DBA-362-M)
Eric Hanson
SQLCAT: Optimizing application workload & performance by leveraging AppFabric Cache along with SQL Server (AD-386-A)
Rama Ramani
Tracking Waits with Extended Events in SQL Server 2008 (DBA-492-S)
Andrew Kelly
Wednesday, November 10
CSS Update Queries – Under the Hood (90 min) (DBA-588-C)
Conor Cunningham
Business Intelligence and the Cloud (75R1) (BIA-379-M)
Russ Humphries & Vasile Paraschiv
Realizing ROI for Business Intelligence Projects (BIA-203)
Douglas McDowell
Kerberos, SQL and You (DBA-499-C)
Adam Saxton
Scaling OLTP Application: My app doesn’t scale, you wonder why? (AD-390-M)
Kevin Cox
Building NextGen Scalable & Highly Available Architectures with Microsoft SQL Server 2008 R2 (DBA-461)
Rajinder Gill
What’s coming next in SSIS (BIA-380-M)
Matt Masson
Inside SQL Server Latches (90 min) (DBA-599-C)
Bob Ward
SQLCAT: Administering SQL Azure and new challenges for DBAs (DBA-358-A)
George Varghese
Managing system performance with the Data Collector and Management Data Warehouse with Reporting Services (DBA-450-M)
Bill Ramos
Thursday, November 11
Query Tuning Tips (AD-475-S)
Itzik Ben-Gan
Enterprise SQL IO optimization best practices (DBA-359-M)
Kevin Farlee
Expert Query Performance Troubleshooting (DBA449-M)
Boris Baryshnikov & Conor Cunningham
Implementing a Data Cleansing Component for SSIS (BIA-414)
John Welch
Consolidating data collection with SQLDIAG and analysing it all with SQLNexus (DBA-378)
Christian Bolton
What's new in T-SQL in the Next Release of SQL Server (DBA-346-M)
Tobias Ternstrom
SQLCAT: Next Generation Real Time Data Processing using StreamInsight (AD-485-A)
Mark Simms
Migrating & Authoring Applications to Microsoft SQL Azure (AD-391-M)
Cihan Biykoglu
Grant Fritchey's Must See Sessions:
Tuesday, November 9
The “Numbers” or “Tally” Table: What it is and how it replaces a loop (AD-204)
Jeff Moden
Thursday, November 11
Query Tuning Tips (AD-475-S)
Itzik Ben-Gan
Seeking SQL Server Secrets (DBA284-S)
Kalen Delany
Database Testing Overview ((AD-314)
Buck Woody
Heaps of Trouble, Clusters of Glory (DBA-248)
Michelle Ufford
Brent Ozar
Tuesday, November 9
Identifying and Fixing Performance Problems using Execution Plans (AD-371-S)
Grant Fritchey
Introduction to SQL Server Statistics (DBA-238)
Andy Warren
Wednesday, November 10
CSS Update Queries – Under the Hood (DBA-588-C)
Conor Cunningham
The Incredible Shrinking Execution Plan (AD-311)
Rob Farley
The Art of Indexing (DBA-253)
Ken Simmons
Tales from the Trenches: GUIDs - Use, Abuse, and How to Move Forward (AD-372-S)
Kimberly Tripp
Thursday, November 11
DBA Mythbusters (DBA-285-S)
Paul Randal
Expert Query Performance Troubleshooting (DBA-449-M)
Boris Baryshnikov & Conor Cunningham
High Performance Functions (AD-312)
Simon Sabin
Consolidating data collection with SQLDIAG and analysing it all with SQLNexus (DBA-378)
Christian Bolton
Heaps of Trouble, Clusters of Glory - A Look at Index Internals (DBA-248)
Michelle Ufford
Performance Tuning with the Plan Cache (DBA-246)
Jonathan Kehayias
Database Design Fundamentals (AD-270-S)
Louis Davidson
Rob Farley
Tuesday, November 9
Comparing PowerPivot with Analysis Services (BIA-412)
Chris Webb
Avoid Slow SSAS Queries: MDX Query Troubleshooting (BIA-413)
Craig Utley
Demystifying MDX in Reporting Services (BID-218)
Stacia Misner
Thursday, November 11
Real World Analysis Services Stored Procedures (BIA-206)
Stacia Misner
Debugging Performance Problems in Analysis Services (BIA-311)
Tim Peterson
Jessica M Moss
Tuesday, November 9
Top SSRS session - Ad Hoc Reporting Revisited (BID-274-M)
Carolyn Chau & Thierry D'Hers
Top Real World SSAS Session - SQLCAT: Designing scalable and complex Analysis Service
Cubes: Lessons learned from the Field (90 mins) (BIA-499-A)
Denny Lee & Thomas Kejser
Best Session for a Summit BI First Timer - Business Intelligence Power Hour (BID-275-M)
Carlson Quick
Most Forward Thinking BI Session - Comparing PowerPivot with Analysis Services (BIA-412)
Chris Webb
Wednesday, November 10
Crowd Favorite BI Session - Business Intelligence – end-to-end (BIA-299-M)
Donald Farmer, Pej Javaheri & Russ Humphries
Jessica's "Won't Miss" BI Session - What’s coming next in SSIS (BIA-380-M)
Matt Masson
Thursday, November 11
Most Unique SSIS Session - Implementing a Data Cleansing Component for SSIS (BIA-414)
John Welch