2019 | 2018 | 2017 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | Pre-2010
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.
- 2000 Credit Sample Database (48MB zip/155MB backup/700MB restore)
- 2008 Credit Sample Database (52MB zip/53MB compressed backup/700MB restore)
- 2008 SalesDB Sample Database (18MB zip/196MB backup/240MB restore)
- 2014 SalesDB Sample Database (17MB zip/28MB compressed backup/240MB restore)
- 2008 IndexInternals Sample Database (6MB zip/6MB backup/410MB restore)
- Note: This database was originally created for the Microsoft Press book SQL Server 2008 Internals. Review this blog post for more information and an SSMS solution file with a number of scripts on internals.
- Baseball Stats Sample Database (23MB zip/110MB backup)
- Note: This is based on the Lahman baseball database from here.
- 2012 Employee Case Study Sample Database (13MB zip/13MB backup/300MB restore)
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.
- 2000 Corrupt Database (40KB zip/~1MB restored)
- Sample Corrupt Databases (36MB zip/~400MB restored)
- Sample 2008 Fatal Corruption Databases (232KB zip/~3MB restored)
- Sample 2008 R2 Fatal Corruption Databases (260KB zip/~3MB restored)
- Sample 2008 R2 Metadata Corruption Database (90KB zip/~3MB restored)
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 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