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 TimeMulti Track - Room: AuditoriumAD Track - Room: Room Y101AD Track - Room: Room Y106AD\DBA Track - Room: Room Y218BI Track - Room: Room Y109DBA Track - Room: Room Y201DBA Track - Room: Room Y205DBA Track - Room: Room Y209DBA Track - Room: Room Y212PD Track - Room: Room Y117BI Track - Room: Room Y114
07:30 AMNancy Hidy Wilson

Registration

Level: Beginner
          
08:15 AMNancy Hidy Wilson

Welcome Session

Level: Beginner
          
08:30 AMMichael Hotek

Build a Data Warehouse in Less than 1 Hour

Level: Intermediate
Kendal Van Dyke

Working With XML In SQL Server

Level: Intermediate

download
Jack Corbett

Introduction to Triggers

Level: Beginner

download
Sean McCown

Beginning Powershell for DBAs 1.0

Level: Beginner
Tim Mitchell

Top 10 New Features of SSIS in 2012

Level: Beginner
Robert Davis

Strategies for Working with VLDBs

Level: Intermediate

download
Jim Murphy

AlwaysOn - Finally, A usable 'mirror'!

Level: Beginner

download
Janis Griffin

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

Level: Intermediate

download
Michael Fal

The Fabulous Query Plan Primer

Level: Intermediate
Andy Warren

Building Your Professional Development Plan

Level: Beginner
 
09:45 AMBenjamin Nevarez

Inside the SQL Server Query Optimizer

Level: Advanced
Wendy Pastrick

Read Dirty to Me - Isolation Levels/User Impact

Level: Beginner
Rick Morelan

Avoid Errors on Errors

Level: Intermediate

download
Eric Humphrey

.NET Powers Activate! Form of PowerShell!

Level: Intermediate
Bryan Smith

Implementing Columnstore Indexes

Level: Intermediate

download
William Assaf

SQL Admin Best Practices with DMV's

Level: Intermediate

download
Argenis Fernandez

Rolling Upgrades Leveraging Database Mirroring

Level: Intermediate

download
 Steven Ormrod

SQL Server Amnesia

Level: Beginner

download
Sean and Jen McCown

Mouth Wide Shut: Coherent Interviewing

Level: Beginner
Thomas LeBlanc

Dimensional Modeling 101

Level: Intermediate

download
11:00 AMMark Rosenberg

Optimizing Stored Procedures

Level: Intermediate

download
Jennifer McCown

Unraveling Tangled Code – A Spellbinding Tale

Level: Intermediate
 Sean McCown

Understanding Backups

Level: Beginner
Tim Costello

Data Visualization primer: What you need to know

Level: Intermediate
Tim Radney

It is TEMPDB, Why Should You Care?

Level: Intermediate

download
Mike Saleme

A consolidation architecture to host 1000s of DBs

Level: Advanced

download
Michael Hotek

Knowledge from Data–FileTable and Semantic Search

Level: Intermediate

download
Christina Leo

SQL Server Internals: It's What's for Dinner!

Level: Beginner
Jason Wong

A Comparison of SQL Server and Oracle

Level: Intermediate

download
William E. Pearson III

Many-to-Many: Multiple Calendars in a Single Cube

Level: Advanced
12:00 PMNancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
Nancy Hidy Wilson

Lunch

Level: Beginner
01:30 PMKevin Boles

Windowing Functions: THE Reason to Upgrade to 2012

Level: Intermediate

download
 Russel Loski

Introduction to the XML source

Level: Intermediate

download
John Cook

SQL Server Tips and Tricks

Level: Beginner
William E. Pearson III

Becoming DAX: An Introduction ...

Level: Intermediate
Tim Radney

You Inherited a Database, Now What?

Level: Beginner

download
Michael Hotek

Recover from a Disaster–What to do When All Fails

Level: Intermediate
Wesley Brown

Benchmarking, Baselines and Monitoring Storage

