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

2014 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 2014 (November 9-14, Las Vegas, NV, 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
Precon: High Performance, Scalable Asynchronous Processing Using Service Broker (Jonathan) Demo scripts
Postcon: Queries Gone Wild 2: Statistics and Cardinality in Versions 2008, 2008R2, 2012, and 2014 (Kimberly & Joe) Kimberly’s demo scripts Joe’s demo scripts
Session: Transaction Log Performance (Paul) Demo scripts
Session: Building a Better Backup Strategy (Paul) Demo scripts
Session: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Demo scripts
Session: Anatomy of a Data Modification:Locking and Isolation (Kimberly) Demo scripts
Session: Statement Execution – Tips and Tricks for Optimal Performance (Kimberly) Demo scripts
Session: Stored Procedures – Tips and Tricks for Optimal Performance (Kimberly) Demo scripts
Session: Indexing for Performance (Kimberly) Demo scripts
Session: Deadlocking for Mere Mortals (Jonathan) Demo scripts
Session: Window Functions and Framing Enhancements in SQL Server (Jonathan) Demo scripts
Session: Going Asynchronous With Service Broker (Jonathan) Demo scripts

PASS Summit 2014 (November 3-7, Seattle, WA, US)
Precon: Performance Tuning Using Waits and Latches (Paul) Demo scripts and whiteboard PDF (password in slides handout for attendees only)
Precon: Everything You Never Wanted to Know about Extended Events (Erin & Jonathan) Erin’s demo scripts
Session: Advanced Corruption Recovery Techniques (Paul) Demo scripts
Session: Dealing with Multipurpose Procs and PSP the RIGHT Way! (Kimberly) Demo scripts
Session: Five Execution Plan Patterns to Watch For (Erin) Demo scripts
Session: Deadlocking for Mere Mortals (Jonathan) Demo scripts
Session: Going Asynchronous with Service Broker (Jonathan) Demo scripts
Session: Solving Complex Problems with Extended Events (Jonathan) Demo scripts

PASS DBA Fundamentals Virtual Chapter (September 16)
Session: The Roadmap to Better Performance: Reading Query Plans (Erin) Demo scripts

SQLTuneIn (June 2-3, Zagreb, Croatia)
Precon: Azure SQL Database from A-Z (Bob) Demo scripts
Session: Transaction Isolation: How Much Is Enough? (Bob) Demo scripts

SQLPicnic (June 4, Ljubljana, Slovenia)
Session: Working With Spatial Data in SQL Server 2012 (Bob) Demo scripts and Slovenia spatial database

SQLintersection Spring (April 12-17, Orlando, FL, US)
Precon: Practical Disaster Recovery Techniques (Paul) Demo scripts and whiteboard
Precon: Queries Gone Wild: Real-world Solutions (Kimberly) Demo scripts and whiteboard
Precon: What’s New in SQL Server 2014 (Bob) Demo scripts
Postcon: Windows Azure SQL Database from A to Z (Bob) Demo scripts

Session: Waits, Latches, and Spinlocks: Internals and Analysis – Part 1 (Paul) Demo scripts and whiteboard
Session: Waits, Latches, and Spinlocks: Internals and Analysis – Part 2 (Paul) Demo scripts and whiteboard
Session: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Demo scripts

Session: Optimizing Statement Execution and Plan Reuse (Kimberly) Demo scripts
Session: Estimates, Selectivity, and Heuristics – How Does SQL Server Know? (Kimberly) Demo scripts
Session: Indexing for Performance (Kimberly) Demo scripts

Session: SQL Server Cloud Choices (Bob) Demo scripts
Session: Migrating Data, Databases, and Applications to WASD (Bob) Demo scripts
Session: What’s in Microsoft’s Hadoop Offering (Bob) Demo scripts
Session: Entity Framework vs. Stored Procedures (Bob) Demo scripts

Session: Getting the Most From Benchmarking and Baselining (Erin) Demo scripts
Session: Making the Leap from Profiler to Extended Events (Erin) Demo scripts

Session: ORM Development (Jonathan) Demo scripts
Session: Solving Complex Problems with Extended Events (Jonathan) Demo scripts
Session: Enterprise Availability and Performance on Commodity Hardware with SQL Server 2014 (Jonathan) No demo scripts

DevWeek 2014 (March 31 – April 4, London, UK)
Precon: What’s New in SQL Server 2014 (Bob) Demo scripts
Session: Memory Optimized Tables and Compiled Stored Procedures (Bob) Demo scripts
Session: Setting up SQL Server Security for your Application (Bob) Demo scripts
Session: SQL Server 2014 Cardinality Estimation For Query Plans (Bob) Demo scripts
Session: SQL Server Cloud Choices (Bob) Demo scripts
Session: Using Spatial Data in SQL Server 2012 (Bob) Demo scripts
Session: What’s in Microsoft’s Hadoop Offering (Bob) Demo scripts

Expert Seminar (Stockholm, Sweden, March 27-8, 2014)
Workshop: New Performance Features in SQL Server 2014 (Bob) Demo scripts

PASS DBA Fundamentals Virtual Chapter (January 21, 2014)
Session: Statistics Starters (Erin) Demo scripts and slide deck