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: 214Track 2 - Room: 116Track 3 - Room: 216Track 4 - Room: 217Track 5 - Room: 117Track 6 - Room: 118Track 7 - Room: 215Track 8 - Room: 218
7:30 AMSQL Saturday

Registration

Level: Beginner
       
9:15 AMBob Pusateri

The Skinny on Data Compression

Level: Intermediate
Warren Sifre

Introduction to FileTables in SQL 2012

Level: Intermediate

download
David Klee

Virtualizing Business Critical SQL Servers

Level: Intermediate

download
Craig Purnell

Upgrade Roadmap: Let’s delve into SQL Server 2012

Level: Intermediate

download
Josh Fennessy

Administering the BI Stack

Level: Intermediate

download
Mark Vaillancourt

MDX Trek: First Contact

Level: Beginner

download
Dave Levy

Writing Faster SQL Server Queries

Level: Advanced
Aaron King

A Complete BI Solution in About an Hour!

Level: Beginner

download
10:45 AMMark Tabladillo

Enterprise Data Mining with SQL Server

Level: Intermediate

download
Brent Ozar

BLITZ! One Hour SQL Server Takeovers

Level: Beginner
Ross LoForte

Microsoft Big Data

Level: Beginner
Christina Leo

What's Buried in the Plan Cache?

Level: Intermediate

download
Hope Foley

Performance Tuning 2012 SSIS Data Loads

Level: Intermediate

download
Ted Krueger

Query Tuning for Developers and DBAs

Level: Beginner

download
David Eichner

SRS Report Builder for Business Intelligence

Level: Beginner

download
Shelly Noll

NoSQL: Know Your Enemy

Level: Beginner

download
12:00 PMSQL Saturday

Lunch

Level: Beginner
Wendy Pastrick

Women In Technology Panel

Level: Beginner
  SQL Saturday

You Rock Sponsor Session

Level: Beginner
SQL Saturday

You Rock Sponsor Session

Level: Beginner
  
01:00 PMAllan Hirt

Is That A Failover Cluster On Your Laptop/Desktop?

Level: Intermediate
Andy Thiru

SQL Azure Intro and What’s New

Level: Beginner
Tim Ford

The Periodic Table of Dynamic Management Objects

Level: Intermediate
Jason Strate

Getting to Know Index Operation Stats

Level: Intermediate
Bill Fellows

Kama Sutra of SSIS: A guide to loving ETL

Level: Beginner

download
Scott Shaw

Licensing SQL Server in a Virtual Environment

Level: Intermediate

download
Jes Borland

Reporting Services 201: From Basic To WOW!

Level: Intermediate

download
Dave Levy

Ask the Experts - Anything and Everything

Level: Beginner
2:30 PMKevin Boles

SQL Server 2012 Column Store Index

Level: Intermediate

download
Ben DeBow

Build Your Own SQL Server Private Cloud

Level: Intermediate
Arie Jones

Master Data Services in SQL Server 2012

Level: Intermediate
Argenis Fernandez

Troubleshooting SQL Server with SysInternals Tools

Level: Advanced
Norman Kelm

The Script Task, powerhouse of SSIS

Level: Beginner
Janis Griffin

Don't Panic, DBAs! Databases on VMware made easy.

Level: Intermediate

download
Rob Farley

Analytic T-SQL Functions in 2012

Level: Intermediate

download
Colleen Morrow

So I started this blog... now what?

Level: Beginner

download
04:00 PMLuke Jian

Optimizing SQL Server I/O with Solid State Drives

Level: Intermediate

download
Tom Norman

Compliance and Auditing in Sql Server

Level: Beginner
Erin Stellato

DBCC Commands: The Quick and the Dangerous

Level: Beginner

download
Mike Donnelly

Advancements in CDC with SSIS in SQL 2012

Level: Beginner

download
Michael Sexton

Error Handling in ETL

Level: Beginner
Aaron Lowe

Writing Professional Database Code

Level: Intermediate
Rob Farley

SARGability

Level: Intermediate

download
Eddie Wuerch

Join Us! Getting Started as a Technical Speaker

Level: Beginner

download
5:30 PMSQL Saturday