Level: Beginner

download
Robert Davis

Replication Magic: Initializing From Backups

Level: Advanced

download
Nancy Hidy Wilson

WIT Discussion Panel

Level: Beginner
David Stein

Data Warehousing - How to Convince "The Bobs"

Level: Beginner
02:45 PMKevin Boles

SQL Server 2012 TSQL Enhancements and Additions

Level: Intermediate

download
 Vicky Harp

Edge Case Testing for the Database Professional

Level: Beginner

download
Argenis Fernandez

Troubleshooting SQL Server with SysInternals Tools

Level: Advanced

download
Michael D. Newby

EXCEL @ SQL Reporting

Level: Beginner

download
AJ Mendo

Standardize Your Environment With Best Practices

Level: Beginner

download
Benjamin Nevarez

Top Query Optimizer Topics for Better Performance

Level: Intermediate
Thomas LeBlanc

Execution Plan Basics - Beginners

Level: Beginner

download
Wendy Pastrick

Transactional Replication 101

Level: Beginner
Kendal Van Dyke

Building Your Own SQL Server Virtual Playground

Level: Intermediate

download
Tim Mitchell

Parent/Child Structures in SSIS

Level: Intermediate
04:00 PMJennifer McCown

T-SQL Brush-up:The Best Things You Forgot You Knew

Level: Beginner
 Kris Hokanson

Beyond the Where: Full Text Search tips and tricks

Level: Intermediate
Andy Warren

SQL Server Security for Developers

Level: Beginner
Bryan Smith

An Introduction to Big Data for BI

Level: Intermediate

download
John Sterrett

Evaluate your daily Checklist with PBM and CMS

Level: Intermediate
Michael Fal

Eating the Elephant: SQL Server Table Partitioning

Level: Intermediate
Wesley Brown

Solid State Storage Deep Dive

Level: Intermediate
Kalen Delaney

Costs of Concurrency

Level: Intermediate

download
Anthony {Tex} Moreign

The {Microsoft} Cloud and I

Level: Beginner
James Serra

Scaling SQL Server to HUNDREDS of Terabytes

Level: Intermediate

download
05:00 PMNancy Hidy Wilson

