2013 |2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | Pre-2005

2014 SQL Server 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.


CONFERENCE DEMOS


SQLintersection Spring (April 12-17, Orlando, FL, US)
Precon: Practical Disaster Recovery Techniques (Paul) Demo scripts and whiteboard
Precon: Queries Gone Wild: Real-world Solutions (Kimberly) Demo scripts and whiteboard
Precon: What’s New in SQL Server 2014 (Bob) Demo scripts
Session: Waits, Latches, and Spinlocks: Internals and Analysis – Part 1 (Paul) Demo scripts and whiteboard
Session: Waits, Latches, and Spinlocks: Internals and Analysis – Part 2 (Paul) Demo scripts and whiteboard
Session: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Demo scripts
Session: SQL Server Cloud Choices (Bob) Demo scripts
Session: Migrating Data, Databases, and Applications to WASD (Bob) Demo scripts
Session: What’s in Microsoft’s Hadoop Offering (Bob) Demo scripts
Session: Entity Framework vs. Stored Procedures (Bob) Demo scripts


DevWeek 2014 (March 31 – April 4, London, UK)
Precon: What’s New in SQL Server 2014 (Bob) Demo scripts
Session: Memory Optimized Tables and Compiled Stored Procedures (Bob) Demo scripts
Session: Setting up SQL Server Security for your Application (Bob) Demo scripts
Session: SQL Server 2014 Cardinality Estimation For Query Plans (Bob) Demo scripts
Session: SQL Server Cloud Choices (Bob) Demo scripts
Session: Using Spatial Data in SQL Server 2012 (Bob) Demo scripts
Session: What’s in Microsoft’s Hadoop Offering (Bob) Demo scripts


Expert Seminar (Stockholm, Sweden, March 27-8, 2014)
Workshop: New Performance Features in SQL Server 2014 (Bob) Demo scripts


PASS DBA Fundamentals Virtual Chapter (January 21, 2014)
Session: Statistics Starters (Erin) Demo scripts and slide deck