Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email Thank you for your patience.



Thank you to our sponsors




All 24 Hours of PASS registrants will automatically become PASS members. (membership is free!)





24 Hours of PASS - Hour 1 to Hour 24

(May 19, 12:00 GMT to May 20, 12:00 GMT)


May 19, 2010

Session 01 (BI) – Start time: 12:00 GMT
Introduction to PowerPivot  
Presenter: Brian Knight
Session URL: 

Session 02 (Dev) – Start time 13:00 GMT
Database Development Patterns
Presenter: Andy Leonard
Session URL:

Session 03 (BI) - Start time: 14:00 GMT
What Exactly is in SQL 2008 R2? 
Presenter: Kevin Cox
Session URL:

Session 04(DBA) – Start time 15:00 GMT
Getting Started with SQL Server Utility in SQL Server 2008 R2  
Presenter: Glenn Berry
Session URL:

Session 05 (Dev) – Start time 16:00 GMT
Data Tier Applications 
Presenter: Jacob Sebastian
Session URL:

Session 06 (DBA) - Start time 17:00 GMT
What's Really Happening on Your Server? 15 Powerful SQL Server Dynamic Management Objects
Presenter:  Adam Machanic
Session URL:

Session 07 (DBA) – Start time 18:00 GMT
Filtered Indexes, Sparse Columns: Together, Separately
Presenter: Don Vilen
Session URL:

Session 08 (BI) – Start time 19:00 GMT
Solving Common Business Problems with Microsoft PowerPivot  
Presenter: Donald Farmer
Session URL:

Session 09 (DBA) – Start time 20:00 GMT
Exploring SQL Server 2005 and 2008 Security
Presenter: Don Kiely
Session URL:

Session 10 (DBA) – Start time 21:00 GMT
Using Data Compression with SQL Server 2008 and 2008 R2 
Presenter: Maciej Pilecki
Session URL:

Session 11 (BI) – Start time 22:00 GMT
Easier than Ever Report Authoring in SSRS 2008 R2  
Presenter: Jessica M. Moss
Session URL:

Session 12 (Dev) – Start time 23:00 GMT
High Performance Functions
Presenter: Simon Sabin
Session URL:


May 20, 2010

Session 13 (PD) – Start time 00:00 GMT
Manage Your DBA Career, Don’t Let it Manage You
Presenter: Brad McGehee
Session URL:

Session 14 (DBA) – Start time 01:00 GMT
Top 10 Mistakes on SQL Server
Presenter: Kevin Kline
Session URL:

Session 15 (BI) – Start time 02:00 GMT
Producing Dashboards with PerformancePoint Services  
Presenter: Peter Myers
Session URL:

Session 16 (BI) – Start time 03:00 GMT
Reporting Services Enhancements in SQL Server 2008  
Presenter: Greg Low
Session URL:

Session 17 (Dev) – Start time 04:00 GMT
SQL Tuning - Get it Right the First Time
Presenter: Dean Richards
Session URL:

Session 18 (BI) – Start time 05:00 GMT
Managing SSIS Package Deployments with Powershell
Presenter: Sean McCown
Session URL:

Session 19 (DBA): Start time 06:00 GMT
Multi-Server Management With UCP, MDW and PBM  
Presenter: Chuck Heinzelman
Session URL:

Session 20 (Dev) – Start time 07:00 GMT
New Session: Advanced T-SQL Query Tuning Techniques 
Presenter: Rob Farley
Session URL:

Session 21 (BI) – Start time 08:00 GMT
Implementing MDM Using SQL Server 2008 R2 Master Data Services  
Presenter: Rushabh Mehta
Session URL:

Session 22 (DBA) – Start time 09:00 GMT
SQL 2008 R2 How to Manage CPU’s, Cores and CPU Groups  
Presenter: Thomas Grohser
Session URL:

Session 23 (Dev) – Start time 10:00 GMT
Database Design Fundamentals
Presenter: Louis Davidson
Session URL: 

Session 24 (DBA) - Start time: 11:00 GMT
BLITZ! 60 Minute Server Takeovers
Presenter: Brent Ozar
Session URL: 

*Please be sure to check our time zone guide for exact times. When you register using our LiveMeeting interface, sessions will be sent to your Outlook calendar for the correct time in your region.


Check out the speaker lineup!



Copyright 2013 by PASS | Terms Of Use | Privacy Statement | Login