2019+ Conference/Session Demos and Sample Database

2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | Pre-2010

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 PASS 2011: More DBA Mythbusters (Paul) Video PASS 2010: DBA Mythbusters (Paul) Video

CONFERENCE/SESSION DEMOS – 2023

PASS Data Community Summit (November 13-17, 2023)
Workshop: Queries Gone Wrong: Caching, Statistics, Cardinality -> Solutions! (Kimberly) Demo scripts (password given out during the workshop, content for workshop attendees only)

CONFERENCE/SESSION DEMOS – 2022

PASS Data Community Summit (November 14-18, 2022)
Workshop: Performance Tuning with Waits and Latches (Paul) Demo scripts (password given out during the workshop, content for workshop attendees only)

CONFERENCE/SESSION DEMOS – 2021

PASS Data Community Summit (November 8-12, 2021 – ONLINE)
Workshop: Solving Query Performance Problems with Statistics (Kimberly) Demo scripts (password given out during the workshop, content for workshop attendees only)
Session: Indexing for Performance (Kimberly) Demo scripts
Session: Demystifying Statistics (Erin) Demo scripts

CONFERENCE DEMOS – 2020

SQLBits Fall 2020 (September 29-October 3, 2020 – ONLINE)
Workshop: Statistics4Performance: Internals, Analysis, and Solutions (Kimberly)  Demo scripts (password given out during the workshop, content for workshop attendees only) Session: Performance Troubleshooting Using Wait Statistics (Paul)  Demo scripts Session: Troubleshooting Query Plans: Part 1 – Caching Problems (Kimberly)  Demo scripts Session: Troubleshooting Query Plans: Part 2 – Statistics Problems (Kimberly)  Demo scripts

CONFERENCE/SESSION DEMOS – 2019

SQLintersection Fall 2019 (November 17-22, Las Vegas, NV)Workshop: SQL Server Indexes: What, Why, and HOW! (Kimberly)  Demo scripts (password given out on the day for workshop attendees only) Workshop: Performance Tuning Using Waits and Latches (Paul)  Demo scripts (password given out on the day for workshop attendees only) Session: Introduction to Performance Troubleshooting Using Wait Statistics (Paul) Demo scripts Session: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Demo scripts Session: Understanding SQL Server Backups and Restores (Tim) Demo scripts Session: Troubleshooting Query Plans: Part 1 – Root Cause Analysis and Caching Problems (Kimberly) Demo scripts Session: Troubleshooting Query Plans: Part 2 – Statistics Problems (Kimberly) Demo scripts Session: Statistics: Internals, Analysis, and Solutions (Kimberly) Demo scripts Session: Five Things I Wish Developers Knew about SQL Server (Jonathan) Demo scripts
PASS Summit 2019 (November 4-8, Seattle, WA)Workshop: Performance Tuning with Query Store in SQL Server (Erin)  Demo scripts (password given out on the day for workshop attendees only) Workshop: Bigger Hardware or Better Code and Design? (Jonathan) Demo scripts Session: Understanding Execution Plans (Erin) Demo scripts Session: Eliminating Anti-Patterns and RBAR for Faster Performance (Jonathan) Demo scripts
SQLintersection Spring 2019 (June 9 – 14, Orlando, FL)Workshop: Performance Tuning Using Waits and Latches (Paul)  Demo scripts and whiteboard (password given out on the day for workshop attendees only) Workshop: SQL Server Indexes: What, Why, and HOW! (Kimberly)  Demo scripts and whiteboard (password given out on the day for workshop attendees only) Workshop: Performance Tuning and Optimization for Modern Workloads (Tim)  Demo scripts (password given out on the day for workshop attendees only) Workshop: Zero-to-Hero: Faster SQL Query Performance (Jonathan)  Demo scripts Session: Introduction to Performance Tuning Using Wait Statistics (Paul)  Demo scripts Session: Troubleshooting Query Plans: Parts 1 and 2 (Kimberly)  Demo scripts
SQLBits 2019 (February 27 – March 2, Manchester, UK)Workshop: Stop Tuning Queries and Start Tuning Your Workload (Erin) Demo scripts (password given out on the day for workshop attendees only)
SQLSaturday Cleveland (February 1-2, Cleveland, OH)Workshop: Modernize Your Workloads With Azure SQL Database and Managed Instance (Tim) Materials Demo scripts (passwords given out on the day for workshop attendees only)
Microsoft Azure Roadshow (January 29 and 31, Cleveland, OH)Workshop: Modernize Your Workloads With Azure SQL Database and Managed Instance (Tim) Materials Demo scripts (passwords given out on the day for workshop attendees only)