2019 | 20182017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | Pre-2010

2010 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 8 – 12, 2010 – Seattle, USA

Pre-con(November 8):Database Best Practices for the Involuntary DBA (Paul and Kimberly)

Post-con (November 5): Indexing Strategies that work: Covering – Concepts, Concerns, Costs (Kimberly) Demo Scripts

Spotlight Session: DBA285S: DBA Mythbusters (Paul) Demo Scripts

Spotlight Session: AD372S: Tales from the Trenches: GUIDs – Use, Abuse and How to Move Forward (Kimberly) Demo Scripts


TechEd Europe November 8- 12, 2010, Berlin, Germany

Session: DAT401 A Database Developer and DBA Perspective: LINQ to SQL and Entity Framework vs. Stored Procedures (Bob) Demo Scripts

Session: DAT311 Introduction to SQL Server 2008 R2 Data-Tier Application Development (Bob) Demo Scripts

Session: DAT222 Code Name ‘Denali’ The near future of SQL Server (Bob) Demo Scripts


SQL Connections Fall November 1 – 5, 2010 – Las Vegas, USA

Pre-con (November 1):SPR301: Database Best Practices for the Involuntary DBA (Paul and Kimberly)

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

Post-con (November 5): SPS301: Tuning for High Performance (Kimberly) Demo Scripts

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

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

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

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

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

Session: SDV305: GUIDs: Use, Abuse, and How To Move Forward (Kimberly) Demo Scripts

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

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

Session: SDV308: Programming Filestreams and RBS in SQL Server 2008 R2 (Bob) Demo Scripts

Session: SDV309: Building, Deploying, and Monitoring StreamInsight Applications! (Bob) Demo Scripts

Session: SDV410: Auditing and Compliance Features in SQL Server 2008 (Bob) Demo Scripts


Microsoft TechReady 11 July 26 -30, 2010 – Seattle, USA

Session: DB306: MasterClass: Disaster Recovery – Understanding Logging and Recovery (Paul) Demo Scripts

Session: DB305: MasterClass: Disaster Recovery – Recovering from Corruption (Paul) Demo Scripts

Session: DB308: MasterClass: Disaster Recovery – Creating an Effective Backup Strategy (Kimberly) Demo Scripts

Session: DB307: MasterClass: Disaster Recovery – Recovering from Isolated Disasters (Kimberly) Demo Scripts


SQL UK MasterClass June 17, 2010 – London, UK

Session: Session 3: Disaster Recovery Demo-Fest (Paul and Kimberly)
Paul’s Demos
Kimberly’s Demos

Session: Session 4: GUIDs: Use, Abuse, and How To Move Forward (Kimberly) Demo Scripts


TechEd US June 5-10, 2010 – New Orleans, US

Pre-con: PRC04: Setting Up and Managing a Secure and Compliant SQL Server (Bob) Demo Scripts

Session: DAT301: A Database Developer and DBA Perspective: LINQ to SQL and Entity Framework vs. Stored Procedures (Bob) Demo Scripts

Session: DAT402: Integrating Microsoft SQL Server Event Tracing with OS-Level Events and Database Client Events (Bob) Demo Scripts


Vienna SQL Server User Group April 29, 2010 – Vienna, Austria
User group session, Kimberly Demo Scripts


SQL Connections Spring April 11 – 15, 2010 – Las Vegas, USA

Pre-con (April 11): Do You Feel The Need For Speed? Tuning for High Performance (Paul and Kimberly) Demo Scripts

Session: SDB305: Leveraging Centralized Management Servers in SQL Server 2008 (Kimberly) No easily reproduced demos from the CMS session

Session: SDV212: GUIDs: A Gift or a Gremlin? (Kimberly) Demo Scripts

Session: SDV310: SQL Server Covering: Concepts, Concerns, and Costs (Kimberly) Demo Scripts

Session: SDV311: Statistics: Are They Really Important? (Kimberly) Demo Scripts

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

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

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

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


DevTeach March 8-12, 2010 – Toronto, Canada

Pre-con (March 8): Indexing for Performance (Kimberly) Demo Scripts

Post-con (March 12): Developers Can’t Ignore SQL Server Database Maintenance! (Kimberly) Demo Scripts

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

Session: SQL355: Tips and Tricks for Proper SQL Server Table Design (Kimberly) No demo scripts for this session