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 1Track 2 - Room: Room 2Track 3 - Room: Room 3Track 4 (special) - Room: Room 4
08:00 AMJen Stirrup

Mobile Business Intelligence for Everyone, Now!

Level: Intermediate
Neil Hambly

Extended Events – New Age of Profiling

Level: Intermediate
David Peter Hansen

Layered Partitioning - (re)load your data fast

Level: Advanced
Mark Pryce-Maher

Creating SSMS 2012 Add-ins for Crash Test Dummies

Level: Intermediate
09:05 AMSQLSaturday 162

Keynote - Buck Woody

Level: Beginner
SQLSaturday 162

Keynote - Buck Woody

Level: Beginner
SQLSaturday 162

Keynote - Buck Woody

Level: Beginner
SQLSaturday 162

Keynote - Buck Woody

Level: Beginner
09:20 AMAaron Bertrand

T-SQL : Bad Habits and Best Practices

Level: Intermediate
Andrè Kamman

Practical PoSh – Design and build larger scripts

Level: Intermediate
Tobiasz Koprowski

2 AM. A Disaster just began...

Level: Intermediate
Chris Testa-O'Neill

Understanding Microsoft Certification in SQL Serve

Level: Beginner
10:20 AMAndy Leonard

Designing an SSIS Framework

Level: Advanced
David Morrison

Query Plan Operators Deep Dive

Level: Advanced
Niko Neugebauer

Inheriting a database for Developers

Level: Intermediate
Gavin Payne

I want to be a better architect

Level: Intermediate
11:25 AMBuck Woody

Windows Azure from a Data Perspective

Level: Advanced
Dave Ballantyne

What's new in SQL Server 2012 - TSQL

Level: Intermediate
Duncan Sutcliffe

The Magic of SQL Server 2012 BI in SharePoint

Level: Beginner
Martin Cairns

Partitioning Design for Performance and Maintainab

Level: Intermediate

download
12:20 PMSQLSaturday 162

Lunch Break & Sponsor Sessions

Level: Intermediate
Red Gate

Improving DB Development with SQL Source Control

Level: Beginner
SQLSaturday 162

Lunch Break & Sponsor Sessions

Level: Intermediate
SQLSaturday 162

Lunch Break & Sponsor Sessions

Level: Intermediate
01:35 PMBob Duffy

SQL 2012 Always On-Deep Dive

Level: Intermediate
Hugo Kornelis

Make Your Queries Fly With Columnstore Indexes

Level: Intermediate

download
SQLSaturday 162

Red Gate followed by Lightning Talks

Level: Beginner
Peter Baddeley

I work with SQL why should I care about SharePoint

Level: Beginner
02:35 PMAllan Mitchell

SQL Server 2012 SSIS Change Data Capture

Level: Advanced
Mark S. Rasmussen

Optimizing Storage and Performance Using Page and

Level: Advanced
Rob Volk

Tame Your Unruly Data...With Constraints!

Level: Beginner

download
Tobiasz Koprowski

Welcome to the Licensing Nightmare

Level: Intermediate
03:50 PMChris Webb

Intro to Tabular Model in Analysis Services 2012

Level: Intermediate
James Boother

Troubleshooting SQL Server with PowerShell

Level: Intermediate
Alex Whittles

Merge-tastic: a better way of loading dimensions

Level: Advanced
Phil Quinn

XML: The Marmite of SQL Server

Level: Beginner
04:50 PMChris Testa-O'Neill

Notes on SQL 2012 Highly Available BI Environments

Level: Intermediate
Bruno Basto

SQL Internal Storage

Level: Advanced
Gavin Payne

NUMA Internals of SQL Server 2012

Level: Advanced
Mark Broadbent

READPAST & Furious-Transactions.Locking.Isolation.

Level: Intermediate
05:45 PMSQLSaturday 162

Prize Draw

Level: Beginner
SQLSaturday 162

Prize Draw

Level: Beginner
SQLSaturday 162

Prize Draw

Level: Beginner
SQLSaturday 162

