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.

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


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)

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)

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)

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)

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)


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