2019+ | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2011 | 2010 | Pre-2010
2012 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 Sales 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
- 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 2021: Community Keynote (Kimberly/Paul) Video
PASS 2020: Query Store Best Practices (Erin) Video
PASS 2020: Understanding Execution Plans (Erin) Video
PASS 2020: Extending Your Use of Extended Events (Erin) Video
PASS 2019: Eliminating Anti-Patterns and RBAR for Faster Performance (Jon) Video
PASS 2019: Deadlocking for Mere Mortals (Jon) Video
PASS 2017: Query Store and Automatic Tuning in SQL Server (Erin) Video
PASS 24hop 2014: Everything You Never Wanted to Know About Extended Events (Jon/Erin) Video
PASS 24hop 2014: Common SQL Server Mistakes and How to Avoid Them (Tim) Video
PASS 2014: Going Asynchronous with Service Broker (Jon) Video
PASS 2014: Dealing with Multipurpose Procs and PSP (Parameter Sensitivity Problems) the RIGHT Way! (Kimberly) Video
PASS 2013:Index Fragmentation: Internals, Analysis, and Solutions (Paul) Video
PASS 2013:Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (Kimberly) Video
PASS 2011: More DBA Mythbusters (Paul) Video
PASS 2010: DBA Mythbusters (Paul) Video
CONFERENCE DEMOS
SQLServerDays 2012 (November 19-20 2012, Schelle, Belgium)
Pre-con: New Features in SQL Server 2012 (Bob) Demo Scripts
Session: Spatial Data and processing “grow up” in SQL Server 2012 (Bob) Demo Scripts
Session: Performance and Query Optimizations in SQL Server 2012 (Bob) Demo Scripts
SQL Connections Fall (October 28 – November 2, 2012 – Las Vegas, USA)
Pre-con (October 28): SPR201: Leveraging SQL Server 2012 Features and Tools (Kimberly and Jonathan)
Pre-con (October 29): SPR202: Optimizing Procedural Code: How to create High Performance Procedures (Kimberly) Demo Scripts
Session: SQL216: Making SQL Server Faster: Part 1 – Simple Things (Paul) Demo Scripts
Session: SQL417: Making SQL Server Faster: Part 2 – Not So Simple Things (Paul) Demo Scripts
Session: SQL218: Follow the Rabbit: Wrap-up Q&A (Paul & Kimberly) Demo Scripts
Session: SQL219: Database Design Matters (Kimberly) Demo Scripts
Session: SQL220: Why isn’t SQL Server using your indexes? (Kimberly) Demo Scripts
Session: SQL204: SQL Server 2012 High Availability Enhancements (Jonathan) Demo Scripts
Session: SQL205: Free Tools for the DBA (Jonathan) Demo Scripts
Session: SQL306: ORMs for the DBA (Jonathan) Demo Scripts
TechEd Europe (June 26-29 2012, Amsterdam, Netherlands)
Session: Integrating SQL Server FileTables, Property Search, and FTS/Semantic Search (Bob) Demo Scripts
TechEd North America (June 11-14 2012, Orlando, Florida)
Session: Integrating SQL Server FileTables, Property Search, and FTS/Semantic Search (Bob) Demo Scripts
Session: Exploring SQL Server Data Tier Applications (Bob) Demo Scripts
Expert Seminar at Addskills (April 3-4 2012, Stockholm, Sweden)
Session: New Features in SQL Server 2012 For Developers (Bob) Demo Scripts
SQLBits X (March 30-31 2012, London, UK)
Session: Extended Events and the new Profiler in SQL Server 2012 (Bob) Demo Scripts
Session: SQL Spatial Stretches Out In SQL Server 2012 (Bob) Demo Scripts
DevWeek UK (March 26-29 2012, London, UK)
Precon: T-SQL New features in SQL Server 2012 for developers (Bob) Demo Scripts
Session: SQL Server security best practices (Bob) Demo Scripts
Session: Extended Events and the new Profiler in SQL Server 2012 (Bob) Demo Scripts
Session: Mission-critical SQLCLR: internals and best practices (Bob) Demo Scripts
Session: Full text and semantic search in SQL Server 2008 and 2012 (Bob) Demo Scripts
Session: Developing for SQL Server 2012 with SQL Server Data Tools (Bob) No demo scripts for this session
SQL Saturday #105 (March 24 2012, Dublin, Ireland)
Session: Searching over data and files with SQL Server 2012 (Bob) Demo Scripts
SQL Connections Spring (March 27 – 29, 2012 – Las Vegas, USA)
Pre-con (March 25): SPR202: The Building Blocks of a Healthy and Available SQL Server (Paul and Kimberly)
Pre-con (March 25): SPR301: Advanced Diagnostics with SQLServer 2012 Extended Events (Jonathan) Demo Scripts
Pre-con (March 26): SPR203: Leveraging SQL Server 2012 Features and Tools (Kimberly and Jonathan)
Post-con (March 30): SPS202: Optimizing Procedural Code: Understanding Plan Cache, Procedural Code and Recompilation (Kimberly) Demo Scripts
Session: SQL416: Wait Statistics: Avoiding ‘Knee-Jerk’ Performance Tuning (Paul) Demo Scripts
Session: SQL417: Advanced Recovery Techniques (Paul) Demo Scripts
Session: SQL218: Follow the Rabbit: Wrap-up Q&A (Paul and Kimberly) No demo scripts for this session
Session: SQL219: Performance Tuning through Indexing (Kimberly)
- Demo Scripts
- Companion content from SQL Server 2008 Internals Ch6 (Indexing) is here
Session: SQL320: Statistics: What, Why and How the Optimizer Uses Them (Kimberly) Demo Scripts
Session: SQL307: Deadlocking for Mere Mortals (Jonathan) Demo Scripts
Session: SQL208: Distributed Replay in SQL Server 2012 (Jonathan) Demo Scripts
Tech Days 2012 (February 15-18 2012, The Hague, Netherlands)
Session: T-SQL Improvements in SQL Server 2012 (Bob) Demo Scripts
Session: Full-text and Semantic Search in SQL Server 2012 (Bob) Demo Scripts
Session: Filestreams and FileTables in SQL Server 2012 (Bob) Demo Scripts
Session: Using SQL Azure Database Federations (Bob) Demo Scripts
Session: Exploring SQL Server Data Tier Applications (Bob) No demo scripts for this session