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 - Room: Ballroom1 -Indexes - Room: Conf A2 -SQL Dev - Room: Conf B3 -BI Treats - Room: 2044 -Powershell - Room: 2065 -On/Off Prem - Room: 2086 -Performance - Room: 2117 -Getting it Right - Room: 2128 -ETL & Analysis - Room: 214
8:30 AMSQLSaturday 172

Welcome and Opening Remarks

Level: Non-Technical
        
09:00 AM Hossam Alfraih

A Tour in The Indexing World!

Level: Beginner

download
Rick Morelan

Introducing SQL Server Data Tools. (Project Juneau

Level: Intermediate

download
David Eichner

Overview of PowerPivot

Level: Beginner

download
Aaron Nelson

PowerShell for Data Professionals

Level: Intermediate

download
Brent Ozar

Building Faster SQL Servers

Level: Intermediate
Eddie Wuerch

TempDB Performance Troubleshooting and Optimizing

Level: Intermediate
Michael Swinarski

The Most Ignored Best Practices

Level: Beginner

download
Tim Mitchell

SSIS Incremental Load Design Patterns

Level: Intermediate
10:45 AMCarl Rabeler

Authorization & Access Rights w/ SharePoint & SQL

Level: Advanced
Hugo Kornelis

Understanding Indexes

Level: Intermediate

download
Bill Fellows

2012 TSQL Sweets

Level: Intermediate

download
Julie Koesmarno

Power View for Geographical Analysis

Level: Beginner

download
Ed Snajder

Powershell Smoke for SQL Server Mirrors

Level: Intermediate
Michael Wells

Running SQL Server 2012 on Server Core: Why & How

Level: Intermediate
Jeremiah Peschka

Killer Techniques for Database Performance

Level: Intermediate

download
Rob Garrison

Schema Design: Advanced Data Validation Techniques

Level: Intermediate

download
Joe Salvatore

SSIS Patterns and Practices: Loading Fact Tables

Level: Intermediate
12:30 PMBuck Woody

The Cloud is Coming for Your Career - Buwahahahaha

Level: Beginner
 Douglas Barrett

Agile Data Warehousing with WhereScape

Level: Beginner

download
      
01:45 PMSQLSaturday 172

Lightning Talks

Level: Beginner
Hugo Kornelis

Advanced Indexing

Level: Advanced

download
Steve Stedman

Unleashing Common Table Expressions in SQL Server

Level: Intermediate

download
Paul Turley

Power View and PowerPivot: High-Octane Self-svc BI

Level: Intermediate

download
Laerte Junior

Troubleshooting SQL Server with PowerShell

Level: Beginner
Scott Klein

SQL Azure - What is it and why do you need it?

Level: Beginner
Tim Ford

Performance Enhancing Laziness

Level: Intermediate
Vern Rabe

The Significance of Choosing and Using Data Types

Level: Intermediate

download
Russ Loski

SSRS data driven subscription using SSIS

Level: Advanced

download
03:30 PMSQLSaturday 172

Lightning Talks

Level: Beginner
Kendra Little

Index Psychiatry: The Top 5 Disorders

Level: Intermediate
Jason Kassay

The Accidental Programmer

Level: Beginner

download
Jason Horner

Isn't that Spatial! (BI Edition)

Level: Beginner
Michael Wells

Rapidly Deploying SQL Server with PowerShell

Level: Beginner
Mark Simms

SQLCAT - Building scalable & cloud applications

Level: Intermediate

download
Mark Broadbent

READPAST & Furious-Transactions,Locking&Isolation

Level: Intermediate
Pat Sinthusan

New Data Management Capabilities with SQL Server 2

Level: Intermediate
Peter Myers

Introduction to SQL Server 2012 MDS and DQS

Level: Intermediate

download
05:00 PM Bob Pusateri

The Skinny on Data Compression

Level: Intermediate

download
Victor Isakov

What DBAs Should Know About Windows Server 2012

Level: Beginner

download
Peter Myers

What's New for Self-Service BI in Excel 2013

Level: Beginner

download
 Matt Masson & Adam Larson

Efficient On-Premise to Cloud Data Transfer

Level: Intermediate
Robert Davis

Recovering from Corruption

Level: Advanced

download
Janis Griffin

Extend Your Knowledge with Extended Events!

Level: Beginner

download
Josh Fennessy

Looking to the future - Tabular Mode SSAS

Level: Beginner
6:15 PMSQLSaturday 172

Closing Reception and 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
Isn't that Spatial! (BI Edition)Jason HornerBeginner
PoSh Eye for the BI GuyJason HornerBeginner
2012 TSQL SweetsBill FellowsIntermediate
A Developer's Guide to Dangerous QueriesJeremiah PeschkaIntermediate
A Tour in The Indexing World!Hossam AlfraihBeginner
Administering the BI StackJosh FennessyIntermediate
Advanced IndexingHugo KornelisAdvanced
Agile Data Warehousing with WhereScapeDouglas Barrett Beginner
Authorization & Access Rights w/ SharePoint & SQLCarl RabelerAdvanced
Back It Up Faster!Bob PusateriIntermediate
Backups & Recovery 201Bob PusateriIntermediate
Best Practices for Running SQL Server on VMwareBrent OzarIntermediate
Big Data Analytics with PowerPivot and Power ViewPeter MyersIntermediate
Building Faster SQL ServersBrent OzarIntermediate
Closing Reception and RafflesSQLSaturday 172Beginner
Columnstore Indexes in SQL Server 2012Vern RabeAdvanced
Create Your Own Data TypeHugo KornelisAdvanced
Data Warehousing EssentialsJoe SalvatoreBeginner
Developing an Optimized Tabular BI Semantic ModelPeter MyersAdvanced
Dimensional Modeling: Beyond the BasicsJason HornerBeginner
DirectQuery vs In-Memory Tabular ModelJulie KoesmarnoIntermediate
Efficient On-Premise to Cloud Data TransferMatt Masson & Adam LarsonIntermediate
EIM - Bringing Together SSIS, DQS, and MDS Matt MassonIntermediate
Error handling in Sql 2012-Throw What's Caught !Suparna ShanmugamLightning Talk
Everything you always wanted to know about MERGEHugo KornelisBeginner
Exploring the TSQL Enhancements in SQL Server 2012Steve StedmanIntermediate
Extend Your Knowledge with Extended Events!Janis GriffinBeginner
Index Psychiatry: The Top 5 DisordersKendra LittleIntermediate
Introducing SQL Server Data Tools. (Project JuneauRick MorelanIntermediate
Introduction to Data Analysis Expressions (DAX)Peter MyersBeginner
Introduction to SQL Server 2012 MDS and DQSPeter MyersIntermediate
Introduction to the XML sourceRuss LoskiIntermediate
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
Killer Techniques for Database PerformanceJeremiah PeschkaIntermediate
Leading From WithinMichael SwinarskiAdvanced
Lightning TalksSQLSaturday 172Beginner
Looking to the future - Tabular Mode SSASJosh FennessyBeginner
Looney Tuner? No, there IS a method to my madnessJanis GriffinIntermediate
Make Your Queries Fly With Columnstore IndexesHugo KornelisIntermediate
Moves like Jagger - Upgrading to SQL Server 2012Mark BroadbentAdvanced
New Data Management Capabilities with SQL Server 2Pat SinthusanIntermediate
Oh, so Tabular!Paul TurleyIntermediate
Overview of PowerPivotDavid EichnerBeginner
Performance Enhancing LazinessTim FordIntermediate
Periodic Table of DMVs: Part Two - The SQLTim FordAdvanced
Power View and PowerPivot: High-Octane Self-svc BIPaul TurleyIntermediate
Power View for Geographical Analysis Julie KoesmarnoBeginner
Powerful T-SQL Improvements in SQL Server 2012Hugo KornelisIntermediate
PowerShell for Data ProfessionalsAaron NelsonIntermediate
Powershell Smoke for SQL Server MirrorsEd SnajderIntermediate
Prep an executive presentation in 5 min with MS BIPaul TurleyLightning Talk
Quickstart BI: Building a BI Solution in 5 DaysPaul TurleyIntermediate
Rapidly Deploying SQL Server with PowerShellMichael WellsBeginner
READPAST & Furious-Transactions,Locking&IsolationMark BroadbentIntermediate
Real-Life SQL 2012 Availability Group DeploymentsBrent OzarIntermediate
Recovering from CorruptionRobert DavisAdvanced
Rules, Rules, and RulesJeremiah PeschkaIntermediate
Running SQL Server 2012 on Server Core: Why & HowMichael WellsIntermediate
Schema Design: Advanced Data Validation TechniquesRob GarrisonIntermediate
SEQUENCE Performs Better Than IDENTITY? Prove It!Rob GarrisonLightning Talk
So you've built a cube...Now what? MDX essentialsPaul TurleyBeginner
SQL 2012 Error Handling. Pick your DestinyRick MorelanIntermediate
SQL Azure - What is it and why do you need it?Scott KleinBeginner
SQL Azure Scalability with FederationsScott KleinIntermediate
SQL Azure vs. Azure Tables –Clearing The ConfusionScott KleinIntermediate
SQL Performance For DevelopersSteve StedmanBeginner
SQL Server in Amazon's CloudJeremiah PeschkaBeginner
SQLCAT - Building scalable & cloud applicationsMark SimmsIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSDT - A quick glance!Suparna ShanmugamLightning Talk
SSIS Incremental Load Design PatternsTim MitchellIntermediate
SSIS Patterns and Practices: Loading Fact TablesJoe SalvatoreIntermediate
SSRS data driven subscription using SSISRuss LoskiAdvanced
Stop Driving Your DBAs Crazy With Your ETL!Julie KoesmarnoIntermediate
Talk Like a MicrosoftyRobert DavisLightning Talk
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The Accidental ProgrammerJason KassayBeginner
The Cloud is Coming for Your Career - BuwahahahahaBuck WoodyBeginner
The Most Ignored Best PracticesMichael SwinarskiBeginner
The Significance of Choosing and Using Data TypesVern RabeIntermediate
The Skinny on Data CompressionBob PusateriIntermediate
The SQL Doctor is InRobert DavisIntermediate
Time Saving Tips & Tricks for SSMS 2012Aaron NelsonIntermediate
Top Features of SQL 2012 Nobody Told You AboutRobert DavisBeginner
Troubleshooting SQL Server with PowerShellLaerte JuniorBeginner
TRY CATCH in a NutshellJulie KoesmarnoLightning Talk
UDFs, or: How to kill performance in one easy stepHugo KornelisAdvanced
Understanding IndexesHugo KornelisIntermediate
Unleashing Common Table Expressions in SQL ServerSteve StedmanIntermediate
Using Reports to analyze SQL Server healthSteve StedmanIntermediate
Welcome and Opening RemarksSQLSaturday 172Non-Technical
What DBAs Should Know About Windows Server 2012Victor IsakovBeginner
What's New for Self-Service BI in Excel 2013Peter MyersBeginner
XML everywhereRuss LoskiIntermediate


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