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 TimeTrack 1 - Room: Room 308Track 2 - Room: Room 310Track 3 - Room: Room 205Track 4 - Room: Room 314Track 5 - Room: Room 203Track 6 - Room: Room 320
08:30 AMSQL Saturday

Welcome Discussion and Snacks

Level: Non-Technical
SQL Saturday

Welcome Discussion and Snacks

Level: Non-Technical
SQL Saturday

Welcome Discussion and Snacks

Level: Non-Technical
SQL Saturday

Welcome Discussion and Snacks

Level: Non-Technical
SQL Saturday

Welcome Discussion and Snacks

Level: Non-Technical
SQL Saturday

Welcome Discussion and Snacks

Level: Non-Technical
09:00 AMAndrew Kelly

Performance Monitoring 101

Level: Intermediate

download
Andy Leonard

“I See a Control Flow Tab. Now What?” (Level 100)

Level: Beginner
Steve Simon

Database design for mere developers

Level: Intermediate

download
Mark Vaillancourt

MDX Trek: First Contact

Level: Beginner
Robert McCauley

Big Data with SQL Standard Edition - True Story

Level: Intermediate

download
William E. Pearson III

Beyond Plateaux: Optimize SSAS with Best Practices

Level: Intermediate
10:20 AMSQL Saturday

