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: Sports BarTBD1 - Room: TBD1TBD3 - Room: TBD3TBD4 - Room: TBD4TBD5 - Room: TBD5TBD6 - Room: TBD6TBD7 - Room: TBD7TBD8 - Room: TBD8Track 2 - Room: AmazonTBD2 - Room: TBD2
08:30 AMBob Ward

The Top Customer Problems: How to avoid calling Bob

Level: Intermediate
Christopher Wolff

Fun with Availability Groups

Level: Beginner
Matt Wigdahl

The Fundamentals of Great SQL Query Performance

Level: Beginner
Leslie Weed

Data Modeling 101

Level: Beginner
Chris Shaw

Outages; Dispatchers, Cops and Detectives

Level: Beginner
Lance Kolie

Tabular vs Multidimensional. Lets build it together!

Level: Beginner
Jason Kassay

Visual Studio Database Projects and Database Deployment

Level: Beginner
Jason Hall

TempDB Parasites!

Level: Intermediate
Steve Jones

Continuous Integration for Databases

Level: Intermediate
 
10:00 AMBob Ward

Troubleshooting the Memory of SQL Server

Level: Advanced
Sean McCown

REGEX for DBAs

Level: Intermediate
JK Wood

NULL: A Love Story

Level: Beginner
Jeff Renz

Data Vault Data Warehouse Architecture

Level: Intermediate
John Morehouse

Social Networking Is Alive!!!

Level: Beginner
Jason Horner

Advanced Spatial Analysis: Beyond Bubble Charts

Level: Advanced
Kathi Kellenberger

Writing Better T-SQL Queries with Window Functions

Level: Intermediate
Richard Douglas

Wait watchers - Gain Performance Increases Fast!

Level: Beginner
Ed Leighton-Dick

SQL Server Features That Will Blow Your Mind!

Level: Beginner
Rushabh Mehta

SSIS 2012 Management Considerations and Best Practices

Level: Intermediate
12:45 PMGlenn Berry

Analyzing I/O Subsystem Performance

Level: Intermediate
WIlliam Barnes

Fill Factor: Performance or Nuisance?

Level: Intermediate
Jennifer McCown

Introduction to Powershell cmdlets for DBAs

Level: Beginner
Jason Strate

Recognizing the Parallel Data Warehouse (PDW) Workload

Level: Intermediate
Larry Toothman

Yesterday I Couldn’t Even Spell ‘DBA’.

Level: Beginner
Allen Smith

BI Basics - Finding Return on Data

Level: Beginner
Tim Radney

Know Backups and Know Recovery

Level: Intermediate
Randy Knight

Understanding the SQL Server Transaction Log

Level: Intermediate
Wendy Pastrick

Read Dirty to Me - Isolation Levels/User Impact

Level: Beginner
Reeves Smith

Increase your SSIS productivity with Biml

Level: Intermediate
02:15 PMDavid Klee

SQL Server Virtualization 101

Level: Beginner
Janis Griffin

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Level: Intermediate
David Maxwell

DBA 911 - Database Corruption

Level: Beginner
Carlos Bossy

Get to Know HDInsight and Start Mining Big Data

Level: Beginner
Meagan Longoria

There May Be No Free Lunch But You Can Have Free Training

Level: Non-Technical
Russ Thomas

XPath - XQuery; I guess if I HAVE to

Level: Beginner
Matthew Brimer

SQL Security Best Practices & Shrinking Your Attack Surface

Level: Intermediate
Tristan Wilson

Can you check on the database?

Level: Beginner
Tracy McKibben

10 Ways To Abuse T-SQL

Level: Beginner
Steven Wake

Capture Change and Apply it With Change Data Capture & SSIS

Level: Intermediate
03:45 PMBill Graziano

Concurrency and Asynchronous Processing in SQL Server

Level: Intermediate
Nathan Heaivilin

Introduction to Execution Plans

Level: Beginner
Tom Norman

Policy Based Management, Trolls and Watchmakers

Level: Beginner
Chase Aucoin

Scaling the relational model

Level: Intermediate
Amy Herold

Making the Leap from Developer to DBA

Level: Beginner
Mike Donnelly

