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

2011 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 October 30 – November3, 2011 – Las Vegas, USA

Pre-con (November 30): SPR201: The Building Blocks of a Healthy and Available SQL Server (Paul and Kimberly)

Pre-con (November 31): SPR303: Designing for Performance and Scalability (Kimberly) Demo Scripts

Session: SQL419: Wait Statistics: Avoiding ‘Knee-Jerk’ Performance Tuning (Paul) Demo Scripts

Session: SQL422: Advanced Recovery Techniques (Paul) Demo Scripts

Session: SQL216: More DBA Mythbusters (Paul) No demos for this session.

Session: SQL225: Follow the Rabbit: Wrap-up Q&A (Paul and Kimberly) No demos for this session.

Session: SQL207: Precarious? Nefarious? Strategies that Work for Nonclustered Indexes! (Kimberly) Demo Scripts

Session: SQL310: Taking the Sting Out of Statistics (Kimberly) Demo Scripts

Session: SQL313: Filtered Indexes and Filtered Statistics: The good, the bad and the ugly (Kimberly) Demo Scripts


PASS Summit October 10 – 14, 2011 – Seattle, USA

Pre-con: DBA-498-P: Extended Events Deep Dive (Jonathan) Demo scripts

Spotlight Session: DBA-316-S: More DBA Mythbusters (Paul) Demo scripts

Spotlight Session: DBA-315-S: VLDB Isolated Disasters (Kimberly) Demo scripts

Spotlight Session: DBA-313-S: Using Event Notifications in SQL Server 2005/2008 (Jonathan) Demo scripts


SQL Connections Europe June 08 – 10, 2011 – Karlsruhe, Germany

Pre-con (June 8):SPR201: Performance Tuning From A to Z (Paul and Kimberly)

Session: SQL01: DBA Mythbusters (Paul) No demos for this session.

Session: SQL02: Corruption Survival Techniques (Paul) Demo scripts (see this blog post for details)

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

Session: SQL06: Index Fragmentation: The Hidden Menace (Paul) Demo Scripts

Session: SQL03: Optimizing Procedural Code (Kimberly) Demo Scripts

Session: SQL04: Covering: Concepts, Concerns and Costs (Kimberly) Demo Scripts

Session: SQL05: Filtered Indexes and Filtered Stats (Kimberly) Demo Scripts


Dev Days 2011 April 27-29 2011, The Hague, Netherlands

Pre-con: Multiple developer topics (Bob) Demo Scripts

Session: Full Text Search in SQL Server 2008 and Denali Demo Scripts

Session: Mission-Critical SQLCLR – Internals and Best Practices Demo Scripts

Session: Programming Filestreams and RBS in SQL Server 2008 R2 Demo Scripts

Session: Extended Events Comes of Age in SQL Server Denali Demo Scripts


SQL Connections Spring March 27 – 31, 2011 – Orlando, USA

Pre-con (March 27): SPR201: The Building Blocks of a Healthy and Available SQL Server (Paul and Kimberly)

Pre-con (March 27): SPR302: Day of Scripting: Plumbing The Depths of SQL Server / PowerShell Integration (Bob) Demo Scripts

Post-con (March 31): SPS301: Indexing Strategies and Analysis (Kimberly) Demo Scripts

Session: SDB310: Index Fragmentation: The Hidden Menace (Paul) Demo Scripts

Session: SDB412: Undocumented Tools and Trace Flags (Paul) Demo Scripts

Session: SDB208: DBA Mythbusters (Paul) No demos for this session

Session: SDB213: Follow the Rabbit: Wrap-up Q&A (Paul and Kimberly) No demos for this session

Session: SDB305: VLDB: Recovering from Isolated Disasters (Kimberly) Demo Scripts

Session: SDV303: Optimizing Procedural Code (Kimberly) Demo Scripts

Session: SDV302: Index Internals: What you really need to know! (Kimberly)

  • Companion content from SQL Server 2008 Internals Ch6 (Indexing) is here

Session: SDB414: Expanding the Scope and Ease of Use of Query Plan Guides in SQL Server 2008 (Bob) Demo Scripts

Session: SDV306: Full Text Search in SQL Server 2008 and Denali (Bob) Demo Scripts

Session: SDV304: Spatial Data “Stretches Out” in SQL Server Denali (Bob) Demo Scripts


DevWeek 2011 March 14 – 18, 2011 – London, UK

Pre-con: Writing SQL server database applications and stored procedures for best performance (Bob) Demo Scripts

Session: Performance enhancements in SQL Server 2008 (Bob) Demo Scripts

Session: A showcase application using SQL Server 2008 (Bob) Demo Scripts

Session: LINQ to SQL and Entity Framework vs. stored procedures (Bob) Demo Scripts

Session: Modeling and implementing hierarchies with SQL Server (Bob) Demo Scripts

Session: New Developer Features in SQL Server Denali (Bob) Demo Scripts


Public Class March 10-11, 2011 – Stockholm, Sweden (Bob)

Demos for all modules: Demo Scripts