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 TimeCapital Hill - Room: Room 2003Montlake - Room: Room 2007Pioneer Square - Room: Room 2011Queen Ann - Room: Room 2015
07:30 AMSQLSaturday 306

Registrations

Level: Non-Technical
SQLSaturday 306

Registrations

Level: Non-Technical
SQLSaturday 306

Registrations

Level: Non-Technical
SQLSaturday 306

Registrations

Level: Non-Technical
08:30 AMArgenis Fernandez

Peace of Mind: Making DBCC CHECKDB Go Faster

Level: Intermediate

download
David Eichner

SRS Report Builder for Business Intelligence

Level: Beginner

download
Trent Mera

SQL Server Waits reveal which of your statements most need tuning

Level: Beginner

download
Ron Talmage

SQL Server Upgrade Strategies

Level: Intermediate

download
09:30 AMCoffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
9:45 AMKalen Delaney

Unblock yourself -- Optimistic concurrency in Hekaton

Level: Advanced
Scott Stauffer

"I've got the Power" with PowerBI and the PASS Community!

Level: Beginner
Kevin Boles

Common TSQL Mistakes

Level: Intermediate

download
Chuck Lathrope

Inside and out of Transactional Replication

Level: Beginner
10:45 AMCoffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
11:00 AMJoe Chang

Automating Execution Plan Analysis

Level: Advanced

download
Russ Loski

SSIS project deployments with multiple developers

Level: Advanced

download
Vern Rabe

Practical Fundamentals of Query Performance Tuning

Level: Beginner

download
Theresa Iserman

Backup and Recovery Basics

Level: Beginner

download
12:00 PM

Lunch Break

Level: Non-Technical


Lunch Break

Level: Non-Technical


Lunch Break

Level: Non-Technical


Lunch Break

Level: Non-Technical
12:15 PMJohn McAllister

[Sponsor] Enterprise-grade MDM On SQL Server - the Keys to Success

Level: Beginner
John McAllister

[Sponsor] Enterprise-grade MDM On SQL Server - the Keys to Success

Level: Beginner
John McAllister

[Sponsor] Enterprise-grade MDM On SQL Server - the Keys to Success

Level: Beginner
John McAllister

[Sponsor] Enterprise-grade MDM On SQL Server - the Keys to Success

Level: Beginner
12:45 PMTrent Mara

Dell Software tools for SQL Server performance management

Level: Beginner

download
Trent Mara

Dell Software tools for SQL Server performance management

Level: Beginner

download
Trent Mara

Dell Software tools for SQL Server performance management

Level: Beginner

download
Trent Mara

Dell Software tools for SQL Server performance management

Level: Beginner

download
01:15 PM

Lunch Break

Level: Non-Technical


Lunch Break

Level: Non-Technical


Lunch Break

Level: Non-Technical


Lunch Break

Level: Non-Technical
01:30 PMGreg Larsen

Alice’s SQL Server DBA Training Plan

Level: Beginner

download
Piotr Palka

SSIS - manage concurrent processing using SQL Server Broker

Level: Intermediate

download
Rick Morelan

SQL Aggregation Queries Tips and Tricks

Level: Intermediate

download
Robert Davis

DBA Code Reviews Done Dirt Cheap

Level: Intermediate

download
02:30 PMCoffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
Coffee

Break

Level: Non-Technical
02:45 PMJimmy May

Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit

Level: Intermediate
David Lydston

Data Mining in the Microsoft Stack

Level: Intermediate
Richard Baumet

T-SQL - Temporary Objects

Level: Intermediate
John McAllister

Master Data Management - Getting Started with SQL Server MDS

Level: Beginner
04:00 PMSQLSaturday 306

Raffle

Level: Non-Technical
SQLSaturday 306

Raffle

Level: Non-Technical
SQLSaturday 306

Raffle

Level: Non-Technical
SQLSaturday 306

Raffle

Level: Non-Technical


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
"I've got the Power" with PowerBI and the PASS Community!Scott StaufferBeginner
[Sponsor] Enterprise-grade MDM On SQL Server - the Keys to SuccessJohn McAllisterBeginner
10 Free SQL Resource to Help you stay productive & Up to dateScott StaufferBeginner
Alice’s SQL Server DBA Training PlanGreg LarsenBeginner
Automating Execution Plan AnalysisJoe ChangAdvanced
Backup and Recovery BasicsTheresa IsermanBeginner
BreakCoffee Non-Technical
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Columnstore Indexes in SQL Server 2014: Flipping the DW Faster BitJimmy May Intermediate
Common TSQL MistakesKevin BolesIntermediate
Data Mining in the Microsoft StackDavid LydstonIntermediate
DBA Code Reviews Done Dirt CheapRobert DavisIntermediate
DBA ToolkitGreg LarsenBeginner
Dell Software tools for SQL Server performance managementTrent MaraBeginner
Dynamic SQL: Use it right and stop the injectionRick MorelanBeginner
Hybrid cloud scenarios enabled in SQL Server 2014Karthika RamanBeginner
Inside and out of Transactional ReplicationChuck LathropeBeginner
Introduction to BIML and BIMLScriptRuss LoskiIntermediate
Locks, Blocks, and Deadlocks Oh My!Randy KnightIntermediate
Lunch Break Non-Technical
Master Data Management - Getting Started with SQL Server MDSJohn McAllisterBeginner
Master Data Services - 4 Key Features in 60 MinutesJohn McAllisterIntermediate
NUMA for the SQL ServerRichard BaumetAdvanced
Peace of Mind: Making DBCC CHECKDB Go FasterArgenis FernandezIntermediate
Performance Troubleshooting with DMVsRobert DavisIntermediate
Power Query and PowerPivot - Data Analysis on your DesktopRuss LoskiBeginner
Practical Fundamentals of Query Performance TuningVern RabeBeginner
RaffleSQLSaturday 306Non-Technical
RegistrationsSQLSaturday 306Non-Technical
Resurrecting the Walking Dead: The Data Quality RevolutionDavid MoutrayBeginner
Resurrecting the Walking Dead: The Data Quality RevolutionDavid MoutrayBeginner
Solid State StoryRichard BaumetIntermediate
SQL Aggregation Queries Tips and TricksRick MorelanIntermediate
SQL InjectionKevin BolesIntermediate
SQL Server 2014 Top 5 - Hybrid FeaturesScott KleinIntermediate
SQL Server HA and DR in a Windows Azure Virtual Machine – Deep DiveScott KleinAdvanced
SQL Server Upgrade StrategiesRon TalmageIntermediate
SQL Server Waits reveal which of your statements most need tuningTrent MeraBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS - manage concurrent processing using SQL Server BrokerPiotr PalkaIntermediate
SSIS project deployments with multiple developersRuss LoskiAdvanced
Subqueries made easyRick MorelanBeginner
System Tweaks for a DBA by Dr Seuss Richard BaumetLightning Talk
The Significance of Choosing the Right Data TypesVern RabeIntermediate
T-SQL - Temporary ObjectsRichard BaumetIntermediate
Unblock yourself -- Optimistic concurrency in HekatonKalen DelaneyAdvanced
Understanding the SQL Server Transaction LogRandy KnightBeginner
Understanding Transaction Isolation LevelsRandy KnightIntermediate
What's in my database? Information Schema and catalog viewsRuss LoskiBeginner
Windowing Functions: THE Reason to Upgrade to 2012+Kevin BolesIntermediate
Windows Azure SQL Database for the DBAScott KleinIntermediate


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