Presentations

Feel free to download these as examples for teaching on your own or for learning from them. If you borrow any of the slides or scripts, please credit me, thank you.

2016
The Importance of Data Quality & RDM for Industry Wide Analytics (slidedeckrecording)
Application Performance Troubleshooting (scripts / slidedeck)
Fun with SQL Server Spatial Data (scripts / slidedeck / recording)
Impostor Syndrome: Are You Faking It and will they Find Out? (recording)
The Scalable SQL Server – Full Day PreCon

2015
Paging the DR to the Recovery Room (updated)
TSQL’s Natural Born Killers
Application Performance Troubleshooting (updated)
Application Slowness Diagnosis / 3 Methods to End the Madness – Best of PASS 2015 (scripts / slidedeckrecording)

2014
SQL Server Performance Monitoring
SQL Server High Availability and Disaster Recovery Options
The Ins and Outs of SQL Indexes (slidedeck)

2013
SQL DMVs
What Where Why and How of Indexes
SQL Server Install, Migration & Config BINGO
Maintenance, Backup and Recovery JEOPARDY GAMESHOW
Exposing a Chatty Cathy – What a Drag!

2012
SQL Server Admin – A List of Must Do Items (updated)
SQL Server Migration or Upgrade
SQL Server Log Shipping
CSI for SQL
Cool Tricks with SQL

2011
Survival Kit for the Accidental DBA
The Incredible Shrinking Execution Plan
SQL IO Uh-Oh
Paging the DR to the Recovery Room

2010
SQL Server Migration and Upgrade
SQL Server Log Shipping
SQL Server Profiler

2009
SQL Server Migration
Creating a Reporting Server
SQL Server Bottleneck Identification

2008
SQL Server Administration – A List of Must Do Items (slidedeck)
SQL Server Disaster Recovery & High Availability (slidedeck)

Books

Microsoft SQL Server 2012 Step by Step (Step by Step Developer) (Chapter 32 – Log Shipping / Credited on page xxiv)