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.
2019
Friends of Redgate Member
2018
Parameters in SQL Server – Query Performance Makers or Breakers
The Ins and Outs of SQL Indexes
Women in Technology
An Introduction to SQL Server Spatial Data
Imposter Syndrome – Sometimes Feel Like a Fraud? Welcome to the Club!
Top 10 SQL Server Performance Makers and Breakers
2017
Reading Between the Lines – Using XEvents to Diagnose Application Issues
How to Manage and Understand Your Data in the Information Age
Voices from the Data Platform (Volume Book 1)
ATE: Ask the Experts-Data Platform & Business Intelligence Track
Trainer for Girls and Data: Mission to expose girls to tech careers in data analytics.
IT Dev Connections Speaker
Using Extended Events to Expose Application Performance Issues
Extended Events to Expose Application & Performance Issues
TSQL Coding Techniques-Are You Playing with Fire?
Power BI, Twitter and the Old Settlers Music Festival
Fun with SQL Server Spatial Data
SQL Server Performance Tuning & Bottleneck Detection
Impostor Syndrome: Are You Faking It and will they Find Out?
2016
The Importance of Data Quality & RDM for Industry Wide Analytics (slidedeck, recording)
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 / slidedeck / recording)
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)