SQL Saturday Closing Events

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
*GASP* Real-time user defined sets in SSASJosh FennessyAdvanced
2012 TSQL SweetsBill FellowsIntermediate
A Complete BI Solution in About an Hour! Aaron KingBeginner
A Preview of High Availability in SQL Server 2012Allan HirtIntermediate
Administering the BI StackJosh FennessyIntermediate
Advancements in CDC with SSIS in SQL 2012Mike DonnellyBeginner
Analytic T-SQL Functions in 2012Rob FarleyIntermediate
Anatomy of a JoinLuke JianIntermediate
Applied Enterprise Semantic MiningMark TabladilloIntermediate
Ask the Experts - Anything and EverythingDave LevyBeginner
Asynchronous programming with Service Brokersanil mhatreBeginner
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIBeginner
Backups & Recovery 201Bob PusateriIntermediate
Bad IndexesRob FarleyIntermediate
Be Your Own SQL SWAT TeamBen DeBowIntermediate
Becoming DAX: An Introduction ... William E. Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
BI in the Cloud with SQL Azure ReportingEric BoydIntermediate
BLITZ! One Hour SQL Server TakeoversBrent OzarBeginner
Bridging the Chasm: BI Theory vs. Practice William E. Pearson IIIBeginner
Build Your Own SQL Server Private CloudBen DeBowIntermediate
Choose Your Own Adventure: Performance TuningTim ChapmanAdvanced
Common TSQL MistakesKevin BolesIntermediate
Compliance and Auditing in Sql ServerTom NormanBeginner
Contained DB? Did it do something wrong?Warren SifreBeginner
Data Mining with Excel 2010 and PowerPivotMark TabladilloIntermediate
Database Development using SQL Server Data ToolsAaron LoweBeginner
DBA Superstar: CMS, PBM and EPMF in 45 minutes.Argenis FernandezIntermediate
DBCC Commands: The Quick and the DangerousErin StellatoBeginner
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Discovering the Plan CacheJason StrateIntermediate
Documenting Your Integrated Microsoft BI Solution William E. Pearson IIIIntermediate
Don't Panic, DBAs! Databases on VMware made easy.Janis GriffinIntermediate
Enterprise Data Mining with SQL ServerMark TabladilloIntermediate
Entity Strategies: Structuring Your Consultancy William E. Pearson IIIBeginner
Error Handling in ETLMichael SextonBeginner
ETL as MDMMichael SextonIntermediate
Extended Events, Work Smarter Not HarderJason StrateIntermediate
Filegroups: Putting the Puzzle Together Jes BorlandIntermediate
Form And Substance: The “T” of ETLMichael SextonIntermediate
Free SQL tools for your toolboxKevin BullenBeginner
Fundamentals of Join OperationsKevin BolesBeginner
Getting Started with MDX: The (Very) BasicsWilliam E. Pearson IIIBeginner
Getting started with PowerShell and SQL ServerKevin BullenBeginner
Getting The Most From Your SQL Server Ben DeBowIntermediate
Getting to Know Index Operation StatsJason StrateIntermediate
Going Deeper into JoinsRob FarleyIntermediate
Holy Crap! Someone Put the Database in the CloudJason StrateBeginner
Introduction to FileTables in SQL 2012Warren SifreIntermediate
Is That A Failover Cluster On Your Laptop/Desktop?Allan HirtIntermediate
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
Kama Sutra of SSIS: A guide to loving ETLBill FellowsBeginner
Licensing SQL Server in a Virtual EnvironmentScott ShawIntermediate
Little in the middle but got much [Write]BackJosh FennessyIntermediate
Looking to the future - Tabular Mode SSASJosh FennessyBeginner
Looney Tuner? No, there IS a method to my madnessJanis GriffinIntermediate
LunchSQL SaturdayBeginner
Make Your Voice Heard!Jes BorlandBeginner
Many-to-Many: Multiple Calendars in a Single Cube William E. Pearson IIIAdvanced
Master Data Services in SQL Server 2012Arie JonesIntermediate
MDX Trek: First ContactMark VaillancourtBeginner
Merge Replication for Offline Data MobilityTed KruegerBeginner
Microsoft Big DataRoss LoForteBeginner
MS Access with SQL Server Strategies and TipsJuan SotoBeginner
New Tricks for Old Tasks in the CloudJason StrateBeginner
NoSQL: Know Your EnemyShelly NollBeginner
Optimizing SQL Server I/O with Solid State DrivesLuke JianIntermediate
Overcoming Barriers and Avoiding Mistakes with BI William E. Pearson IIIBeginner
Overview of the Windows Azure DataMarketEric BoydBeginner
Page Latches for Mere MortalsEddie WuerchIntermediate
Parallel Query Execution Deep DiveKevin BolesAdvanced
PBM and You!Tom NormanBeginner
Performance Enhancing LazinessTim FordBeginner
Performance Management – 2008 MDW - How & WhyJanis GriffinBeginner
Performance Tuning 2012 SSIS Data LoadsHope FoleyIntermediate
PowerPivot & BISM in SQL Server 2012Hope FoleyBeginner
PowerPivot for Excel: For Those Unacquainted ... William E. Pearson IIIBeginner
PowerShell, the New SQL HammerNorman KelmBeginner
Powershell? Yea, but I'm a DBA!Kyle NeierIntermediate
Production is all Virtualized, Is Yours?Tom NormanBeginner
Professional Networking for IT ProsCraig PurnellBeginner
Query Tuning for Developers and DBAsTed KruegerBeginner
Query Tuning Using Lessons Learned from SSISRob FarleyIntermediate
RegistrationSQL SaturdayBeginner
Reporting Services 201: From Basic To WOW!Jes BorlandIntermediate
Rolling Upgrades Leveraging Database MirroringArgenis FernandezIntermediate
SARGabilityRob FarleyIntermediate
Searching for the Holy Grail of DDL AuditingColleen MorrowBeginner
Security Auditing in SQL Server Arie JonesIntermediate
Serene Velocity: Reporting Services and SSAS Data William E. Pearson IIIIntermediate
Shrinking Execution PlansRob FarleyIntermediate
So I started this blog... now what?Colleen MorrowBeginner
So Many High Availability Options, So Little TimeAllan HirtBeginner
Social Marketing 2012 for Microsoft ProfessionalsMark TabladilloBeginner
SQL Azure Federations - a real-life exampleScott KleinIntermediate
SQL Azure Intro and What’s NewAndy ThiruBeginner
SQL Azure vs. Azure Tables –Clearing The ConfusionScott KleinIntermediate
SQL Respawn: Strategies for Migrating Your Server Argenis FernandezIntermediate
SQL Saturday Closing EventsSQL SaturdayBeginner
SQL Server 2012 Column Store IndexKevin BolesIntermediate
SQL Server 2012: A Window To T-SQL EnhancementsJason StrateIntermediate
SQL Server 2012: Using the Columnstore IndexThomas PuchBeginner
SQL Server Development Tips and TricksRoman RehakBeginner
SQL Server Dos and Don'ts: Keys to DBA NirvanaAllan HirtBeginner
SQL Server Security H@ck3ryNorman KelmIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS 2012 Basics - Get Up to Speed in 60 minutes!Ted KruegerBeginner
SSIS 2012 Management Considerations and Best PractRushabh MehtaIntermediate
SSIS 2012 New FeaturesNorman KelmBeginner
SSIS 2012-Where did my green boxes go?Kyle NeierBeginner
SSIS: Figuring Out ConfiguringMike DonnellyIntermediate
SSIS: The DBA MultiplierTed KruegerBeginner
Storage Strategies in Windows AzureEric BoydIntermediate
Surviving Your Peak Database LoadBen DeBowIntermediate
Tasks, Where We're Going We Don't Need TasksMike DonnellyBeginner
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The MERGE Statement - T-SQL's Swiss Army KnifeRob FarleyIntermediate
The Periodic Table of Dynamic Management ObjectsTim FordIntermediate
The Script Task, powerhouse of SSISNorman KelmBeginner
The Skinny on Data CompressionBob PusateriIntermediate
The TSQL Road Less Traveled: MERGEKevin BolesIntermediate
Throwing T-SQL 2012 Enhancements Against the WallKyle NeierBeginner
Transaction Log Deep DiveKevin BolesAdvanced
Triple Threat! SSIS + DQS + MDS 2012 Arie JonesIntermediate
Troubleshooting SQL Server with SysInternals ToolsArgenis FernandezAdvanced
TSQL Road Less Traveled: The Numbers TableKevin BolesIntermediate
Type more, click less: using EzAPI to build SSISBill FellowsAdvanced
Unit Testing made easy for database development Sanil MhatreIntermediate
Upgrade Roadmap: Let’s delve into SQL Server 2012 Craig PurnellIntermediate
Using MS Access as a BI Tool with SQL ServerJuan SotoIntermediate
Utilizing Data Quality Services in SQL Server 2012Arie JonesIntermediate
Virtualizing Business Critical SQL ServersDavid KleeIntermediate
What a DBA should know about SQL AzureRoss LoForteIntermediate
What Are You Waiting For? Jason StrateIntermediate
What? I can't buy [Vendor]'s Monitoring Package?!?Kyle NeierIntermediate
What's Buried in the Plan Cache?Christina LeoIntermediate
Why Third Party Vendors Do The Things They DoHenry TreftzIntermediate
Women In Technology PanelWendy PastrickBeginner
Working with Server Side TracesChristina LeoIntermediate
Writing Faster SQL Server QueriesDave LevyAdvanced
Writing Professional Database CodeAaron LoweIntermediate
XQuery Basics for the DBAJason StrateIntermediate
You Rock Sponsor SessionSQL SaturdayBeginner
You’re My Density: Making Sense of StatisticsErin StellatoBeginner
Your First Performance Tuning ClassBrent OzarIntermediate
Your First SQL Internals ClassBrent OzarIntermediate


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
Writting DML TriggersBeginner

SQLSaturday Home
PASS