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

2019 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 2017: Query Store and Automatic Tuning in SQL Server (Erin) Video
PASS 2015: DBA Mythbusters (Paul) Video
PASS 2015: SQL Server Indexing Performance (Kimberly) Video
PASS 2014: Advanced Data Recovery Techniques (Paul) Video
PASS 2014: Five Execution Plan Patterns to Watch For (Erin) Video


CONFERENCE DEMOS


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: Migrating to SQL Server 2019 (Glenn)  Demo scripts
Workshop: Performance Tuning and Optimization for Modern Workloads (Tim)  Demo scripts (password given out on the day for workshop attendees only)
Session: Introduction to Performance Tuning Using Wait Statistics (Paul)  Demo scripts
Session: Troubleshooting Query Plans: Parts 1 and 2 (Kimberly)  Demo scripts
Session: HA/DR 101 (Glenn)  Demo scripts
Session: Hardware 201 (Glenn)  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)