24 Hours of PASS Session Overviews
Click on each session for detailed information about the presenter and session. All session times are listed in GMT (UTC) for September 2, 2009. To determine what time each session will be aired in your region, use this external time zone converter.
You can access each session 30 minutes prior to the session start time by clicking on the Attend Meeting Now links listed for each session below. You will be asked to supply your name and email address before entering the live session.
Thank you to our sponsor Strategy Companion for making 24 Hours of PASS possible. Please click here to find out more about Strategy Companion's Analyzer product:
"This video highlights the various features available within Analyzer™, our industry-leading Business Intelligence front-end for Microsoft's SQL Server platform. See how the incredibly easy-to-use Analyzer™ allows even non-technical users to become productive quickly, performing powerful analysis and building visually compelling dashboards and flexible reports. A wide variety of components, including pivot tables, charts, Key Performance Indicator (KPI) scorecards, dashboards, web pages, Reporting Services® reports, and more, lets users create custom information by just dragging and dropping onto the page."
Session 01 (Dev) – Start time: 00:00 GMT
10 Big Ideas in Database Design
Presenters: Louis Davidson and Paul Nielsen
Attend Meeting Now
Session 02 (DBA) - Start time: 01:00 GMT
Using PowerShell to Get the Most Out of SQL Server
Presenter: Allen White
Attend Meeting Now
Session 03 (PD) - Start time: 02:00 GMT
Team Management Fundamentals
Presenter: Kevin Kline
Attend Meeting Now
Session 04 (BI) – Start time 03:00 GMT
Delivering Good Performance Consistently with SSIS
Presenter: John Welch
Attend Meeting Now
Session 05 (DBA) – Start time 04:00 GMT
Using SQLdiag to Troubleshoot SQL Server Problems
Presenter: Brad McGehee
Attend Meeting Now
Session 06 (DBA) - Start time 05:00 GMT
The SQL Server 2008 Vanishing Act
Presenter: Peter Ward
Attend Meeting Now
Session 07 (BI) – Start time 06:00 GMT
Text Mining
Presenter: Dejan Sarka
Attend Meeting Now
Session 08 (Dev) – Start time 07:00 GMT
Tips and Tricks for Writing SET Based Queries
Presenter: Jacob Sebastian
Attend Meeting Now
Session 09 (DBA) – Start time 08:00 GMT
Mirrored Databases
Presenter: Thomas Grohser
Attend Meeting Now
Session 10 (Dev) – Start time 09:00 GMT
Working with Spatial Data in SQL Server 2008
Presenter: Greg Low
Attend Meeting Now
Session 11 (DBA) – Start time 10:00 GMT
Effective Indexing
Presenter: Gail Shaw
Attend Meeting Now
Session 12 (BI) – Start time 11:00 GMT
Reporting Services Inside Out: The Things You Should Know
Presenter: Simon Sabin
Attend Meeting Now
Session 13 (DBA) – Start time 12:00 GMT
Query Performance Tuning 101
Presenter: Grant Fritchey
Attend Meeting Now
Session 14 (BI) – Start time 13:00 GMT
Reporting from Analysis Services Cubes Using Excel 2007
Presenter: Peter Myers
Attend Meeting Now
Session 15 (BI) – Start time 14:00 GMT
Data Warehousing: Laying the Foundation to Success
Presenter: Erik Veerman
Attend Meeting Now
Session 16 (DBA) – Start time 15:00 GMT
Database Compatibility Settings: What They Really Do... and Don’t Do
Presenter: Don Vilen
Attend Meeting Now
Session 17 (PD) – Start time 16:00 GMT
Building a Better Blog
Presenter: Steve Jones
Attend Meeting Now
Session 18 (Dev) – Start time 17:00 GMT
Building Flexible Data Services for the Web Using the ADO .NET Data Services Framework
Presenter: Artemakis Artemiou
Attend Meeting Now
Session 19 (Dev) – Start time 18:00 GMT
SQLCLR or T-SQL? A Brief Survey of Performance Options
Presenter: Adam Machanic
Attend Meeting Now
Session 20 (BI) – Start time 19:00 GMT
Loading a Data Warehouse in SSIS
Presenter: Brian Knight
Attend Meeting Now
Session 21 (DBA) – Start time 20:00 GMT
What's Simple about Simple Recovery Model
Presenter: Kalen Delaney
Attend Meeting Now
Session 22 (Dev) – Start time 21:00 GMT
What's New, Harder, and Easier in SQL Server 2008 Security
Presenter: Don Kiely
Attend Meeting Now
Session 23 (DBA) – Start time 22:00 GMT
Analyzing File and Wait Statistics
Presenter: Andrew Kelly
Attend Meeting Now
Session 24 (BI): Start time 23:00 GMT
Embed Reporting Services into Your Applications
Presenter: Jessica Moss
Attend Meeting Now
*Depending on your location, sessions may also be broadcast on Sept. 1 and Sept. 3, 2009. 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.