2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2008 | 2007 | Pre-2007

2009 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


SQL Connections Fall November 9 – 13, 2009 – Las Vegas, USA

Pre-con (November 9):SQL Server 2005/2008: Database Maintenance Best Practices (Paul and Kimberly)

Post-con (November 13):SQL Server 2005/2008: Indexing for Performance (Kimberly)

  • Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here
  • Demo Scripts

Session: SDB303: Understanding Logging and Recovery in SQL Server (Paul) Demo Scripts

Session: SDB305: Building the Right Backup Strategy (Paul) Demo Scripts

Session: SDV307: SQL Server Covering: Concepts, Concerns, & Costs (Kimberly) Demo Scripts

Session: SDV308: SQL Server 2008 Sparse Columns: Structures, Storage, Speed (Kimberly) Demo scripts

Session: SDV309: Follow the Rabbit: Interactive Q & A on… Everything! (Paul and Kimberly) No demo scripts for this session


Microsoft TechEd Europe November 9 – 13, 2009 – Berlin, Germany

Session: DAT401: Auditing and Compliance Features in SQL Server 2008 (Bob) Demo scripts

Session: DAT405: Peeking into the plan cache with SQL Server 2008 (Bob) Demo scripts

Session: DAT03-IS: Filtered Indexes and Statistics in SQL Server 2008 (Bob) Demo scripts


SQL PASS Community Summit November 2 – 6, 2009 – Seattle, USA

Pre-con (November 2):SQL Server 2005/2008: Indexing for Performance (Kimberly)

  • Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here
  • Demo Scripts

Post-con (November 6): Disaster Recovery: Tips, Tricks, and Techniques (Paul) Demo Scripts

Spotlight Session: Understanding Logging and Recovery in SQL Server (Paul) Demo Scripts

Spotlight Session: SQL Server Covering: Concepts, Concerns, & Costs (Kimberly) Demo Scripts


SQL Connections Spring March 22 – 26, 2009 – Orlando, USA

Pre-con (March 21): A Day of SQL Server 2008 Spatial Data and Location-Aware Applications (Bob) Demo Scripts

Pre-con (March 22): SQL Server 2005/2008 Indexes from Every Angle – Internals, Statistics and Fragmentation (Paul and Kimberly) Demo Scripts (~5MB)

Post-con (March 26): SQL Server 2005/2008 Indexes from Every Angle – Are Your Indexing Strategies Working? (Paul and Kimberly) Demo Scripts (~5MB)

Session: SDV302: Programming Filestreams in SQL Server 2008 (Bob) Demo Scripts

Session: SDB304: Essential Database Maintenance (Paul and Kimberly) Demo Scripts (we didn’t do any, but these scripts are applicable)

Session: SDV308: Indexing for Performance (Kimberly) Demo Scripts

Session:SDB310: Corruption Survival Techniques (Paul)

Session: SDV314: Practical SQL Server Security for Architects and Developers (Bob) Demo Scripts

Session: SDB316: Scripting SQL Server 2008 Policies and Data Collection with PowerShell and SMO (Bob) Demo Scripts

Session: SDV320: SQL Server 2008 Sparse Columns and Filtered Indexes (Kimberly)

Session: SDB322: Follow the Rabbit: Interactive Q&A on Database Maintenance (Paul and Kimberly) No demo script for this session