Prize Draw

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
"Cursors are Evil"Dave BallantyneIntermediate
“I See a Control Flow Tab. Now What?” (Level 100)Andy LeonardBeginner
2 AM. A Disaster just began...Tobiasz KoprowskiIntermediate
Analysis Services for the DBAMark StaceyBeginner
Are you sure your query returns the right data setSuleman MohammedLightning Talk
Backup & Recovery - better and worse practicesTobiasz KoprowskiIntermediate
Change Tracking or Change Data CaptureDavid Peter HansenAdvanced
Create a Monit Server for SQL Using PowerShellLaerte JuniorAdvanced
Creating SSMS 2012 Add-ins for Crash Test DummiesMark Pryce-MaherLightning Talk
Creating SSMS 2012 Add-ins for Crash Test Dummies Mark Pryce-MaherIntermediate
Data architecture toolkit on OS XEric LawsonLightning Talk
Data Packaging Unleashed :)Niko NeugebauerBeginner
Database deployment horrorsDave BallantyneIntermediate
Designing an SSIS Framework Andy LeonardAdvanced
Do you do daily health checksSuleman MohammedLightning Talk
Effective Data Management using Data CompressionNeil HamblyIntermediate
ETL Frameworks with Dynamic SSIS PackagesNiko NeugebauerAdvanced
Extended Events – New Age of ProfilingNeil HamblyIntermediate
Getting Dimensional with DataChris Testa-O'NeillIntermediate
High Availability of SQL in the context of SLATobiasz KoprowskiIntermediate
I want to be a better architectGavin PayneIntermediate
I work with SQL why should I care about SharePointPeter BaddeleyBeginner
Improving DB Development with SQL Source ControlRed GateBeginner
Inheriting a database for DevelopersNiko NeugebauerIntermediate
Intro to Tabular Model in Analysis Services 2012Chris WebbIntermediate
Introduction to DAX Queries and CalculationsChris WebbAdvanced
Kerberos In One Hour (2012 Edition)Duncan SutcliffeAdvanced
Keynote - Buck WoodySQLSaturday 162Beginner
Layered Partitioning - (re)load your data fastDavid Peter HansenAdvanced
Learned Lessons with T-SQL Enhancements SQL 2012Niko NeugebauerBeginner
Load Testing Analysis ServicesBob DuffyIntermediate
Loading the CloudAndy LeonardBeginner
Lunch Break & Sponsor SessionsSQLSaturday 162Intermediate
Make Your Queries Fly With Columnstore IndexesHugo KornelisIntermediate
Merge-tastic: a better way of loading dimensionsAlex WhittlesAdvanced
Microsoft Access Power HourBob DuffyBeginner
Mobile Business Intelligence for Everyone, Now!Jen StirrupIntermediate
Notes on SQL 2012 Highly Available BI EnvironmentsChris Testa-O'NeillIntermediate
NUMA Internals of SQL Server 2012Gavin PayneAdvanced
Optimizing Storage and Performance Using Page and Mark S. RasmussenAdvanced
Partitioning Design for Performance and MaintainabMartin CairnsIntermediate
PowerPivot with NASA dataMark StaceyIntermediate
Practical PoSh – Design and build larger scriptsAndrè KammanIntermediate
Prize DrawSQLSaturday 162Beginner
Query Plan Operators Deep DiveDavid MorrisonAdvanced
READPAST & Furious-Transactions.Locking.Isolation.Mark BroadbentIntermediate
Red Gate followed by Lightning TalksSQLSaturday 162Beginner
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
Scooby-doo, Where Are You? Using Postcodes in SQL Mark Pryce-MaherLightning Talk
Seeing double with SQL Server replicationGavin PayneIntermediate
Slowly changing dimensions- an integrated approachMark StaceyIntermediate
SQL 2012 Always On-Deep DiveBob DuffyIntermediate
SQL Internal StorageBruno BastoAdvanced
SQL Server 2012 AlwaysOn: TAPThomas PullenIntermediate
SQL Server 2012 Memory ManagementNeil HamblyIntermediate
SQL Server 2012 SSIS Change Data CaptureAllan MitchellAdvanced
SQL Server AlwaysOn for DummiesMark BroadbentBeginner
Storing Character Data OptimallyMark S. RasmussenAdvanced
Tame Your Unruly Data...With Constraints!Rob VolkBeginner
TBDSQLSaturday 162Intermediate
The Goodness of Merge Statement Suleman MohammedLightning Talk
The Magic of SQL Server 2012 BI in SharePointDuncan SutcliffeBeginner
The PoSh DBA: Grown-Up PowerShell FunctionsLaerte JuniorIntermediate
Top Tricks to Teach Your .NET DevelopersMark S. RasmussenIntermediate
Troubleshooting SQL Server with PowerShellLaerte JuniorAdvanced
Troubleshooting SQL Server with PowerShellJames BootherIntermediate
T-SQL : Bad Habits and Best PracticesAaron BertrandIntermediate
Understanding Microsoft Certification in SQL ServeChris Testa-O'NeillBeginner
Use SSIS object model to build ETL packagesDavid Peter HansenAdvanced
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
We have control! Resource Control in SQL ServerChris Testa-O'NeillIntermediate
Welcome to the Licensing NightmareTobiasz KoprowskiIntermediate
What's new in SQL Server 2012 - TSQLDave BallantyneIntermediate
When bad things happen to good SQLDavid MorrisonIntermediate
Why are we Waiting..Neil HamblyAdvanced
Windows Azure from a Data PerspectiveBuck WoodyAdvanced
XML: The Marmite of SQL ServerPhil QuinnBeginner


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