2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | Pre-2007
2007 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
Microsoft TechEd ITForum November 12 – 16, 2007 – Barcelona, Spain
Chalk-Talk: DAT01-IS: SQL Server Upgrade Best Practices, Tips, and Tricks (Paul and Kimberly) No demo scripts for this session
Chalk-Talk: DAT02-IS: SQL Server 2005 Database Mirroring: Setup to Implementation to Monitoring (Paul and Kimberly) No demo scripts for this session
Instructor-Led Lab: DAT03-ILL: SQL Server Always On Technologies Part 1 – Database Mirroring (Paul and Kimberly) No demo scripts for this session
Instructor-Led Lab: DAT04-ILL: SQL Server Always On Technologies Part 2 – Database Snapshots (Paul and Kimberly) No demo scripts for this session
Instructor-Led Lab: DAT05-ILL: SQL Server Always On Technologies Part 3 – Online Operations (Paul and Kimberly) No demo scripts for this session
Session: DAT301: SQL Server Indexing – Unraveling the Unknown (Kimberly) Demo Scripts
Session: DAT205: The Next Release of Microsoft SQL Server: Manageability Overview (Kimberly) Demo Scripts
Session: DAT01-PD: Database Recovery Techniques (Paul) Demo Scripts
Session: DAT305: Secrets to Fast Detection and Recovery from Database Corruptions (Paul) Demo Scripts
Chalk-Talk: DAT07-IS: DBCC Internals (Paul) No demo scripts for this session
Session: DAT307: SQL Performance Query Tips and Techniques (Bob) Demo Scripts
Chalk-Talk: DAT04-IS: New T-SQL Programmability Features in Microsoft SQL Server 2008 (Bob) Demo Scripts
Chalk-Talk: DAT10-IS: Using Windows Powershell with the SQL Server 2008 Provider and SMO (Bob) No demo scripts for this session
Chalk-Talk: DAT03-IS: Spatial Support in Microsoft SQL Server 2008 Provider and SMO (Bob) No demo scripts for this session
Microsoft TechEd Developers November 5 – 9, 2007 – Barcelona, Spain
Session: DAT307: Best Practices for Optimizing Procedural Code and Queries in SQL Server 2005 and Beyond (Bob) Demo Scripts
Session: DAT308: Best Practices for Optimizing Service-Based Code in SQL Server 2005 and Beyond (Bob) Demo Scripts
Session: DAT309: Best Practices for Optimizing SQLCLR in SQL Server 2005 and Beyond (Bob) Demo Scripts
Session: DAT310: Best Practices for Optimizing Transactional Code in SQL Server 2005 and Beyond (Bob) Demo Scripts
Session: DAT311: Best Practices for Optimizing XML Queries in SQL Server 2005 and Beyond (Bob) Demo Scripts
Chalk-Talk: DAT04-IS: SQL CLR Best Practices Discussion and Examples using Lessons Learned from Customer Deployments (Bob) No demo scripts for this session
Chalk-Talk: DAT05-IS: Server Service Broker Architecture for Performance Discussion Using Lessons Learned from Customer Deployments (Bob) No demo scripts for this session
Chalk-Talk: DAT07-IS: To ODBC or To OLE DB? (Bob) No demo scripts for this session
Chalk-Talk: DAT08-IS: Using Powershell and SQL Server Management Objects (SMO) Together to Manage SQL Server (Bob) No demo scripts for this session
Microsoft Tech*Ed 2007 Hong Kong August 28 – 30, 2007 – Hong Kong
Pre-Con: PRE001: Optimizing and Best Practices for SQL Server 2005 Features – With A Look to the Future (Bob) Demo Scripts
Session: DAT316: Microsoft SQL Server 2005 Security Best Practices (Bob) No demo scripts for this session
Session: DAT329: Microsoft SQL Server Always-On Technologies: Advanced Indexing Strategies (Bob) Demo Scripts
Session: DAT382: SQL Server in 2007: Working with Vista and SP2 (Bob) Demo Scripts
Session: DAT314: Implementing Scale-Out Solutions with Microsoft SQL Server 2005 (Bob) Demo Scripts
Session: DAT326: Microsoft SQL Server 2005 Compact Edition in Action (Bob) No demo scripts for this session
DevConnections Workshops 15 June 2007 – Amsterdam, The Netherlands
Pre-con: Optimizing And Best Practices for all SQL Server 2005 Features (Bob) Demo Scripts
Microsoft Tech*Ed US June 4 – 8, 2007 – Orlando, FL
Pre-con: PRCN06: Leveraging SQL Server Always-On Technologies to Achieve High Availability and Scalability (Bob and Kimberly) Demo Scripts
Session: DAT314: Implementing Scale-Out Solutions with Microsoft SQL Server 2005 (Bob) Demo Scripts
Chalk-Talk: DAT01-TLC: DDL Triggers, Event Notifications, and WMI in SQL Server 2005 (Bob) Demo Scripts
Chalk-Talk: DAT12-TLC: Using Microsoft Windows PowerShell and SMO Together (Bob) Slides and Demo Scripts
Session: DAT327: Microsoft SQL Server 2005 Always-On Demo Fest (Kimberly) Demo Scripts
Session: DAT328: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error (Kimberly) Demo Scripts
Session: DAT329: SQL Server 2005: Advanced Indexing Strategies (Kimberly) Demo Scripts
Chalk-Talk: DAT02-TLC: Microsoft SQL Server 2005 VDLB Maintenance Best Practices Q&A (Paul and Kimberly) No demo scripts for this session
Microsoft Developer and ITPro Days March 28-29, 2007 – Ghent, Belgium
Session: Improve database application performance using SQL Server Service Broker (Bob) Demo Scripts
Session: SQL Query Plans In Depth – 80/20 tuning (Bob) Demo Scripts
Session: ADO.NET vNext – The Entity Data Model, Object Services, and LINQ (Bob) Demo Scripts
Session: SQL Server in 2007: Working with Vista and SQL Server SP2 (Bob) Demo Scripts
SQL Server Magazine Connections Spring March 25-29, 2007 – Orlando, FL
Pre-Con: SQL Server Tips and Tricks to Better Performance (Kimberly) Demo Scripts
Post-Con: Crucial Database Maintenance Techniques(Paul and Kimberly) No demo scripts for this session
Session: SDB308: Recovering from Isolated Disasters and Human Error (Kimberly) Demo Scripts
Session: SDV:312: Follow the Rabbit: Interactive Q&A on Availability (Paul and Kimberly) No demo scripts for this session
Session: SDB:309: Follow the Rabbit: Interactive Q&A on the SE and RE (Paul and Kimberly) No demo scripts for this session