Here is our schedule for the upcoming event. We've done our best to provide a good mix of topics and skill levels, we hope you'll find something of interest throughout the day. Our thanks to the speakers listed below for volunteering their time, we couldn't do it without them. If there are schedule changes we will make them here as they happen. We encourage you to check back a few days before the event just in case we have had to move one of your favorite sessions.

Note: Some speakers alternately upload their sessions to their own blog sites, which you can locate their site when you click on their session below.

Start TimeTrack 1 - Room: Woodfield BTrack 3 - Room: Elk RoomTrack 4 - Room: Village RoomTrack 2 - Room: Woodfield A
08:30 AMSQLSaturday Chicago

Welcome and Keynote

Level: Intermediate
09:00 AMJeremiah Peschka

A Dynamic World Demands Dynamic SQL

Level: Intermediate
Tim Ford


Level: Intermediate
David Levy

Getting Out from Behind the Curtain - The New DBA

Level: Beginner
10:00 AMKevin Kline


Level: Advanced
Brent Ozar

Perfmon & Profiler 101

Level: Beginner
Jorge Segarra

SQL University 201: More DBA Fun

Level: Intermediate
Wes Dumey

Building a Data Warehouse using SQL Server 2008

Level: Beginner
11:00 AMKevin Kline

Stored Procedure Best Practices

Level: Intermediate
Aaron Nelson

PowerShell for Data Professionals

Level: Beginner

Ross LoForte

Proactive DBA: Manage SQL Server Better

Level: Beginner
12:00 PMSQLSaturday Chicago

Vendor Session A

Level: Beginner
12:30 PMSQLSaturday Chicago

Vendor Session B

Level: Beginner
01:00 PMBrent Ozar

BLITZ! 60 Minute Server Takeovers

Level: Intermediate
Jason Strate

Using XML to Query Execution Plans

Level: Intermediate
Tim Ford

Tools for The Driven, But Lazy DBA

Level: Beginner
02:00 PMChuck Heinzelman Michael Steineke

Oh Cluster, My Cluster!

Level: Intermediate
Jason Strate

Extended Events, Work Smarter Not Harder

Level: Intermediate
Jorge Segarra

Policy Based Management 101

Level: Beginner
Adam Jorgensen

Zero to Cube in 60 Minutes

Level: Intermediate
03:00 PMBrad McGehee

How and When to Use Indexed Views

Level: Intermediate
Dean Richards

Wait-Time Based Performance Management

Level: Intermediate
Jeremiah Peschka

Fundamentals of SQL Server Internals

Level: Intermediate
Andrew Karcher

One Developers Journey into MDX

Level: Beginner
04:00 PMBrad McGehee

Introduction to Graphical Execution Plans

Level: Beginner
Derek Comingore

Delivering Rapid Business Value with Microsoft BI

Level: Advanced
Arie Jones

Working with Spatial Data in SQL Server 2008

Level: Intermediate
Devin Knight

Analysis Services Partitions and Aggregations

Level: Beginner
05:00 PMAlex Kuznetsov

Defensive programming with Transact SQL

Level: Beginner
Arie Jones

Reporting Services 2008 Unleashed!

Level: Intermediate
Aaron King

The Benefits of SQL Azure

Level: Beginner
06:00 PMSQLSaturday Chicago

Ask the Experts Q&A

Level: Intermediate
07:00 PMSQLSaturday Chicago

After Party

Level: Beginner

Submitted Sessions

Here is the list of sessions submitted so far. Our goal is to feature as many different speakers and topics as possible, but space limitations prevent us from accepting every session. This list is also a great way for those thinking about speaking to see what might be on the agenda and enter a session that doesn't collide with an existing one.

