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: Optimizing Statement Execution and Plan Reuse (Kimberly) Demo scripts
Session: Estimates, Selectivity, and Heuristics – How Does SQL Server Know? (Kimberly) Demo scripts
Session: Indexing for Performance (Kimberly) 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

Session: Getting the Most From Benchmarking and Baselining (Erin) Demo scripts
Session: Making the Leap from Profiler to Extended Events (Erin) Demo scripts

Session: Dr. DMV’s Troubleshooting Toolkit (Glenn) Demo scripts
Session: Analyzing I/O Subsystem Performance (Glenn) Demo scripts

Session: ORM Development (Jonathan) Demo scripts
Session: Solving Complex Problems with Extended Events (Jonathan) Demo scripts
Session: Enterprise Availability and Performance on Commodity Hardware with SQL Server 2014 (Jonathan) No 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