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: 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 Time	BI / SSAS 1 - Room: Room 5	BI / SSAS 2 - Room: Room 6	DBA 1 - Room: Room 1	DBA 2 - Room: Room 2	Developer - Room: Room 3	Professional Development - Room: Room 4
07:30 AM	SQLSaturday 173 Registrations Level: Non-Technical	SQLSaturday 173 Registrations Level: Non-Technical	SQLSaturday 173 Registrations Level: Non-Technical	SQLSaturday 173 Registrations Level: Non-Technical	SQLSaturday 173 Registrations Level: Non-Technical	SQLSaturday 173 Registrations Level: Non-Technical
08:30 AM	SQLSAT DC Opening Remarks Level: Non-Technical	SQLSAT DC Opening Remarks Level: Non-Technical	SQLSAT DC Opening Remarks Level: Non-Technical	SQLSAT DC Opening Remarks Level: Non-Technical	SQLSAT DC Opening Remarks Level: Non-Technical	SQLSAT DC Opening Remarks Level: Non-Technical
9:00 AM	SQLSAT DC Panel discussion - Big Data Level: Non-Technical	SQLSAT DC Panel discussion - DW / BI Level: Non-Technical	SQLSAT DC Panel discussion - HA, DR & Replication Level: Non-Technical	SQLSAT DC Panel discussion - Performance Level: Non-Technical	Mike Walsh DBA Worst Practices, Disasters and Horror Stories Level: Beginner	SQLSAT DC Panel discussion - Professional Development Level: Beginner
10:15 AM	Geoff Johnson Using Expressions to Avoid Three SSRS Annoyances Level: Intermediate	Paul Rizza Shortcuts to Building SSIS in .Net Level: Intermediate	Steven Wright Resource Governor for SQL Server Level: Intermediate	David Klee Virtualizing Business Critical SQL Servers Level: Intermediate	Wayne Sheffield Windowing Functions in SQL Server 2012 Level: Intermediate	Kevin Goode Let's Talk Licensing Level: Intermediate
11:30 AM	Kevin Goff SQL Server 2012 Columnstore index Level: Intermediate	Jason Thomas Advanced Charting Techniques in SSRS Level: Intermediate	Allen White PowerShell 101 for the SQL Server DBA Level: Beginner	Tim Radney Know Backups and Know Recovery Level: Intermediate	Kevin Boles SQL Server 2012 TSQL Enhancements and Additions Level: Intermediate	Ryan Brickey DBA’s1st Date - Getting to know a new environment Level: Beginner
12:30 PM	SQLSaturday 173 Lunch Break Level: Non-Technical	SQLSaturday 173 Lunch Break Level: Non-Technical	SQLSaturday 173 Lunch Break Level: Non-Technical	SQLSaturday 173 Lunch Break Level: Non-Technical	SQLSaturday 173 Lunch Break Level: Non-Technical	SQLSaturday 173 Lunch Break Level: Non-Technical
01:30 PM	William E Pearson III Getting Started with MDX: The (Very) Basics Level: Beginner	derek dai “ColumnStore” Indexes for Fast EDW Query Level: Intermediate	Wayne Sheffield Table Vars & Temp Tables - What you NEED to Know! Level: Intermediate	Joseph D'Antoni SQL 2012 -- All About HA and DR Level: Intermediate	Konstatin Melamud PerfTuning: Intro To Execution Plan Analysis Level: Beginner	Jason Hall Recipe for a happy DBA Level: Beginner
02:45 PM	Jason Horner Isn't that Spatial! (BI Edition) Level: Beginner	Stacia Misner Taking BI to the Next Level: Collaboration Level: Intermediate	Ira Whiteside (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own Level: Intermediate	Michael Corey Virtualizing SQL 2012: Doing It Right Level: Intermediate	Rob Volk Revenge: The SQL! Level: Intermediate	Brian Moran The Art of Questions and success as an IT Pro Level: Beginner
04:00 PM	Andy Leonard Loading Data Warehouse Partitions with SSIS 2012 Level: Intermediate	John Sterrett Performance Tuning for Pirates Level: Advanced	Carlton Ramsey How PowerShell helps me as a DBA Level: Beginner	Kevin Boles Common TSQL Mistakes Level: Intermediate	Rob Volk Revenge: The SQL Part 2: The Sequel! Level: Intermediate	Eddie Wuerch Join Us! Getting Started as a Technical Speaker Level: Beginner
05:15 PM	SQLSaturday 173 Raffle/Closing Remarks Level: Non-Technical	SQLSaturday 173 Raffle/Closing Remarks Level: Non-Technical	SQLSaturday 173 Raffle/Closing Remarks Level: Non-Technical	SQLSaturday 173 Raffle/Closing Remarks Level: Non-Technical	SQLSaturday 173 Raffle/Closing Remarks Level: Non-Technical	SQLSaturday 173 Raffle/Closing Remarks Level: Non-Technical

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
Isn't that Spatial! (BI Edition)	Jason Horner	Beginner
PoSh Eye for the BI Guy	Jason Horner	Beginner
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own	Ira Whiteside	Intermediate
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own	Ira Whiteside	Intermediate
(Way Too Much) Fun with Reporting Services	Stacia Misner	Beginner
“ColumnStore” Indexes for Fast EDW Query	derek dai	Intermediate
5 Common SQL Server Performance Issues	Jason Hall	Intermediate
Advanced Charting Techniques in SSRS	Jason Thomas	Intermediate
Building a Foundation for Self-Service BI	Stacia Misner	Intermediate
Coffee Break	SQLSatruday 173	Beginner
Common TSQL Mistakes	Kevin Boles	Intermediate
Communicate for Great Good!	Matt Velic	Beginner
Creating a Metadata Mart w/ SSIS - Data Governance	Ira Whiteside	Intermediate
Data Files and Transaction Logs – Beyond the GUIs	Sandra Mueller	Beginner
Database And Websites And College, Oh My!	Peg LeDell	Beginner
Database Health and Performance	David Klee	Intermediate
DBA Worst Practices, Disasters and Horror Stories	Mike Walsh	Beginner
DBA’s1st Date - Getting to know a new environment	Ryan Brickey	Beginner
Design and Implement BI Like Edison!	William E Pearson III	Beginner
Designing an SSIS Framework	Andy Leonard	Advanced
Designing Custom Maintenance Plans with TSQL	John Miner	Intermediate
Developing Date and Role-Playing Dimensions	Sandra Mueller	Intermediate
Dimensional Modeling: Beyond the Basics	Jason Horner	Beginner
Disaster Lessons for Technologists	Mike Walsh	Beginner
Enterprise-Ready ETL Solutions using SSIS 2012	Jon Tupitza	Beginner
Fast Track to Spatial Reporting Using SSRS 2012	Jason Thomas	Intermediate
Full Text Indexing Basics	John Miner	Beginner
Fundamentals of Join Operations	Kevin Boles	Beginner
Gather SQL Server Performance Data with PowerShell	Allen White	Intermediate
Getting involved and Getting ahead	Tim Radney	Beginner
Getting Started with MDX: The (Very) Basics	William E Pearson III	Beginner
Getting Started with MDX: The (Very) Basics	William E Pearson III	Beginner
Hadoop on WindowsAzure in Action	Wenming Ye	Beginner
How PowerShell helps me as a DBA	Carlton Ramsey	Beginner
How to audit and prevent unwanted user actions.	John Miner	Intermediate
Intro to Common Table Expressions	Geoff Johnson	Beginner
It is TEMPDB, Why Should You Care?	Tim Radney	Intermediate
Join Us! Getting Started as a Technical Speaker	Eddie Wuerch	Beginner
Know Backups and Know Recovery	Tim Radney	Intermediate
Let's Talk Licensing	Kevin Goode	Intermediate
Loading Data Warehouse Partitions with SSIS 2012	Andy Leonard	Intermediate
Lunch Break	SQLSaturday 173	Non-Technical
Mapping Features in SSRS, PowerView and Tableau	Jason Thomas	Beginner
Minimally Invasive - Tools to Doctor Up Your Code	Wayne Sheffield	Intermediate
Mobile Business Intelligence for Everyone, Now!	Jen Stirrup	Intermediate
Much Ado About Indexes - Tips, Tricks and TSQL	Robert Pearl	Beginner
Opening Remarks	SQLSAT DC	Non-Technical
Overcoming Barriers and Avoiding Mistakes with BI	William E Pearson III	Beginner
Overview of PowerPivot	David Eichner	Beginner
Panel discussion - Big Data	SQLSAT DC	Non-Technical
Panel discussion - DW / BI	SQLSAT DC	Non-Technical
Panel discussion - HA, DR & Replication	SQLSAT DC	Non-Technical
Panel discussion - Performance	SQLSAT DC	Non-Technical
Panel Discussion - PowerShell	SQLSAT DC	Non-Technical
Panel discussion - Professional Development	SQLSAT DC	Beginner
Panel discussion - Reports	SQLSAT DC	Non-Technical
Partitioning for Perf & Management of Large Tables	Eddie Wuerch	Intermediate
Performance Tuning for Pirates	John Sterrett	Advanced
Performance Tuning- Index Optimization	Konstatin Melamud	Intermediate
PerfTuning: Intro To Execution Plan Analysis	Konstatin Melamud	Beginner
Platinum Sponsor presentation - Grid Iron Systems	SQLSAT DC	Beginner
Possible Musics: SSAS Multidimensional vs Tabular	William E Pearson III	Intermediate
Power View from the Data Visualisation Perspective	Jen Stirrup	Intermediate
Power View: A Peek Behind the Curtain	Stacia Misner	Beginner
PowerShell 101 for the SQL Server DBA	Allen White	Beginner
Prototype with PowerPivot: External SSAS Groups	William E Pearson III	Intermediate
Raffle/Closing Remarks	SQLSaturday 173	Non-Technical
Recipe for a happy DBA	Jason Hall	Beginner
Reciprocal Symmetry: MDX in PowerPivot	William E Pearson III	Intermediate
Registrations	SQLSaturday 173	Non-Technical
Reporting Services for Mere DBAs	Jason Brimhall	Intermediate
Resource Governor for SQL Server	Steven Wright	Intermediate
Revenge: The SQL Part 2: The Sequel!	Rob Volk	Intermediate
Revenge: The SQL!	Rob Volk	Intermediate
Roping the Elephant - Hadoop and BI Live!	Adam Jorgensen	Intermediate
Running SQL Server 2012 as a Windows Azure VM	Timothy McAliley	Intermediate
Self-Service BI - Is it for you?	Sandra Mueller	Beginner
Sets and Relations and Queries, Oh My!	Allen White	Beginner
Shade Tree Mechanic's Guide to SSAS	Steven Wright	Beginner
SharePoint COOP Using 2008R2 Log Shipping	Ken Hausman	Advanced
SharePoint COOP Using 2008R2 Log Shipping	Donald Scott	Advanced
SharePoint COOP Using SQL Server 2012 Always-On	Ken Hausman	Intermediate
SharePoint COOP Using SQL Server 2012 Always-On	Donald Scott	Intermediate
Shortcuts to Building SSIS in .Net	Paul Rizza	Intermediate
Sizing up SQL Azure	Carlos Chacon	Beginner
SQL 2012 -- All About HA and DR	Joseph D'Antoni	Intermediate
SQL 2012 Extended Events	Jason Brimhall	Advanced
SQL Azure - What is it and why do you need it?	Scott Klein	Beginner
SQL Azure Scalability with Federations	Scott Klein	Intermediate
SQL Injection	Kevin Boles	Intermediate
SQL Internals - Indexes	Kevin Goode	Intermediate
SQL Server 2012 Column Store Index	Kevin Boles	Intermediate
SQL Server 2012 Columnstore index	Kevin Goff	Intermediate
SQL Server 2012 TSQL Enhancements and Additions	Kevin Boles	Intermediate
SRS Report Builder for Business Intelligence	David Eichner	Beginner
SSRS 2008R2 Reporting Gallery	Kevin Goff	Intermediate
Table Compression	Jason Brimhall	Advanced
Table Partitioning made easy!	John Sterrett	Beginner
Table Vars & Temp Tables - What you NEED to Know!	Wayne Sheffield	Intermediate
Taking BI to the Next Level: Collaboration	Stacia Misner	Intermediate
Tame Your Unruly Data...With Constraints!	Rob Volk	Beginner
Tax, Finance, and Money Tips for consultants	Brian Moran	Beginner
TempDB Performance Troubleshooting and Optimizing	Eddie Wuerch	Intermediate
Ten Common SQL Server Mistakes!	John Sterrett	Beginner
The Art of Questions and success as an IT Pro	Brian Moran	Beginner
The new tabular model in Analysis Services 2012	Kevin Goff	Intermediate
Transaction Log Deep Dive	Kevin Boles	Advanced
T-SQL for Application Developers - Attendees chose	Kevin Goff	Intermediate
Upgrading to SSIS 2012	Paul Rizza	Intermediate
Using Expressions to Avoid Three SSRS Annoyances	Geoff Johnson	Intermediate
Virtualizing Business Critical SQL Servers	David Klee	Intermediate
Virtualizing SQL 2012: Doing It Right	Michael Corey	Intermediate
Way Too Deep--Inside AlwaysOn	Joseph D'Antoni	Advanced
Windowing Functions in SQL Server 2012	Wayne Sheffield	Intermediate
You Inherited a Database, Now What?	Tim Radney	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.