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: 214	Track 2 - Room: 116	Track 3 - Room: 216	Track 4 - Room: 217	Track 5 - Room: 117	Track 6 - Room: 118	Track 7 - Room: 215	Track 8 - Room: 218
7:30 AM	SQL Saturday Registration Level: Beginner
9:15 AM	Bob Pusateri The Skinny on Data Compression Level: Intermediate	Warren Sifre Introduction to FileTables in SQL 2012* Level: Intermediate	David Klee Virtualizing Business Critical SQL Servers Level: Intermediate	Craig Purnell Upgrade Roadmap: Let’s delve into SQL Server 2012 * Level: Intermediate	Josh Fennessy Administering the BI Stack* Level: Intermediate	Mark Vaillancourt MDX Trek: First Contact Level: Beginner	Dave Levy Writing Faster SQL Server Queries Level: Advanced	Aaron King A Complete BI Solution in About an Hour! Level: Beginner
10:45 AM	Mark Tabladillo Enterprise Data Mining with SQL Server* Level: Intermediate	Brent Ozar BLITZ! One Hour SQL Server Takeovers Level: Beginner	Ross LoForte Microsoft Big Data Level: Beginner	Christina Leo What's Buried in the Plan Cache?* Level: Intermediate	Hope Foley Performance Tuning 2012 SSIS Data Loads* Level: Intermediate	Ted Krueger Query Tuning for Developers and DBAs* Level: Beginner	David Eichner SRS Report Builder for Business Intelligence Level: Beginner	Shelly Noll NoSQL: Know Your Enemy* Level: Beginner
12:00 PM	SQL Saturday Lunch Level: Beginner	Wendy Pastrick Women In Technology Panel Level: Beginner			SQL Saturday You Rock Sponsor Session Level: Beginner	SQL Saturday You Rock Sponsor Session Level: Beginner
01:00 PM	Allan Hirt Is That A Failover Cluster On Your Laptop/Desktop? Level: Intermediate	Andy Thiru SQL Azure Intro and What’s New Level: Beginner	Tim Ford The Periodic Table of Dynamic Management Objects Level: Intermediate	Jason Strate Getting to Know Index Operation Stats Level: Intermediate	Bill Fellows Kama Sutra of SSIS: A guide to loving ETL* Level: Beginner	Scott Shaw Licensing SQL Server in a Virtual Environment Level: Intermediate	Jes Borland Reporting Services 201: From Basic To WOW! Level: Intermediate	Dave Levy Ask the Experts - Anything and Everything Level: Beginner
2:30 PM	Kevin Boles SQL Server 2012 Column Store Index* Level: Intermediate	Ben DeBow Build Your Own SQL Server Private Cloud Level: Intermediate	Arie Jones Master Data Services in SQL Server 2012 Level: Intermediate	Argenis Fernandez Troubleshooting SQL Server with SysInternals Tools Level: Advanced	Norman Kelm The Script Task, powerhouse of SSIS Level: Beginner	Janis Griffin Don't Panic, DBAs! Databases on VMware made easy.* Level: Intermediate	Rob Farley Analytic T-SQL Functions in 2012 Level: Intermediate	Colleen Morrow So I started this blog... now what?* Level: Beginner
04:00 PM	Luke Jian Optimizing SQL Server I/O with Solid State Drives* Level: Intermediate	Tom Norman Compliance and Auditing in Sql Server Level: Beginner	Erin Stellato DBCC Commands: The Quick and the Dangerous* Level: Beginner	Mike Donnelly Advancements in CDC with SSIS in SQL 2012* Level: Beginner	Michael Sexton Error Handling in ETL Level: Beginner	Aaron Lowe Writing Professional Database Code Level: Intermediate	Rob Farley SARGability Level: Intermediate	Eddie Wuerch Join Us! Getting Started as a Technical Speaker* Level: Beginner
5:30 PM	SQL Saturday SQL Saturday Closing Events 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.

