2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2007 | Pre-2007
2008 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 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
PASS Community Summit November 17-21, 2008 – Seattle, Washington
Pre-con (November 18): Database Maintenance: From Planning to Practice to Post-Mortem (Paul and Kimberly) Demo Scripts
Pre-con (November 18): SQL Server 2008 Features For Developers In-Depth (Bob) Demo Scripts
Spotlight Session:Corruption Survival Techniques (Paul)
- Demo Scripts (see this blog post for details)
Session: Index Internals and Usage (Kimberly – stepped in at the last minute!) Demo Scripts
Spotlight Session: Using Spatial Data in SQL and in Clients (Bob) Demo Scripts
SQL Connections Fall November 9-14, 2008 Las Vegas, USA
Pre-con (November 9): Database Best Practices for the Involuntary DBA (Paul and Kimberly) Demo Scripts
Pre-con (November 10): Relational Data Warehousing: Leveraging Key Features of SQL Server 2005/2008 (Paul and Kimberly) Demo Scripts
Session: SDV303: Index Internals and Usage (Kimberly) Demo Scripts
Session: SDB405: Essential Database Maintenance (Paul and Kimberly) Demo Scripts
Session: SDB412: DBCC CHECKDB: The Definitive Guide (Paul)
- Demo Scripts (see this blog post for details)
Session: SDB313: Follow the Rabbit: Interactive Q&A on Database Maintenance (Paul and Kimberly) No demo scripts for this session
Microsoft TechEd EMEA Developers November 10 – 14, 2008 – Barcelona, Spain
Session: DAT302: Programming Filestreams in SQL Server 2008 (Bob) Demo Scripts
Session: DAT303: SQLCLR Enhancements in SQL Server 2008 (Bob) Demo Scripts
Session: DAT304: Supporting a Sparse Property Design in SQL Server 2008 (Bob) Demo Scripts
Session: DAT305: Performance Enhancements in SQL Server 2008 (Bob) Demo Scripts
Session: DAT314: Programming PowerShell in SQL Server 2008 (Bob) Demo Scripts
Microsoft TechEd EMEA IT Professionals November 3 – 7, 2008 – Barcelona, Spain
Instructor-Led Lab: DAT02-ILL: Combining Database Mirroring and Transactional Replication in SQL Server 2008 (Paul) Demo Scripts
Instructor-Led Lab:DAT04-ILL: Corruption Recovery Techniques (Paul)
- Demo Scripts (see this blog post for details)
Instructor-Led Lab: DAT01-ILL: SQL Server Worst Practices Fixed (Kimberly) No demo scripts for this session
Instructor-Led Lab: DAT03-ILL: Microsoft SQL Server 2008: Analyze and Tune your Workload (Kimberly) No demo scripts for this session
Session: DAT305: Microsoft SQL Server 200x: Are Your Indexing Strategies Working? (Kimberly) Demo Scripts
Session: DAT308: SQL Server Worst Practices Exposed, Part I (Kimberly) No demo scripts for this session
Session: DAT309: SQL Server Worst Practices Exposed, Part II (Kimberly) No demo scripts for this session
Session:DAT307: Surviving Database Corruption – From Detection to Resolution (Paul)
- Demo Scripts (see this blog post for details)
Session: DAT312: SQL Server 2008 Replication: Providing High-Availability Using Database Mirroring (Paul) Demo Scripts
Session: DAT313: Performance Benefits of new SQL Server 2008 T-SQL features (Bob) Demo Scripts
Session: DAT08-IS: Diagnosing Errors and Performance Problems using SQL Server Extended Events (Bob) Demo Scripts
Microsoft TechEd ITPro US June 9 – 13, 2008 – Orlando, FL
Session: DAT354: Are Your Indexing Strategies Working? (Kimberly) Demo Scripts
Session:DAT375: Corruption Survival Techniques (Paul)
- Demo Scripts (see this blog post for details)
Microsoft TechEd Developers US June 2 – 6, 2008 – Orlando, FL
Pre-con: PRC14: SQL Server 2008 New Features Overview for Developers (Bob) Demo Scripts
Session: DAT404: Practical SQL Server Security For Developers and Architects (Bob) Demo Scripts
Session: DAT401: End-to-End Tracing with SQL Server 2008 and ADO.NET (Bob) Demo Scripts
Session: DAT308: PowerShell in SQL Server 2008 (Bob) Demo Scripts
SQL Connections Spring April 20 – 24, 2008 – Orlando, USA
Pre-con: SPR201: The Accidental DBA Workshop (Paul and Kimberly) Demo Scripts
Pre-con: SPR302: SQL Server 2008 Overview for Developers (Bob) Demo Scripts
Session: SDB403: Diagnosis with Extended Events in SQL Server 2008 (Bob) Demo Scripts
Session: SDB304: PowerShell in SQL Server 2008 (Bob) Demo Scripts
Session: SDV306: Spatial Support in Microsoft SQL Server 2008 (Bob) Demo Scripts
Session: SDB307: Learn the XML You Need to Manage Your Database (Bob) Demo Scripts