Recent | 2015-2014 | 2013-2010 | Pre-2010

2018-2016 Conference Demos and Sample Databases

SAMPLE DATABASES

As used in many conference sessions, these sample databases are useful for learning and reproducing the behavior of most demos. Credit is used in many performance-related demos. SalesDB is used in many “online operations” demos. Unzip and restore (possibly, WITH MOVE) to use.

SAMPLE CORRUPT DATABASES

These zip files contain the common corrupt databases that Paul uses for some of the DBCC CHECKDB demos. Some of the databases will only work on some versions of SQL Server so for instructions, see this blog post for details. Unzip and restore (possibly, WITH MOVE) to use.

There are a couple of corrupt 2014 AdventureWorks databases that are used during the IE0 class in this zip. (90MB zip/~670MB restored)

“BEST OF PASS” RECORDED SESSIONS

PASS 2021: Community Keynote (Kimberly/Paul) Video
PASS 2020: Query Store Best Practices (Erin) Video
PASS 2020: Understanding Execution Plans (Erin) Video
PASS 2020: Extending Your Use of Extended Events (Erin) Video
PASS 2019: Eliminating Anti-Patterns and RBAR for Faster Performance (Jon) Video
PASS 2019: Deadlocking for Mere Mortals (Jon) Video
PASS 2017: Query Store and Automatic Tuning in SQL Server (Erin) Video
PASS 24hop 2014: Everything You Never Wanted to Know About Extended Events (Jon/Erin) Video
PASS 24hop 2014: Common SQL Server Mistakes and How to Avoid Them (Tim) Video
PASS 2014: Going Asynchronous with Service Broker (Jon) Video
PASS 2014: Dealing with Multipurpose Procs and PSP (Parameter Sensitivity Problems) the RIGHT Way! (Kimberly) Video
PASS 2013: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Video
PASS 2013: Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (Kimberly) Video

2018 CONFERENCE DEMOS

SQLintersection Fall 2018 (December 1-7, Las Vegas, US)

Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts and whiteboard (password in slides handout for precon attendees only)
Precon: Modernize Your Applications with Azure SQL Managed Instance (Tim) Demo environment and demos + new slides (password in slides handout for precon attendees only)
Precon: High Performance, Scalable, Asynchronous Processing Using Service Broker (Jonathan) Demo scripts
Postcon: Using Query Store to Easily Troubleshoot and Stabilize Your Workload (Erin) Demo scripts
Session: Introduction to Performance Troubleshooting Using Wait Statistics (Paul) Demo scripts
Session: SQL Server Indexing: Strategies for Performance (Kimberly) Demo scripts
Session: SQL Server Indexing: Tools and Tuning Walkthrough (Kimberly) Demo scripts
Session: SQL Server Performance Tuning: Eliminating Low-hanging Fruit (Jonathan) Demo scripts
Session: SQL Server Performance Tuning: Plan Cache Analysis (Jonathan) Demo scripts
Session: No More Excuses: Replace Profiler with Extended Events (Erin) Demo scripts
Session: Using Query Store to Solve Performance Problems (Erin) Demo scripts

PASS Summit 2018 (November 5-9, Seattle, US)

Precon: Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality (Kimberly) Demo scripts and URLs (password in slides handout for precon attendees only) and Session Settings slide from Pluralsight course: SQL Server: Optimizing Stored Procedure Performance – Part 2 (here)

SQLintersection Spring 2018 (March 24-29, Orlando, US)

Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts, whiteboard, and URLs (password in slides handout for precon attendees only)
Precon: SQL Server Indexing Strategies for Performance (Kimberly) Demo scripts, whiteboard, and URLs (password in slides handout for precon attendees only)
Precon: Azure for the SQL Server DBA (Tim) Demo scripts
Session: Introduction to Performance Troubleshooting Using Wait Statistics (Paul) Demo scripts
Session: Building a Better Backup Strategy (Paul) Demo scripts
Session: Corruption Survival Techniques (Paul) Demo scripts
Session: Advanced Data Recovery Techniques (Paul) Demo scripts
Session: Statement Execution, Caching, and Reducing Plan Cache Bloat (Kimberly) Demo scripts
Session: SQL Server Indexing: Strategies for Performance (Kimberly) Demo scripts
Session: SQL Server Indexing: Tools and Tuning Walkthrough (Kimberly) Demo scripts
Session: Estimates & Statistics: Parameters, Literals, and Variables (Kimberly) Demo scripts
Session: Statistics: Understanding, Updating, and Improving Performance (Kimberly) Demo scripts
Session: Azure SQL Database for the Production DBA (Tim) Demo scripts

