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

2015 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 Fall 2015 (October 24-30, Las Vegas, NV, US)

Precon: Queries Gone Wrong: Statistics, Cardinality, Solutions (Kimberly) Demo scripts and whiteboard PDF (password in slides handout for attendees only)
Precon: Managing SQL Server for the Non-DBA (Tim and Jonathan) Tim’s demo scripts and Jonathan’s demo scripts
Postcon: Performance Tuning Using Waits and Latches (Paul) Demo scripts and whiteboard PDF (password in slides handout for attendees only)

Session: Five Things I Wish Developers Knew about SQL Server (Jonathan) Demo scripts
Session: Improving User Experience with Service Broker (Jonathan) Demo scripts
Session: Performance Tuning Code Using the Plan Cache (Jonathan) Demo scripts
Session: How to Get Started Tuning SQL Server Performance (Tim) Demo scripts
Session: Understanding SQL Server Backup and Restore (Tim) Demo scripts
Session: SQL Server Indexing Strategies (Kimberly) Demo scripts
Session: Statement Execution – Tips and Tricks for Optimal Performance (Kimberly) Demo scripts
Session: Stored Procedures – Quick Tips to Solve Parameter Sniffing Problems (Kimberly) Demo scripts
Session: Advanced Data Recovery Techniques (Paul) Demo scripts
Session: Transaction Log Performance (Paul) Demo scripts


PASS Summit 2015 (October 26-30, Seattle, WA, US)

Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts and whiteboard PDF (password in slides handout for attendees only)
Precon: Queries Gone Wrong: Statistics, Cardinality, Solutions (Kimberly) Demo scripts and whiteboard PDF (password in slides handout for attendees only)

Session: DBA Mythbusters (Paul) Whiteboard PDF (no demos)
Session: SQL Server Indexing for Performance (Kimberly) Demo scripts
Session: Kicking and Screaming: Replacing Profiler with Extended Events (Erin) Demo scripts
Session: Statistics and Query Plans (Erin) Demo scripts


SQLintersection Spring 2015 (May 17-21, Scottsdale, AZ, US)

Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts and whiteboard PDF (password in slides handout for attendees only)
Precon: Very Large Tables: Optimizing Performance and Availability through Partitioning (Kimberly) Demo scripts and whiteboard PDF (password in slides handout for attendees only)

Session: Transaction Log Performance (Paul) Demo scripts
Session: Advanced Data Recovery Techniques (Paul) Demo scripts
Session: Anatomy of a Data Modification:Locking and Isolation (Kimberly) Demo scripts
Session: SQL Server Index Structures and Options (Kimberly) Demo scripts
Session: SQL Server Indexing for Performance (Kimberly) Demo scripts
Session: Understanding SQL Backups and Restores (Tim) Demo scripts
Session: Tackling Query Plans, Part 1 – The Basics (Erin) Demo scripts
Session: Tackling Query Plans, Part 2 – The Frustrations (Erin) Demo scripts
Session: Updating Statistics Affects Query Performance More Than You Think (Erin) Demo scripts