Thank you to our sponsors




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





24 Hours of PASS Session Details

Thank you to our sponsor DELL for making 24 Hours of PASS possible. Please click here to find out more about DELL's product:

"Dell has partnered with the Microsoft SQL Customer Lab, in Redmond Washington, to provide the highest performance server and storage hardware for customers working with the World's most demanding database workloads".


Click on each session for detailed information about the presenter and session. All session times are listed in GMT (UTC). The first session begins at 12:00 GMT on May 19. The last session ends at 12:00 GMT on May 20. To determine what time each session will be aired in your region, use this external time zone converter.

Sessions are arranged below by track. Tracks for this event include Business Intelligence (BI), Database Administration (DBA), Development (Dev), and Professional Development (PD). We've also highlighted R2-specific sessions in the session titles. Register for a session or several today. You can also see the sessions in chronological order (GMT) here.

Tracks:  BIDBA | Dev | PD 


BI Track

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

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

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

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

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

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

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

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

Session 20 (BI) – Start time 07:00 GMT
PowerPivot for Financial Decision Makers 
Presenter: Peter Ward


DBA Track

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

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 07 (DBA) – Start time 18:00 GMT
Filtered Indexes, Sparse Columns: Together, Separately
Presenter: Don Vilen

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

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

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

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

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

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


Dev Track

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

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

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

Session 21 (Dev) – Start time 08:00 GMT
Data Tier Applications 
Presenter: Jacob Sebastian

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


PD Track

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


*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