Twice in a Lifetime: T-SQL Refactoring 101

Level: Beginner
Michael Bourgon

Master of All I Survey - track code changes and more across your environment

Level: Intermediate
 Robert Smith

Table Partitioning 101

Level: Intermediate
Zane Brunette

Build ETL in 30 minutes or less with SSIS

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
10 Things Every DBA Should Know!John MorehouseBeginner
10 Ways To Abuse T-SQLTracy McKibbenBeginner
5 Ways to Improve Performance through IndexingJason StrateIntermediate
Achieve Index Feng Shui in SQL ServerChris ShawIntermediate
Advanced Processor Selection for SQL Server 2012/2014Glenn BerryIntermediate
Advanced Spatial Analysis: Beyond Bubble ChartsJason HornerAdvanced
Analyzing I/O Subsystem PerformanceGlenn BerryIntermediate
Automating a Partition Switching StrategyRobert SmithAdvanced
Battle of the Finch BotsJeff RenzBeginner
Beginning Automation with PowershellAmy HeroldBeginner
Best Frenemies -- How to Handle the Query OptimizerMatt WigdahlBeginner
BI Basics - Finding Return on DataAllen SmithBeginner
Branding Yourself for a Dream JobSteve JonesBeginner
Build ETL in 30 minutes or less with SSIS Zane BrunetteBeginner
Building a Better WorkstationSteven WakeBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Can you check on the database?Tristan WilsonBeginner
Capture Change and Apply it With Change Data Capture & SSISSteven WakeIntermediate
ColumnStore Indexes in SQL 2014Allen SmithIntermediate
Common T-SQL Patterns Affecting SQL Server PerformanceJason StrateIntermediate
Concurrency and Asynchronous Processing in SQL ServerBill GrazianoIntermediate
Continuous Integration for DatabasesSteve JonesIntermediate
Converting Unreliable Deployments Into Consistent ReleasesTom NormanIntermediate
Critical Incident Debrief; Verbal Judo for the DBARuss ThomasNon-Technical
Dashboards - More Than One Way To Visualize DataJeff RenzBeginner
Data Modeling 101Leslie WeedBeginner
Data Vault Data Warehouse ArchitectureJeff RenzIntermediate
Date and Time Dimensions for Every Day and Time in No TimeSteven WakeIntermediate
DBA 911 - Database CorruptionDavid MaxwellBeginner
DBA Career RoadmapJennifer McCownBeginner
Designing Stored Procedure SolutionsJennifer McCownBeginner
Dimensional Modeling Design Patterns: Beyond BasicsJason HornerIntermediate
DIY Performance ReportingSean McCownIntermediate
Dr. DMV's Troubleshooting ToolkitGlenn BerryIntermediate
Dysfunctional FunctionsTracy McKibbenBeginner
Easy SQL Server BenchmarkingDavid KleeBeginner
Fill Factor: Performance or Nuisance?WIlliam BarnesIntermediate
Fun with Availability GroupsChristopher WolffBeginner
Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issuesJanis GriffinIntermediate
Get Testing with tSQLtSteve JonesBeginner
Get to Know HDInsight and Start Mining Big DataCarlos BossyBeginner
Getting started with Big Data and BICarlos BossyBeginner
Getting Started with Execution PlansJason KassayBeginner
Hadoop DistilledScott ShawIntermediate
How to Argue with Your Infrastructure Admins – and WinDavid KleeBeginner
How to Talk HardwareTristan WilsonIntermediate
I’m New, Select Me!Tom NormanBeginner
Increase your SSIS productivity with BimlReeves SmithIntermediate
Introduction to Execution PlansNathan HeaivilinBeginner
Introduction to Powershell cmdlets for DBAsJennifer McCownBeginner
Introduction to Predictive ModelingCarlos BossyBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
Know Backups and Know RecoveryTim RadneyIntermediate
Locks, Blocks, and Deadlocks Oh My!Randy KnightIntermediate
Make SQL Server Management Studio Bark Like a DogRuss ThomasIntermediate
Making the Leap from Developer to DBAAmy HeroldBeginner
Managing SQL Server Performance with Extended EventsJason StrateIntermediate
Master of All I Survey - track code changes and more across your environmentMichael BourgonIntermediate
Natural Born Killers, performance issues to avoidRichard DouglasIntermediate
NULL: A Love StoryJK WoodBeginner
Only You Can Prevent Database Fires!John MorehouseBeginner
Outages; Dispatchers, Cops and DetectivesChris ShawBeginner
Pig\Hive - All That's New is Old AgainScott ShawIntermediate
Policy Based Management, Trolls and WatchmakersTom NormanBeginner
Read Dirty to Me - Isolation Levels/User ImpactWendy PastrickBeginner
Recipe for a happy DBAJason HallBeginner
Recognizing the Parallel Data Warehouse (PDW) WorkloadJason StrateIntermediate
REGEX for DBAsSean McCownIntermediate
Sanity Testing Your DataJK WoodIntermediate
Scaling the relational modelChase AucoinIntermediate
Searching Binary Data in SQL Server 2012Steve JonesIntermediate
Self Service Pitfalls David OrtizBeginner
Service Broker and Why you should care!Nathan HeaivilinBeginner
Service Broker: The Queue ContinuumEd Leighton-DickIntermediate
So you want to be a Consultant?Allen SmithBeginner
Social Networking Is Alive!!!John MorehouseBeginner
SQL Security Best Practices & Shrinking Your Attack SurfaceMatthew BrimerIntermediate
Sql Server Architectures for World DominationTristan WilsonIntermediate
SQL Server Databaseology 201: A Study of Database InternalsJohn MorehouseIntermediate
SQL Server Features That Will Blow Your Mind!Ed Leighton-DickBeginner
SQL Server Virtualization 101David KleeBeginner
SSIS 2012 Management Considerations and Best PracticesRushabh MehtaIntermediate
Storage problems and solutionsTristan WilsonBeginner
Strategies for SQL Server Index AnalysisJason StrateIntermediate
Subqueries for SuperheroesTracy McKibbenBeginner
Table Partitioning 101Robert SmithIntermediate
Tabular ModelsJeff RenzBeginner
Tabular vs Multidimensional. Lets build it together!Lance KolieBeginner
TempDB Parasites!Jason HallIntermediate
Temporary Query Items and YouJK WoodIntermediate
The Big Backup TheoryRichard DouglasIntermediate
The Day After Tomorrow: Why you need to baselineRichard DouglasBeginner
The Encryption PrimerSteve JonesBeginner
The Fundamentals of Great SQL Query PerformanceMatt WigdahlBeginner
The Top Customer Problems: How to avoid calling BobBob WardIntermediate
There May Be No Free Lunch But You Can Have Free TrainingMeagan LongoriaNon-Technical
Tricks from the DBA Inbox: Real World Performance TuningJason HornerBeginner
Troubleshooting the Memory of SQL ServerBob WardAdvanced
T-SQL Code Sins Jennifer McCownBeginner
T-SQL Window Function PerformanceKathi KellenbergerAdvanced
Twice in a Lifetime: T-SQL Refactoring 101Mike DonnellyBeginner
Understanding SQL Server XML Features Randy KnightIntermediate
Understanding the SQL Server Transaction LogRandy KnightIntermediate
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Using Tabular and Power View to Analyse Perfmon DataScott ShawIntermediate
Visual Studio Database Projects and Database DeploymentJason KassayBeginner
Visualizing Your Indexes - Science vs ArtWendy PastrickBeginner
Wait watchers - Gain Performance Increases Fast! Richard DouglasBeginner
Writing Better T-SQL Queries with Window FunctionsKathi KellenbergerIntermediate
XEventaphobia: It's time to conquer your fearRuss ThomasBeginner
XPath - XQuery; I guess if I HAVE toRuss ThomasBeginner
Yesterday I Couldn’t Even Spell ‘DBA’.Larry ToothmanBeginner
You Inherited a Database, Now What?Tim RadneyBeginner
Your First Week as a SQL Server DBASteve JonesBeginner


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
Building ETL in 30 minutes or less with SSIS Beginner
Building ETL in 30 minutes or less with SSIS Beginner

SQLSaturday Home
PASS