Speed Networking & Special Raffle (AM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (AM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (AM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (AM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (AM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (AM Session)

Level: Non-Technical
10:45 AMJoseph D'Antoni

SQL 2012 -- All About HA and DR

Level: Intermediate
Matt Masson

EIM - Bringing Together SSIS, DQS, and MDS (300)

Level: Intermediate
Slava Kokaev

Introduction to BI Semantic Model (BISM)

Level: Beginner
John Miner

Effective use of temporary tables

Level: Intermediate

download
Andy Roberts

Introduction to SQL Azure

Level: Beginner
William E. Pearson III

Bridging the Chasm: BI Theory vs. Practice

Level: Beginner
1:15 PMMike Walsh

DBA Worst Practices, Disasters and Horror Stories

Level: Beginner
Matt Masson

SSIS 2012 – Overview and Changes

Level: Beginner
Andy Novick

Faster Stored Procedures and Functions

Level: Intermediate
Flannery John

Advanced Transactional Replication

Level: Intermediate

download
Steve Simon

Alright,WHY is the server REALLY running so slow!

Level: Intermediate

download
Sunil Kadimdiwan

PowerPivot & Power View: Create Impressive Reports

Level: Beginner
2:35 PMSQL Saturday

Speed Networking & Special Raffle (PM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (PM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (PM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (PM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (PM Session)

Level: Non-Technical
SQL Saturday

Speed Networking & Special Raffle (PM Session)

Level: Non-Technical
3:00 PMAndrew Kelly

SQL2012 Query & Procedure Call Statistics

Level: Intermediate

download
Andy Leonard

Designing an SSIS Framework

Level: Advanced
Joseph D'Antoni

Way Too Deep--Inside AlwaysOn

Level: Advanced
Aaron Bertrand

T-SQL : Bad Habits to Kick

Level: Beginner

download
Andy Roberts

Database Development ALM with SQL Server Data Tool

Level: Beginner
William E. Pearson III

Overcoming Barriers and Avoiding Mistakes with BI

Level: Beginner
4:20 PMSQL Saturday

Prize Raffle and Wrap Up

Level: Non-Technical
SQL Saturday

Prize Raffle and Wrap Up

Level: Non-Technical
SQL Saturday

Prize Raffle and Wrap Up

Level: Non-Technical
SQL Saturday

Prize Raffle and Wrap Up

Level: Non-Technical
SQL Saturday

Prize Raffle and Wrap Up

Level: Non-Technical
SQL Saturday

Prize Raffle and Wrap Up

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.

TitleSpeakerLevel
SSIS Enhancements in SQL Server 2012Andy RobertsIntermediate
“I See a Control Flow Tab. Now What?” (Level 100)Andy LeonardBeginner
A dive into Data Quality ServicesSteve SimonBeginner
Advanced Transactional ReplicationFlannery JohnIntermediate
Alright,WHY is the server REALLY running so slow!Steve SimonIntermediate
Attribute Discretization in Analysis Services 2012William E. Pearson IIIBeginner
Beautiful things always recur Steve SimonIntermediate
Becoming DAX: An Introduction ...William E. Pearson IIIIntermediate
Best Practices for Configuring SQL ServerAndrew KellyIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Big Data with SQL Standard Edition - True StoryRobert McCauleyIntermediate
Bridging the Chasm: BI Theory vs. PracticeWilliam E. Pearson IIIBeginner
Creating efficient and effective SSRS BI SolutionsSteve SimonIntermediate
Database design for mere developers Steve SimonIntermediate
Database Development ALM with SQL Server Data ToolAndy RobertsBeginner
DBA Worst Practices, Disasters and Horror StoriesMike WalshBeginner
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Designing an SSIS Framework Andy LeonardAdvanced
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Effective use of temporary tablesJohn MinerIntermediate
Effective use of temporary tablesJohn MinerIntermediate
Efficient On-Premise to Cloud Data TransferMatt MassonIntermediate
EIM - Bringing Together SSIS, DQS, and MDS (300)Matt MassonIntermediate
Encryption in SQL 2012 - Column and TDE Flannery JohnIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Faster Stored Procedures and FunctionsAndy NovickIntermediate
Full Text Indexing BasicsJohn MinerIntermediate
Get your Mining Model Predictions out to allSteve SimonIntermediate
Getting Started with MDX: The (Very) BasicsWilliam E. Pearson IIIBeginner
Getting to Know your DBJason BrimhallBeginner
Introduction to BI Semantic Model (BISM) Slava KokaevBeginner
Introduction to SQL AzureAndy RobertsBeginner
Loading the CloudAndy LeonardBeginner
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Master Data Service decodedSteve SimonBeginner
MDX Trek: First ContactMark VaillancourtBeginner
Overcoming Barriers and Avoiding Mistakes with BIWilliam E. Pearson IIIBeginner
Performance Monitoring 101Andrew KellyIntermediate
PowerPivot & Power View: Create Impressive ReportsSunil KadimdiwanBeginner
PowerPivot for Excel: For Those Unacquainted ...William E. Pearson IIIBeginner
Prize Raffle and Wrap UpSQL SaturdayNon-Technical
Prototype with PowerPivot: External SSAS GroupsWilliam E. Pearson IIIIntermediate
Query Plan Tuning for BeginnersJoe MurphreeBeginner
Reciprocal Symmetry: MDX in PowerPivotWilliam E. Pearson IIIIntermediate
Reporting Services for Mere DBAsJason BrimhallIntermediate
Running SQL Server 2012 on Windows Azure IaaSAndy RobertsIntermediate
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
Speed Networking & Special Raffle (AM Session)SQL SaturdayNon-Technical
Speed Networking & Special Raffle (PM Session)SQL SaturdayNon-Technical
SQL 2012 -- All About HA and DRJoseph D'AntoniIntermediate
SQL Server 2012 AlwaysOn Availability GroupsAndy RobertsIntermediate
SQL Server 2012..Advances in window functions Steve SimonIntermediate
SQL Server Statistics - A User's GuideJoe MurphreeIntermediate
SQL2012 Query & Procedure Call StatisticsAndrew KellyIntermediate
SSAS 2012 Tabular vs. MultidimensionalWilliam E. Pearson IIIBeginner
SSIS 2012 – Overview and ChangesMatt MassonBeginner
SSIS 2012 : Keeping ahead of the curveSteve SimonIntermediate
SSRS 2012. No slight of hands to fantastic resultsSteve SimonIntermediate
Table CompressionJason BrimhallAdvanced
The Ins & Outs of Contained DatabasesAaron BertrandBeginner
T-SQL : Bad Habits to KickAaron BertrandBeginner
T-SQL Enhancements in SQL Server 2012 Andy RobertsIntermediate
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Way Too Deep--Inside AlwaysOnJoseph D'AntoniAdvanced
Welcome Discussion and SnacksSQL SaturdayNon-Technical
What’s coming in Hyper-V for Windows 8 and WindowsAndy RobertsBeginner


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.

SQLSaturday Home
PASS