2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | Pre-2007

2016 Conference Demos and 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.


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.


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


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)
Precon: Analyzing and Improving I/O Subsystem Performance (Glenn) Demo scripts
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: Dr. DMV’s Troubleshooting Toolkit (Glenn) 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