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 Time	Track 1 - Room: SSIS	Track 2 - Room: BI (SSAS/SSRS)	Track 3 - Room: DBA (Monitoring/Optimization)	Track 4 - Room: Application Development	Track 5 - Room: Introductory Topics	Track 6 - Room: DBA
8:30 AM	Andy Leonard Build Your First SSIS Package * Level: Beginner	Rafael Salas Dimensional Modeling: Why Should You Care?* Level: Beginner	Sergey Pustovit SQL Server Performance Related DMVs * Level: Intermediate	Kevin Boles Common TSQL Programming Mistakes* Level: Intermediate	Flavio Almeida Self-Service BI with PowerPivot Level: Beginner	Geoff Hiten Clustering for Mere Mortals* Level: Intermediate
9:45 AM	John Welch Processing Flat Files with SSIS* Level: Intermediate	Mark Tabladillo Data Mining with PowerPivot 2010* Level: Intermediate	Jana Sattainathan Partitioning in SQL Server 2005/2008* Level: Intermediate	Tim Chapman How, where, why, and when to use Dynamic SQL* Level: Intermediate	Jessica Moss Who Needs a Data Warehouse?* Level: Beginner	Aaron Nelson The Dirty Dozen: PowerShell Scripts for Busy DBAs* Level: Beginner
11:00 AM	Chris Skorlinski Introduction to Change Data Capture* Level: Beginner	Mark Tabladillo Document Classification using DMX in SSAS* Level: Intermediate	Andrew Kelly Maximizing Plan Re-use in SQL 2008* Level: Intermediate	Kevin Goode Embracing the CLR* Level: Intermediate	Mike Davis Reporting Services 2008 R2, the New Stuff* Level: Beginner	Eric Humphrey Object Relational Mappers for the DBA* Level: Beginner
01:00 PM	John Welch Patterns for SSIS Configuration and Deployment* Level: Intermediate	William Pearson Attribute Discretization in Analysis Services* Level: Intermediate	Grant Fritchey Identifying and Fixing Performance Problems using * Level: Intermediate	Andy Leonard Database Design for Developers * Level: Intermediate	Jason Hall Recipe for a Happy DBA - A Guide for SQL Server De* Level: Beginner	Ed Wilson Windows PowerShell Best Practices for SQL DBA's* Level: Intermediate
02:15 PM	Andy Leonard SSIS Design Patterns* Level: Advanced	Steve Wright The Shade Tree Mechanic's Guide to SSAS* Level: Beginner	Thomas LaRock Performance Tuning Made Easy* Level: Intermediate	Allen White XQuery Basics* Level: Beginner	Geoff Hiten Bad SQL* Level: Intermediate	Andrew Kelly SQL Server Configuration Best Practices* Level: Beginner
3:30 PM	Chris Skorlinski Integrating CDC and SSIS for Incremental Data Load* Level: Advanced	Mike Davis Using Parameters in SQL Server Reporting Services * Level: Beginner	Kevin Goode Statistics, how to prove everything but the truth.* Level: Intermediate	Kevin Boles Advanced TSQL Solutions* Level: Advanced

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.