SQLBits 2018 (February 21-24, London, UK)

Precon: Solving Common Performance Problems Using Query Store (Erin) Demo scripts (password in slides handout for precon attendees only)
Session: Kicking and Screaming: Replacing Profiler with Extended Events (Erin) Demo scripts

2017 CONFERENCE DEMOS

SQLintersection Fall 2017 (October 29 – November 3, Las Vegas, NV, US)

Precon: Performance Tuning Using Waits and Latches (Paul) Whiteboard and Demo Scripts (password in slides handout for precon attendees only)
Precon: Extended Events: WTF or FTW! (Jonathan) Demo Scripts
Postcon: Very Large Tables: Optimizing Performance and Availability through Partitioning (Kimberly) Whiteboard and Demo Scripts (password in slides handout for postcon attendees only)
Postcon: Common SQL Server Mistakes and How to Fix Them! (Tim) Demo Scripts
Session: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Demo scripts
Session: Introduction to Performance Tuning Using Wait Statistics (Paul) Demo scripts
Session: Understanding Logging and Recovery (Paul) Demo scripts
Session: Corruption Survival Techniques (Paul) Demo scripts
Session: SQL Server Indexing: Strategies for Performance (Kimberly) Demo scripts
Session: Statistics and Estimates: What you NEED to know! (Kimberly) Demo scripts
Session: Statement Execution and the Plan Cache (Kimberly) Demo scripts
Session: Optimizing for OSFA: Catch-All-Queries in One-Size-Fits-All Procedures (Kimberly) Demo scripts
Session: Understanding SQL Server Backup and Restore (Tim) Demo scripts
Session: Going Asynchronous with Service Broker (Jonathan) Demo scripts
Session: SQL Server Performance Tuning: Plan Cache Analysis (Jonathan) Demo scripts
Session: SQL Server Performance Tuning: Eliminating Low Hanging Fruit (Jonathan) Demo scripts

PASS Summit 2017 (October 30 – November 3, Seattle, WA, US)

Precon: Solving Common Performance Problems Using Query Store (Erin) Demo scripts (password in slides handout for precon attendees only)
Session: Query Store and Automatic Tuning in SQL Server (Erin) Demo scripts

24 Hours of PASS 2017 (July 19)

Session: Help me, Query Store. You’re My Only Hope (Erin) Demo scripts

SQLSaturday Dublin 2017 (June 15-17, Dublin, Ireland)

Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts Whiteboard List of Slide Deck Links (password in slides handout for precon attendees only)
Precon: Queries Gone Wrong: Statistics, Cardinality, Solutions (Kimberly) Demo scripts and whiteboard (password in slides handout for precon attendees only)
Session: Advanced Data Recovery Techniques (Paul) Demo scripts
Session: Plan Cache Pollution: Dealing with Ad Hoc Madness (Kimberly) Demo scripts

