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

2013 SQL Server Demos and Sample Databases

SAMPLE DATABASES

As used in most conference sessions, these two 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)

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.

• 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)

CONFERENCE DEMOS

SQLintersection (April 7-12, 2013, Las Vegas, US)
Precon: Indexing Strategies that Work: Covering – Concepts, Concerns, Costs (Kimberly) Demo Scripts
Precon: Understanding Statement Execution and Optimizing Stored Procedures (Kimberly) Demo Scripts
Postcon: Solving Query Performance Problems (Kimberly and Joe)

• Joe’s Demo Scripts
• Kimberly’s Demo Scripts

Session:SQL228: Database Design Matters (Kimberly) Demo Scripts
Session:SQL231: Indexes, Data Access and What Works! (Kimberly) Demo Scripts
Session:PANEL3: Ask Anything Index (Kimberly, Joe, Kendra Little) Resources
Session:PANEL4: Ask Anything Performance (Kimberly, Paul, Brent Ozar) Resources
Session:SQL201: Making SQL Server Faster: Part 1 – Simple Things (Paul) Demo Scripts
Session:SQL402: Making SQL Server Faster: Part 2 – Not So Simple Things (Paul) Demo Scripts
Session:SQL317: SQL Core: CPU Performance Issues (Joe) Demo Scripts
Session:SQL318: SQL Core: Performance Issue Patterns (Joe) Demo Scripts
Session:SQL227: Columnstore Index Ramp-Up (Joe) Demo Scripts

Expert Seminar at Addskills (March 12-13, 2013, Stockholm, Sweden)
Demo Scripts

DevWeek UK (March 4-8, 2013, London, UK)
Precon: Writing SQL Server Database Applications and Stored Procedures For Best Performance (Bob) Demo Scripts
Session: Modeling and implementing hierarchies with SQL Server (Bob) Demo Scripts
Session: FileStreams and FileTables in SQL Server 2012 (Bob) Demo Scripts
Session: Server and client tracing using ETW, Extended Events and SQL Server 2012 (Bob) Demo Scripts
Session: Data Movement and Windows Azure SQL Database (Bob) Demo Scripts
Session: T-SQL improvements in SQL Server 2012 (Bob) Demo Scripts
Session: SQLCLR internals, .NET 4 support, and the new memory manager in SQL Server 2012 (Bob) Demo Scripts