Closing Raffle

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
.NET Powers Activate! Form of PowerShell!Eric HumphreyIntermediate
6 Principles to Achieve Your Maxium PotentialBrad CarverIntermediate
A Comparison of SQL Server and OracleJason WongIntermediate
A consolidation architecture to host 1000s of DBsMike SalemeAdvanced
AlwaysOn - Finally, A usable 'mirror'!Jim MurphyBeginner
An Introduction to Big Data for BIBryan SmithIntermediate
An Introduction to SQL Server Developer ToolsBryan SmithBeginner
An OLTP architecture that delivers 300K-700K IOPsMike SalemeAdvanced
Asynch Processing – Building a Service Broker AppMichael HotekIntermediate
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIBeginner
Avoid Errors on ErrorsRick MorelanIntermediate
Basic Performance Tips and GotchasRick MorelanBeginner
Becoming DAX: An Introduction ... William E. Pearson IIIIntermediate
Beginning Powershell for DBAs 1.0Sean McCownBeginner
Beginning Powershell for DBAs 1.5Sean McCownBeginner
Beginning T-SQLJennifer McCownBeginner
Benchmarking, Baselines and Monitoring StorageWesley BrownBeginner
Best Practice for using Partitioned Tables/IndexesPeter TranIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Beyond the Basic RestoreEric HumphreyIntermediate
Beyond the Where: Full Text Search tips and tricksKris HokansonIntermediate
Bridging the Chasm: BI Theory vs. PracticeWilliam E. Pearson IIIBeginner
Build a Business Functional Cube in Less than 1 HrMichael HotekIntermediate
Build a Data Warehouse in Less than 1 HourMichael HotekIntermediate
Building Your Own SQL Server Virtual PlaygroundKendal Van DykeIntermediate
Building Your Professional Development PlanAndy WarrenBeginner
Cancel Your Plans!Mike HillwigIntermediate
Clustering Without the Charlie FoxtrotSteven OrmrodBeginner
Columnstore Indexes and Data WarehousesBenjamin NevarezIntermediate
Common TSQL MistakesKevin BolesIntermediate
Costs of ConcurrencyKalen DelaneyIntermediate
Data Security – Encrypting DataMichael HotekIntermediate
Data Visualization primer: What you need to knowTim CostelloIntermediate
Data Warehousing - How to Convince "The Bobs"David SteinBeginner
DBA Superstar: CMS, PBM and EPMF in 45 minutes.Argenis FernandezIntermediate
Design and Implement BI Like Edison!William E. Pearson IIIBeginner
Dimensional Design primer: What you need to knowTim CostelloIntermediate
Dimensional Modeling 101Thomas LeBlancIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Don't Panic, DBAs! Databases on VMware made easy.Janis GriffinIntermediate
Easily Manage your Servers with Policy Based MgmtMitchell BottelBeginner
Eating the Elephant: SQL Server Table PartitioningMichael FalIntermediate
Edge Case Testing for the Database ProfessionalVicky HarpBeginner
Effective Data Management using Data CompressionNeil HamblyIntermediate
ELT: Old school data loading with tsqlTim CostelloIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Error Handling in ETLMichael SextonBeginner
ETL as MDMMichael SextonIntermediate
Evaluate your daily Checklist with PBM and CMSJohn SterrettIntermediate
Examining SSIS and SSRS using XQueryRussel LoskiIntermediate
EXCEL @ SQL ReportingMichael D. NewbyBeginner
Execution Plan Basics - BeginnersThomas LeBlancBeginner
Execution Plan IntermiediateThomas LeBlancAdvanced
Extended Events – New Age of ProfilingNeil HamblyIntermediate
File IO Stalls and Wait Stats - Tune Like Guru!Kevin BolesAdvanced
Fixing SQL Server–Complete Mess 2 Smooth OperationMichael HotekIntermediate
Form And Substance: The “T” of ETLMichael SextonIntermediate
Fundamentals of Physical Join OperationsKevin BolesBeginner
Fundamentals of SAN, NAS and IP StorageWesley BrownIntermediate
Getting involved and Getting aheadTim RadneyBeginner
Getting Start with SQL Server ProfilerJack CorbettBeginner
Getting Started with MDX: The (Very) BasicsWilliam E. Pearson IIIBeginner
How Active Directory affects SQL ServerRyan AdamsIntermediate
How to curse in interviewsSean McCownBeginner
How to make a LOT more money as a consultantJames SerraBeginner
Implementing Columnstore IndexesBryan SmithIntermediate
Inroduction to TriggersJack CorbettBeginner
Inside the SQL Server Query OptimizerBenjamin NevarezAdvanced
Intro to T-SQLMark RosenbergBeginner
Introduction to Common Table ExpressionsVicky HarpIntermediate
Introduction to the XML sourceRussel LoskiIntermediate
Introduction to TriggersJack CorbettBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
Keep the Business Happy – Overview of HA FeaturesMichael HotekIntermediate
Knowledge from Data–FileTable and Semantic SearchMichael HotekIntermediate
Looney Tuner? No, there IS a method to my madnessJanis GriffinIntermediate
Manage your shop with CMS and Policy Based MgmtRyan AdamsBeginner
Managing Hierarchies in SQL ServerMichael HotekIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Mirroring Start to FinishRyan AdamsIntermediate
More Uses for PowerShellEric HumphreyIntermediate
Mouth Wide Shut: Coherent InterviewingSean and Jen McCownBeginner
No Matter What You Do Never Let Them See You SweatAJ MendoBeginner
Optimizing Stored ProceduresMark RosenbergIntermediate
Overcoming Barriers and Avoiding Mistakes with BIWilliam E. Pearson IIIBeginner
Parent/Child Structures in SSISTim MitchellIntermediate
PBM and You!Tom NormanBeginner
Performance Analysis – Finding What Needs TuningMichael HotekIntermediate
Performance Management – 2008 MDW - How & WhyJanis GriffinBeginner
Performance Tuning for PiratesJohn SterrettAdvanced
PowerPivot for Excel: For Those Unacquainted ...William E. Pearson IIIBeginner
Pro Tips: Performance Tuning SSISTim CostelloIntermediate
Pro Tips: Troubleshooting SSISTim CostelloIntermediate
Production is all Virtualized, Is Yours?Tom NormanBeginner
Read Dirty to Me - Isolation Levels/User ImpactWendy PastrickBeginner
Recover from a Disaster–What to do When All FailsMichael HotekIntermediate
Replication Magic: Initializing From BackupsRobert DavisAdvanced
Rolling Upgrades Leveraging Database MirroringArgenis FernandezIntermediate
Scaling SQL Server to HUNDREDS of TerabytesJames SerraIntermediate
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
Solid State Storage Deep DiveWesley BrownIntermediate
SQL Admin Best Practices with DMV'sWilliam AssafIntermediate
SQL InjectionKevin BolesIntermediate
SQL Report Builder for Business IntelligenceDavid EichnerBeginner
SQL Server 2012 TSQL Enhancements and AdditionsKevin BolesIntermediate
SQL Server AmnesiaSteven OrmrodBeginner
SQL Server Internals: It's What's for Dinner!Christina LeoBeginner
SQL Server Security for DevelopersAndy WarrenBeginner
SQL Server Tips and TricksJohn CookBeginner
SQL Spatial Basics - Reporting and beyondMark VerretBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSRS data driven subscription using SSISRussel LoskiIntermediate
Standardize Your Environment With Best PracticesAJ MendoBeginner
Stored procedure tracing using the xml datatype Russel LoskiIntermediate
Strategies for Working with VLDBsRobert DavisIntermediate
Tame the distributed data beastKris HokansonIntermediate
TDE, oh what fun! Auditing, No!!Tom NormanIntermediate
The {Microsoft} Cloud and IAnthony {Tex} MoreignBeginner
The Art of Networking and Self PromotionMitchell BottelBeginner
The Backup Tune-upSean McCownIntermediate
The Fabulous Query Plan PrimerMichael FalIntermediate
Top 10 New Features of SSIS in 2012Tim MitchellBeginner
Top Query Optimizer Topics for Better PerformanceBenjamin NevarezIntermediate
Top Ten Rules for Managing a Production EnvironmenMike HillwigBeginner
Transaction Log Deep DiveKevin BolesAdvanced
Transactional Replication 101Wendy PastrickBeginner
Troubleshooting SQL Server with SysInternals ToolsArgenis FernandezAdvanced
T-SQL Brush-up:The Best Things You Forgot You KnewJennifer McCownBeginner
T-SQL Code Sins Jennifer McCownBeginner
T-SQL Techniques to Survive Zombie Databases David SteinBeginner
Understanding BackupsSean McCownBeginner
Understanding Parameter SniffingBenjamin NevarezIntermediate
Unraveling Tangled Code – A Spellbinding TaleJennifer McCownIntermediate
Use DB Project in VS2010 to manage your databaseThomas LeBlancIntermediate
What is this cache and how did it get so big?Douglas BrendleIntermediate
What's Buried in the Plan Cache?Christina LeoIntermediate
Where Is It? – Working with Spatial DataMichael HotekIntermediate
Why are we Waiting..Neil HamblyAdvanced
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
WIT Discussion PanelNancy Hidy WilsonBeginner
Working With XML In SQL Server Kendal Van DykeIntermediate
You Inherited a Database, Now What?Tim RadneyBeginner


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