SQLintersection Spring 2017 (May 20-25, Orlando, FL, US)

Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts Whiteboard (password in slides handout for precon attendees only)
Postcon: Finding and Fixing Performance Problems in SQL Server (Jonathan and Erin) Demo scripts (password provided to postcon attendees)
Session: Introduction to Performance Tuning Using Wait Statistics (Paul) Demo scripts
Session: Understanding Logging and Recovery (Paul) Demo scripts
Session: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Demo scripts
Session: Anatomy of a Data Modification: Locking & Isolation (Kimberly) Demo scripts
Session: SQL Server Indexing: Strategies for Performance (Kimberly) Demo scripts
Session: Optimizing for OSFA (Kimberly) Demo scripts
Session: Statistics and Estimates: What you NEED to Know! (Kimberly) Demo scripts
Session: The Roadmap to Better Performance: Reading Query Plans, Part I (Erin) Demo scripts
Session: The Roadmap to Better Performance: Reading Query Plans, Part II (Erin) Demo scripts
Session: Answering the Question, “What Happened?” with Query Store (Erin) Demo scripts
Session: Understanding SQL Server Backup and Restore (Tim) Demo scripts
Session: SQL Server Performance Tuning: Server and Instance Metrics (Tim) Demo scripts
Session: SQL Server Performance Tuning: Eliminating Low Hanging Fruit (Jonathan) Demo scripts
Session: SQL Server Performance Tuning: Plan Cache Analysis (Jonathan) Demo scripts
Session: Deadlocking for Mere Mortals (Jonathan) Demo scripts

2016 CONFERENCE DEMOS

SQLintersection Fall 2016 (October 23-29, Las Vegas, NV, US)

Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts Whiteboard (password in slides handout for precon attendees only)
Precon: Indexing for Performance (Kimberly) Demo scripts and whiteboard (password in slides handout for precon attendees only)
Precon: Finding and Fixing Performance Problems in SQL Server (Jonathan and Erin) Jon’s demo scripts Erin’s demo scripts
Postcon: Very Large Tables: Optimizing Performance and Availability through Partitioning (Kimberly) Demo scripts and whiteboard (password in slides handout for postcon attendees only)
Session: Introduction to Performance Tuning Using Wait Statistics (Paul) Demo scripts
Session: Corruption Survival Techniques (Paul) Demo scripts
Session: Transaction Log Performance (Paul) Demo scripts
Session: SQL Server Indexing: Strategies for Performance (Kimberly) Demo scripts
Session: Cardinality Estimates with Statistics NOT Heuristics: What you NEED to Know! (Kimberly) Demo scripts
Session: Plan Cache Pollution: Dealing with Ad Hoc Madness (Kimberly) Demo scripts
Session: Optimizing Procedural Code for the “OSFA” Procedures (Kimberly) Demo scripts
Session: Answering the Question “What Happened?” with Query Store (Erin) Demo scripts
Session: Kicking and Screaming: Replacing Profiler with Extended Events (Erin) Demo scripts
Session: The Roadmap to Better Performance: Reading Query Plans (Erin) Demo scripts
Session: SQL Server Backup and Restore (Tim) Demo scripts
Session: SQL Server Performance Tuning: Eliminating Low-hanging Fruit (Jonathan) Demo scripts
Session: SQL Server Performance Tuning: Plan Cache Analysis (Jonathan) Demo scripts
Session: Going Asynchronous with Service Broker (Jonathan) Demo scripts
Session: Parallelize Maintenance Tasks Using Service Broker (Jonathan) Demo scripts

SQLintersection Spring 2016 (April 16-22, Orlando, FL, US)

Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts Whiteboard (password in slides handout for precon attendees only)
Postcon: Queries Gone Wrong: Statistics, Cardinality, Solutions (Kimberly) Resources (password in slides handout for postcon attendees only)
Session: Introduction to Performance Tuning Using Wait Statistics (Paul) Demo scripts
Session: Corruption Survival Techniques (Paul) Demo scripts
Session: Understanding Backups and Restores (Tim) Demo scripts
Session: Indexing: Strategies for Performance (Kimberly) Demo scripts
Session: Indexing for Performance: Row-based Indexes (Kimberly) Demo scripts
Session: Indexing for Performance: Columnstore Indexes (Kimberly) Demo scripts

SQLSaturday Cleveland (February 6, Cleveland, OH, US)

Precon: Everything you never wanted to know about Extended Events (Jon) Demo scripts
Session: Answering the question, “What happened?” with Query Store (Erin) Demo scripts
Session: Diagnosing SQL Server Amnesia: Where is your memory going?  (Jon) Demo scripts