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 TimeMPT - Room: MPTS212 - Room: S212S213 - Room: S213S214 - Room: S214S216 - Room: S216
8:30 AMJohn Miner

Keynote & Welcome

Level: Beginner

download
John Miner

Keynote & Welcome

Level: Beginner

download
John Miner

Keynote & Welcome

Level: Beginner

download
John Miner

Keynote & Welcome

Level: Beginner

download
John Miner

Keynote & Welcome

Level: Beginner

download
8:45 AMScott Abrants

Policy Based Management –manage consistency

Level: Intermediate

download
Mike Walsh

As a DBA, Where Do I Start!?

Level: Beginner
Andy Roberts

DB Development ALM with SQL Server Data Tools

Level: Beginner
Mike Hillwig

New Server in an Hour? No Problem!

Level: Intermediate

download
Paresh Motiwala

DBA to Project Manager in 75 minutes flat

Level: Advanced

download
10:00 AMJeff Moden

The Tally Table: What it is/how it replaces loops

Level: Intermediate

download
Mike Walsh

Iceberg, Dead Ahead!

Level: Beginner
Grant Fritchey

Top Tips for Writing Better T-SQL Queries

Level: Beginner
James Phillips

Loading a Data Warehouse using SSIS 2012

Level: Intermediate
John Miner

Full Text Indexing Basics

Level: Intermediate

download
11:15 AMAndy Roberts

Introduction to SQL Azure

Level: Beginner
Alex Papadimoulis

Database Deployment Done Right

Level: Intermediate
William E. Pearson III

Overcoming Barriers and Avoiding Mistakes with BI

Level: Beginner
Aaron Bertrand

T-SQL : Bad Habits to Kick

Level: Beginner

download
Wayne Sheffield

Windowing Functions in SQL Server 2012

Level: Intermediate

download
1:30 PMSteve SImon

Get your Mining Model Predictions out to all

Level: Intermediate

download
Jack Corbett

Transitioning from SQL Trace to Extended Events

Level: Intermediate

download
Mike Hillwig

Seven SQL Agent Jobs You Should be Running

Level: Beginner

download
John Miner

Designing Custom Maintenance Plans with TSQL

Level: Intermediate
Jim O'Neil

Scaling your Cloud Database with SQL Federations

Level: Intermediate
02:45 PMJason Brimhall

SQL 2012 Table Compression

Level: Advanced

download
Andy Novick

Biggest Loser: Database Edition

Level: Intermediate
Jeff Moden

Cross Tabs & Pivots - Reports on Steroids

Level: Intermediate

download
Sunil Kadimdiwan

Intuitive & ad-hoc reporting: SQL 2012 Power View

Level: Intermediate
Michael Corey

Virtualizing SQL 2012: Doing It Right

Level: Intermediate
04:00 PMParesh Motiwala

Network or Perish

Level: Advanced

download
Andy Roberts

SQL Server 2012 Availability Groups

Level: Intermediate
William E Pearson III

Getting Started with MDX: The (Very) Basics

Level: Beginner
Robert McCauley

Big Data with SQL Standard Edition - True Story

Level: Intermediate
Steve SImon

SSIS 2012 : Keeping ahead of the curve

Level: Intermediate

download
05:15 PMGrant Fritchey

What to Look for in Execution Plans

Level: Intermediate
Aaron Bertrand

The Ins & Outs of Contained Databases

Level: Beginner

download
William E. Pearson III

Serene Velocity: Reporting Services and SSAS Data

Level: Intermediate
Wayne Sheffield

Table Vars & Temp Tables - What you NEED to Know!

Level: Intermediate

download
Jason Brimhall

Reporting Services for Mere DBAs

Level: Intermediate

download
06:15 PMRaffle Time

Raffles

Level: Beginner
Raffle Time

Raffles

Level: Beginner
Raffle Time

Raffles

Level: Beginner
Raffle Time