Title	Speaker	Level
GASP Real-time user defined sets in SSAS	Josh Fennessy	Advanced
2012 TSQL Sweets	Bill Fellows	Intermediate
A Complete BI Solution in About an Hour!	Aaron King	Beginner
A Preview of High Availability in SQL Server 2012	Allan Hirt	Intermediate
Administering the BI Stack	Josh Fennessy	Intermediate
Advancements in CDC with SSIS in SQL 2012	Mike Donnelly	Beginner
Analytic T-SQL Functions in 2012	Rob Farley	Intermediate
Anatomy of a Join	Luke Jian	Intermediate
Applied Enterprise Semantic Mining	Mark Tabladillo	Intermediate
Ask the Experts - Anything and Everything	Dave Levy	Beginner
Asynchronous programming with Service Broker	sanil mhatre	Beginner
Attribute Discretization in Analysis Services (BI)	William E. Pearson III	Beginner
Backups & Recovery 201	Bob Pusateri	Intermediate
Bad Indexes	Rob Farley	Intermediate
Be Your Own SQL SWAT Team	Ben DeBow	Intermediate
Becoming DAX: An Introduction ...	William E. Pearson III	Intermediate
Beyond Plateaux: Optimize SSAS with Best Practices	William E. Pearson III	Intermediate
BI in the Cloud with SQL Azure Reporting	Eric Boyd	Intermediate
BLITZ! One Hour SQL Server Takeovers	Brent Ozar	Beginner
Bridging the Chasm: BI Theory vs. Practice	William E. Pearson III	Beginner
Build Your Own SQL Server Private Cloud	Ben DeBow	Intermediate
Choose Your Own Adventure: Performance Tuning	Tim Chapman	Advanced
Common TSQL Mistakes	Kevin Boles	Intermediate
Compliance and Auditing in Sql Server	Tom Norman	Beginner
Contained DB? Did it do something wrong?	Warren Sifre	Beginner
Data Mining with Excel 2010 and PowerPivot	Mark Tabladillo	Intermediate
Database Development using SQL Server Data Tools	Aaron Lowe	Beginner
DBA Superstar: CMS, PBM and EPMF in 45 minutes.	Argenis Fernandez	Intermediate
DBCC Commands: The Quick and the Dangerous	Erin Stellato	Beginner
Design and Implement BI Like Edison!	William E. Pearson III	Beginner
Discovering the Plan Cache	Jason Strate	Intermediate
Documenting Your Integrated Microsoft BI Solution	William E. Pearson III	Intermediate
Don't Panic, DBAs! Databases on VMware made easy.	Janis Griffin	Intermediate
Enterprise Data Mining with SQL Server	Mark Tabladillo	Intermediate
Entity Strategies: Structuring Your Consultancy	William E. Pearson III	Beginner
Error Handling in ETL	Michael Sexton	Beginner
ETL as MDM	Michael Sexton	Intermediate
Extended Events, Work Smarter Not Harder	Jason Strate	Intermediate
Filegroups: Putting the Puzzle Together	Jes Borland	Intermediate
Form And Substance: The “T” of ETL	Michael Sexton	Intermediate
Free SQL tools for your toolbox	Kevin Bullen	Beginner
Fundamentals of Join Operations	Kevin Boles	Beginner
Getting Started with MDX: The (Very) Basics	William E. Pearson III	Beginner
Getting started with PowerShell and SQL Server	Kevin Bullen	Beginner
Getting The Most From Your SQL Server	Ben DeBow	Intermediate
Getting to Know Index Operation Stats	Jason Strate	Intermediate
Going Deeper into Joins	Rob Farley	Intermediate
Holy Crap! Someone Put the Database in the Cloud	Jason Strate	Beginner
Introduction to FileTables in SQL 2012	Warren Sifre	Intermediate
Is That A Failover Cluster On Your Laptop/Desktop?	Allan Hirt	Intermediate
Join Us! Getting Started as a Technical Speaker	Eddie Wuerch	Beginner
Kama Sutra of SSIS: A guide to loving ETL	Bill Fellows	Beginner
Licensing SQL Server in a Virtual Environment	Scott Shaw	Intermediate
Little in the middle but got much [Write]Back	Josh Fennessy	Intermediate
Looking to the future - Tabular Mode SSAS	Josh Fennessy	Beginner
Looney Tuner? No, there IS a method to my madness	Janis Griffin	Intermediate
Lunch	SQL Saturday	Beginner
Make Your Voice Heard!	Jes Borland	Beginner
Many-to-Many: Multiple Calendars in a Single Cube	William E. Pearson III	Advanced
Master Data Services in SQL Server 2012	Arie Jones	Intermediate
MDX Trek: First Contact	Mark Vaillancourt	Beginner
Merge Replication for Offline Data Mobility	Ted Krueger	Beginner
Microsoft Big Data	Ross LoForte	Beginner
MS Access with SQL Server Strategies and Tips	Juan Soto	Beginner
New Tricks for Old Tasks in the Cloud	Jason Strate	Beginner
NoSQL: Know Your Enemy	Shelly Noll	Beginner
Optimizing SQL Server I/O with Solid State Drives	Luke Jian	Intermediate
Overcoming Barriers and Avoiding Mistakes with BI	William E. Pearson III	Beginner
Overview of the Windows Azure DataMarket	Eric Boyd	Beginner
Page Latches for Mere Mortals	Eddie Wuerch	Intermediate
Parallel Query Execution Deep Dive	Kevin Boles	Advanced
PBM and You!	Tom Norman	Beginner
Performance Enhancing Laziness	Tim Ford	Beginner
Performance Management – 2008 MDW - How & Why	Janis Griffin	Beginner
Performance Tuning 2012 SSIS Data Loads	Hope Foley	Intermediate
PowerPivot & BISM in SQL Server 2012	Hope Foley	Beginner
PowerPivot for Excel: For Those Unacquainted ...	William E. Pearson III	Beginner
PowerShell, the New SQL Hammer	Norman Kelm	Beginner
Powershell? Yea, but I'm a DBA!	Kyle Neier	Intermediate
Production is all Virtualized, Is Yours?	Tom Norman	Beginner
Professional Networking for IT Pros	Craig Purnell	Beginner
Query Tuning for Developers and DBAs	Ted Krueger	Beginner
Query Tuning Using Lessons Learned from SSIS	Rob Farley	Intermediate
Registration	SQL Saturday	Beginner
Reporting Services 201: From Basic To WOW!	Jes Borland	Intermediate
Rolling Upgrades Leveraging Database Mirroring	Argenis Fernandez	Intermediate
SARGability	Rob Farley	Intermediate
Searching for the Holy Grail of DDL Auditing	Colleen Morrow	Beginner
Security Auditing in SQL Server	Arie Jones	Intermediate
Serene Velocity: Reporting Services and SSAS Data	William E. Pearson III	Intermediate
Shrinking Execution Plans	Rob Farley	Intermediate
So I started this blog... now what?	Colleen Morrow	Beginner
So Many High Availability Options, So Little Time	Allan Hirt	Beginner
Social Marketing 2012 for Microsoft Professionals	Mark Tabladillo	Beginner
SQL Azure Federations - a real-life example	Scott Klein	Intermediate
SQL Azure Intro and What’s New	Andy Thiru	Beginner
SQL Azure vs. Azure Tables –Clearing The Confusion	Scott Klein	Intermediate
SQL Respawn: Strategies for Migrating Your Server	Argenis Fernandez	Intermediate
SQL Saturday Closing Events	SQL Saturday	Beginner
SQL Server 2012 Column Store Index	Kevin Boles	Intermediate
SQL Server 2012: A Window To T-SQL Enhancements	Jason Strate	Intermediate
SQL Server 2012: Using the Columnstore Index	Thomas Puch	Beginner
SQL Server Development Tips and Tricks	Roman Rehak	Beginner
SQL Server Dos and Don'ts: Keys to DBA Nirvana	Allan Hirt	Beginner
SQL Server Security H@ck3ry	Norman Kelm	Intermediate
SRS Report Builder for Business Intelligence	David Eichner	Beginner
SRS Report Builder for Business Intelligence	David Eichner	Beginner
SRS Report Builder for Business Intelligence	David Eichner	Beginner
SSIS 2012 Basics - Get Up to Speed in 60 minutes!	Ted Krueger	Beginner
SSIS 2012 Management Considerations and Best Pract	Rushabh Mehta	Intermediate
SSIS 2012 New Features	Norman Kelm	Beginner
SSIS 2012-Where did my green boxes go?	Kyle Neier	Beginner
SSIS: Figuring Out Configuring	Mike Donnelly	Intermediate
SSIS: The DBA Multiplier	Ted Krueger	Beginner
Storage Strategies in Windows Azure	Eric Boyd	Intermediate
Surviving Your Peak Database Load	Ben DeBow	Intermediate
Tasks, Where We're Going We Don't Need Tasks	Mike Donnelly	Beginner
TempDB Performance Troubleshooting and Optimizing	Eddie Wuerch	Intermediate
The MERGE Statement - T-SQL's Swiss Army Knife	Rob Farley	Intermediate
The Periodic Table of Dynamic Management Objects	Tim Ford	Intermediate
The Script Task, powerhouse of SSIS	Norman Kelm	Beginner
The Skinny on Data Compression	Bob Pusateri	Intermediate
The TSQL Road Less Traveled: MERGE	Kevin Boles	Intermediate
Throwing T-SQL 2012 Enhancements Against the Wall	Kyle Neier	Beginner
Transaction Log Deep Dive	Kevin Boles	Advanced
Triple Threat! SSIS + DQS + MDS 2012	Arie Jones	Intermediate
Troubleshooting SQL Server with SysInternals Tools	Argenis Fernandez	Advanced
TSQL Road Less Traveled: The Numbers Table	Kevin Boles	Intermediate
Type more, click less: using EzAPI to build SSIS	Bill Fellows	Advanced
Unit Testing made easy for database development	Sanil Mhatre	Intermediate
Upgrade Roadmap: Let’s delve into SQL Server 2012	Craig Purnell	Intermediate
Using MS Access as a BI Tool with SQL Server	Juan Soto	Intermediate
Utilizing Data Quality Services in SQL Server 2012	Arie Jones	Intermediate
Virtualizing Business Critical SQL Servers	David Klee	Intermediate
What a DBA should know about SQL Azure	Ross LoForte	Intermediate
What Are You Waiting For?	Jason Strate	Intermediate
What's Buried in the Plan Cache?	Christina Leo	Intermediate
What? I can't buy [Vendor]'s Monitoring Package?!?	Kyle Neier	Intermediate
Why Third Party Vendors Do The Things They Do	Henry Treftz	Intermediate
Women In Technology Panel	Wendy Pastrick	Beginner
Working with Server Side Traces	Christina Leo	Intermediate
Writing Faster SQL Server Queries	Dave Levy	Advanced
Writing Professional Database Code	Aaron Lowe	Intermediate
XQuery Basics for the DBA	Jason Strate	Intermediate
You Rock Sponsor Session	SQL Saturday	Beginner
You’re My Density: Making Sense of Statistics	Erin Stellato	Beginner
Your First Performance Tuning Class	Brent Ozar	Intermediate
Your First SQL Internals Class	Brent Ozar	Intermediate

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
Writting DML Triggers	Beginner