2019 | 2018 | 2017 | 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.
- 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 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