Schedule

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: Session titles with an '*' have a download available.

Start TimeTrack 1Track 3Track 4Track 2
08:30 AMSQLSaturday Chicago
Welcome and Keynote
   
09:00 AMJeremiah Peschka
A Dynamic World Demands Dynamic SQL
Tim Ford
SQL DMVs, DMFs, DMOs. WTH?
David Levy
Getting Out from Behind the Curtain - The New DBA
 
10:00 AMKevin Kline
TBD
Brent Ozar
Perfmon & Profiler 101
Jorge Segarra
SQL University 201: More DBA Fun
Wes Dumey
Building a Data Warehouse using SQL Server 2008
11:00 AMKevin Kline
Stored Procedure Best Practices
Aaron Nelson
PowerShell for Data Professionals*
Ross LoForte
Proactive DBA: Manage SQL Server Better
 
12:00 PMSQLSaturday Chicago
Vendor Session A
   
12:30 PMSQLSaturday Chicago
Vendor Session B
   
01:00 PMBrent Ozar
BLITZ! 60 Minute Server Takeovers
Jason Strate
Using XML to Query Execution Plans
Tim Ford
Tools for The Driven, But Lazy DBA
 
02:00 PMChuck Heinzelman Michael Steineke
Oh Cluster, My Cluster!
Jason Strate
Extended Events, Work Smarter Not Harder
Jorge Segarra
Policy Based Management 101
Adam Jorgensen
Zero to Cube in 60 Minutes
03:00 PMBrad McGehee
How and When to Use Indexed Views
Dean Richards
Wait-Time Based Performance Management
Jeremiah Peschka
Fundamentals of SQL Server Internals
Andrew Karcher
One Developers Journey into MDX
04:00 PMBrad McGehee
Introduction to Graphical Execution Plans
Derek Comingore
Delivering Rapid Business Value with Microsoft BI
Arie Jones
Working with Spatial Data in SQL Server 2008
Devin Knight
Analysis Services Partitions and Aggregations
05:00 PMAlex Kuznetsov
Defensive programming with Transact SQL
Arie Jones
Reporting Services 2008 Unleashed!
Aaron King
The Benefits of SQL Azure
 
06:00 PMSQLSaturday Chicago
Ask the Experts Q&A
   
07:00 PMSQLSaturday Chicago
After Party
   


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.

TitleSpeakerLevel
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