Introduction to Graphical Execution PlansBrad McGeheeBeginner
3 Years of Database Unit Testing: Lessons LearnedAlex KuznetsovBeginner
A Dynamic World Demands Dynamic SQLJeremiah PeschkaIntermediate
Advanced i18n and L10n in SQL Server 2008Troy KetsdeverIntermediate
After PartySQLSaturday ChicagoBeginner
Analysis Services Partitions and AggregationsDevin KnightBeginner
As a DBA, Where do I start?!Mike WalshBeginner
Ask the Experts Q&ASQLSaturday ChicagoIntermediate
Automating DBA Tasks with PowershellArie JonesIntermediate
Avoid these common problems with data integrityAlex KuznetsovBeginner
Best Practices Every SQL Server DBA Must KnowBrad McGeheeBeginner
BLITZ! 60 Minute Server TakeoversBrent OzarIntermediate
Building a Data Warehouse using SQL Server 2008Wes DumeyBeginner
Compare MS SQL Server clusteringAlexander PrusakovBeginner
Database Maintenance EssentialsBrad McGeheeBeginner
Defensive programming with Transact SQLAlex KuznetsovBeginner
Delivering Rapid Business Value with Microsoft BIDerek ComingoreAdvanced
Dude, Where’s My Data? Excel Data Sources in SSISMark VaillancourtIntermediate
Extended Events in SQL Server 2008Arie JonesIntermediate
Extended Events, Work Smarter Not HarderJason StrateIntermediate
Fundamentals of SQL Server InternalsJeremiah PeschkaIntermediate
Getting Out from Behind the Curtain - The New DBADavid LevyBeginner
Getting the Most Out of the SQL Server ProfilerBrad McGeheeIntermediate
Getting To Know Your IndexesJason StrateIntermediate
How and When to Use Indexed ViewsBrad McGeheeIntermediate
How to Back Up and Protect SQL Server DatabasesBrad McGeheeBeginner
How to Optimize tempdb PerformanceBrad McGeheeIntermediate
How to Restore Databases in an EmergencyBrad McGeheeBeginner
How to Use the Maintenance Plan WizardBrad McGeheeIntermediate
Identifying Performance Problems Using SQL TraceBrad McGeheeIntermediate
Improving Daily Imports with Partitioned TablesJason StrateIntermediate
Indexes and Other Free Performance BoostsJeremiah PeschkaIntermediate
Introduction to SQL Server Integration ServicesBrad SchachtBeginner
Multipathing: The Key to Fast SANsBrent OzarAdvanced
Not Your Typical ETL Platform: SSIS 2008 Arie JonesIntermediate
Oh Cluster, My Cluster!Chuck Heinzelman Michael SteinekeIntermediate
One Developers Journey into MDXAndrew KarcherBeginner
Perfmon & Profiler 101Brent OzarBeginner
Policy Based Management 101Jorge SegarraBeginner
Policy Management with SQL Server 2008Arie JonesIntermediate
PowerShell for Data ProfessionalsAaron NelsonBeginner
Proactive DBA: Manage SQL Server Better Ross LoForteBeginner
Proud to be DBA, am I?Alexander PrusakovIntermediate
Real & Right Time BI with Attunity CDC Suite Derek ComingoreIntermediate
Reporting Services 2008 Unleashed! Arie JonesIntermediate
Reporting Services SubscriptionsDevin KnightIntermediate
Reporting Services, A DBA's Tool?Jason HallBeginner
Securing Analysis Services 2008David BaldauffIntermediate
So... You've Inherited "The DB From Heck"Troy KetsdeverIntermediate
Solving Business Pains with SQL Server IntegrationJason StrateIntermediate
SQL DMVs, DMFs, DMOs. WTH?Tim FordIntermediate
SQL Server PowerPivot for Information ProducersDerek ComingoreBeginner
SQL Server PowerPivot for IT ProsDerek ComingoreIntermediate
SQL Service BrokersDan CrawfordIntermediate
SQL University 101:Starting the SQL JourneyJorge SegarraBeginner
SQL University 201: More DBA FunJorge SegarraIntermediate
Stored Procedure Best PracticesKevin KlineIntermediate
TBDKevin KlineAdvanced
Telecommuting Tips for the DBATim FordBeginner
The Benefits of SQL AzureAaron KingBeginner
Tools for The Driven, But Lazy DBATim FordBeginner
Twitter and SQL: A Perfect UNION MINIJorge SegarraBeginner
Using SQL Azure and the Sync FrameworkAaron KingBeginner
Using StreamInsightAaron KingBeginner
Using the Maintenance Plan DesignerBrad McGeheeIntermediate
Using XML to Query Execution PlansJason StrateIntermediate
Vendor Session ASQLSaturday ChicagoBeginner
Vendor Session BSQLSaturday ChicagoBeginner
Virtualize This!Aaron NelsonBeginner
Wait-Time Based Performance ManagementDean RichardsIntermediate
Welcome and KeynoteSQLSaturday ChicagoIntermediate
What's new in SQL Server 2008 R2: SSRSAndrew KarcherIntermediate
Working with Spatial Data in SQL Server 2008Arie JonesIntermediate
You Can Improve Your Own SQL CodeMike WalshBeginner
Zero to Cube in 60 MinutesAdam JorgensenIntermediate

Suggested Sessions

Thinking about participating as a speaker but no ideas for the topic? Often our attendees will have an idea for you! Or, submit a suggestion of your own.

Suggested Session TitleSkill Level
Database Migrations without downtimeIntermediate
Disaster Recovery with a small budgetBeginner
Mirroring 101Beginner

SQLSaturday Home