Raffles

Level: Beginner
Raffle Time

Raffles

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.

TitleSpeakerLevel
A dive into Data Quality Services SQL Server 2012Steve SimonBeginner
Alright,WHY is the server REALLY running so slow!Steve SImonIntermediate
As a DBA, Where Do I Start!?Mike WalshBeginner
Beautiful things always recur Steve SImonIntermediate
Best Practices DocumentParesh MotiwalaAdvanced
Big Data with SQL Standard Edition - True StoryRobert McCauleyIntermediate
Biggest Loser: Database EditionAndy NovickIntermediate
Cancel Your Plans!Mike HillwigIntermediate
Creating efficient and effective SSRS BI SolutionsSteve SImonIntermediate
Cross Tabs & Pivots - Reports on SteroidsJeff ModenIntermediate
Database Deployment Done RightAlex PapadimoulisIntermediate
Database design for mere developers Steve SImonIntermediate
DB Development ALM with SQL Server Data ToolsAndy RobertsBeginner
DBA to Project Manager in 75 minutes flatParesh MotiwalaAdvanced
Designing Custom Maintenance Plans with TSQLJohn MinerIntermediate
Effective use of temporary tablesJohn MinerIntermediate
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
Hierarchies... on Steroids the No RBAR WayJeff ModenIntermediate
How Not to Be a Cranky DBAMike HillwigBeginner
Iceberg, Dead Ahead!Mike WalshBeginner
Introduction to SQL AzureAndy RobertsBeginner
Intuitive & ad-hoc reporting: SQL 2012 Power ViewSunil KadimdiwanIntermediate
Keynote & WelcomeJohn MinerBeginner
Loading a Data Warehouse using SSIS 2012James PhillipsIntermediate
Master Data Services decodedSteve SimonBeginner
Minimally Invasive - Tools to Doctor Up Your CodeWayne SheffieldIntermediate
MongoDB for the Relational DBAJustin DearingBeginner
Network or PerishParesh MotiwalaAdvanced
New Server in an Hour? No Problem!Mike HillwigIntermediate
Policy Based Management –manage consistencyScott AbrantsIntermediate
RafflesRaffle TimeBeginner
Reporting Services for Mere DBAsJason BrimhallIntermediate
Running SQL Server 2012 on Windows Azure IaaSAndy RobertsIntermediate
Scaling your Cloud Database with SQL FederationsJim O'NeilIntermediate
Seven SQL Agent Jobs You Should be RunningMike HillwigBeginner
SQL 2012 Table CompressionJason BrimhallAdvanced
SQL Agent MSX Server: One Process, Many ServersMike HillwigIntermediate
SQL Server 2012 Availability GroupsAndy RobertsIntermediate
SQL Server 2012..Advances in window functionsSteve SImonIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS 2012 : Keeping ahead of the curveSteve SImonIntermediate
SSIS Enhancements in SQL Server 2012Andy RobertsIntermediate
SSRS 2012. No slight of hands to fantastic resultsSteve SImonIntermediate
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
The Ins & Outs of Contained DatabasesAaron BertrandBeginner
The Tally Table: What it is/how it replaces loopsJeff ModenIntermediate
Top Tips for Writing Better T-SQL QueriesGrant FritcheyBeginner
Transitioning from SQL Trace to Extended EventsJack CorbettIntermediate
Treasure Hunting with MSDB: Finding Your GoldMike HillwigIntermediate
T-SQL : Bad Habits to KickAaron BertrandBeginner
T-SQL Enhancements in SQL Server 2012 Andy RobertsIntermediate
Virtualizing SQL 2012: Doing It RightMichael CoreyIntermediate
What to Look for in Execution PlansGrant FritcheyIntermediate
What’s coming in Hyper-V for Windows 8 and WindowsAndy RobertsBeginner
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate


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
Network or PerishAdvanced

SQLSaturday Home
PASS