Title	Speaker	Level
How, where, why, and when to use Dynamic SQL	Tim Chapman	Intermediate
Advanced TSQL Solutions	Kevin Boles	Advanced
Attribute Discretization in Analysis Services	William Pearson	Intermediate
Automate SQL Server Administration with PowerShell	Allen White	Intermediate
Avoiding Disaster--Clusterining and Mirroring	Joseph D'Antoni	Intermediate
Bad SQL	Geoff Hiten	Intermediate
Build Your First SSIS Package	Andy Leonard	Beginner
Clustering for Mere Mortals	Geoff Hiten	Intermediate
Common TSQL Programming Mistakes	Kevin Boles	Intermediate
Consolidated SQL Server Architectures	Ben DeBow	Beginner
Creating Custom Components for SSIS	John Welch	Intermediate
Data Mining with PowerPivot 2010	Mark Tabladillo	Intermediate
Data Mining with PowerPivot 2010	Mark Tabladillo	Intermediate
Database Design for Developers	Andy Leonard	Intermediate
De-mystifying Query Plan Analysis	Dave Turpin	Intermediate
Delivering BI Solutions Rapidly using Vulcan	John Welch	Intermediate
Design and Implement Like Edison!	William Pearson	Beginner
Diagnosing connectivity issues with SQL Server	Evan Basalik	Intermediate
Dimensional Modeling: Why Should You Care?	Rafael Salas	Beginner
Document Classification using DMX in SSAS	Matthew Duffield	Intermediate
Document Classification using DMX in SSAS	Mark Tabladillo	Intermediate
Documenting Your Integrated Microsoft BI Solution	William Pearson	Beginner
Dynamics CRM & SSRS	Eric Humphrey	Beginner
Embracing the CLR	Kevin Goode	Intermediate
Extract, Transform, and Load your Data Warehouse	Jessica Moss	Beginner
Fortress SQL Server	Brian Kelley	Intermediate
Fuzzy logic and Conformed Dimensions	Matthew Duffield	Intermediate
Fuzzy logic and Conformed Dimensions	Matthew Duffield	Intermediate
Gather SQL Server Performance Data with PowerShell	Allen White	Advanced
How, where, why, and when to use Dynamic SQL	Tim Chapman	Intermediate
Identifying and Fixing Performance Problems using	Grant Fritchey	Intermediate
Integrating CDC and SSIS for Incremental Data Load	Chris Skorlinski	Advanced
Introduction to Change Data Capture	Chris Skorlinski	Beginner
Introduction to Incremental Loads	Andy Leonard	Intermediate
Introduction to Transactional Replication	Chris Skorlinski	Beginner
Make Reporting Services Work For You	Jessica Moss	Intermediate
Managing Server Work Load with Resource Governor	Flavio Almeida	Beginner
Maximizing Plan Re-use in SQL 2008	Andrew Kelly	Intermediate
Migrate Data with PowerShell and SQL Server	Allen White	Intermediate
Monitoring Transactional Replication Performance	Chris Skorlinski	Intermediate
Object Relational Mappers for the DBA	Eric Humphrey	Beginner
Parallel Query Execution Deep Dive	Kevin Boles	Advanced
Partitioning in SQL Server 2005/2008	Jana Sattainathan	Intermediate
Patterns for SSIS Configuration and Deployment	John Welch	Intermediate
Performance Tuning Made Easy	Thomas LaRock	Intermediate
Planning your ETL architecture with SSIS	Rafael Salas	Intermediate
PowerShell 2.0 Beyond the Dirty Dozen	Aaron Nelson	Intermediate
Processing Flat Files with SSIS	John Welch	Intermediate
Q & A -- Stump the Speakers	SQL Saturday	Beginner
Recipe for a Happy DBA - A Guide for SQL Server De	Jason Hall	Beginner
Red Gate Software	SQL Saturday	Beginner
Replication Comparison - Then and Now	Jason Hall	Intermediate
Reporting Services 2008 R2, the New Stuff	Mike Davis	Beginner
RESTful Data	Chris Eargle	Intermediate
Say NO to Maintenance Plans	Andrew Kelly	Intermediate
Schemas and Security, Oh My!	Brian Kelley	Intermediate
Self-Service BI with PowerPivot	Flavio Almeida	Beginner
SQL Azure: Your Data in the Cloud is a Good Thing	Evan Basalik	Beginner
SQL Server 2008/R2 Overview	Sergey Pustovit	Intermediate
SQL Server Configuration Best Practices	Andrew Kelly	Beginner
SQL Server Diagnostics Tools Unleashed	Sergey Pustovit	Intermediate
SQL Server Encryption Decrypted	Brian Kelley	Intermediate
SQL Server Memory Deep Dive	Kevin Boles	Advanced
SQL Server Performance Related DMVs	Sergey Pustovit	Intermediate
SQL Server Utility environment	Ben DeBow	Intermediate
SSIS Design Patterns	Andy Leonard	Advanced
SSIS Design Patterns	Andy Leonard	Advanced
Statistics, how to prove everything but the truth.	Kevin Goode	Intermediate
SWAG Give Away	SQL Saturday	Beginner
The Dirty Business of Auditing	Brian Kelley	Intermediate
The Dirty Dozen: PowerShell Scripts for Busy DBAs	Aaron Nelson	Beginner
The Shade Tree Mechanic's Guide to SSAS	Steve Wright	Beginner
Things To Do With PowerShell & SMO	Eric Humphrey	Beginner
Top 5 fastest ways as DBA to get fired	Chris Skorlinski	Beginner
Top 5 fastest ways as DBA to get fired	Chris Skorlinski	Beginner
Trigger Happy Database Security	Brian Kelley	Beginner
Troubleshooting SSRS Performance	Evan Basalik	Intermediate
Unit Testing SSIS Packages	John Welch	Intermediate
Using Parameters in SQL Server Reporting Services	Mike Davis	Beginner
Virtualizing SQL Best Practices	Amy Styers	Intermediate
VS 2010 DB tools: Schema Management Made Easier!	Rafael Salas	Beginner
What’s New in Reporting Services 2008 and 2008 R2?	William Pearson	Intermediate
Who Needs a Data Warehouse?	Jessica Moss	Beginner
Windows PowerShell Best Practices for SQL DBA's	Ed Wilson	Intermediate
XQuery Basics	Allen White	Beginner

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 Title	Skill Level
Change Management	Intermediate
Data Security and Encryption Deep Dive	Intermediate
Merge Replication	Intermediate
SSIS Deployment Strategies	Intermediate
Statistics and Performance	Intermediate
Team Foundation Server for SQL SERVER 2008	Intermediate