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

2012 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.

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


SQLServerDays 2012 (November 19-20 2012, Schelle, Belgium)

Pre-con: New Features in SQL Server 2012 (Bob) Demo Scripts

Session: Spatial Data and processing “grow up” in SQL Server 2012 (Bob) Demo Scripts

Session: Performance and Query Optimizations in SQL Server 2012 (Bob) Demo Scripts


SQL Connections Fall (October 28 – November 2, 2012 – Las Vegas, USA)

Pre-con (October 28): SPR201: Leveraging SQL Server 2012 Features and Tools (Kimberly and Jonathan)

Pre-con (October 29): SPR202: Optimizing Procedural Code: How to create High Performance Procedures (Kimberly) Demo Scripts

Session: SQL216: Making SQL Server Faster: Part 1 – Simple Things (Paul) Demo Scripts

Session: SQL417: Making SQL Server Faster: Part 2 – Not So Simple Things (Paul) Demo Scripts

Session: SQL218: Follow the Rabbit: Wrap-up Q&A (Paul & Kimberly) Demo Scripts

Session: SQL219: Database Design Matters (Kimberly) Demo Scripts

Session: SQL220: Why isn’t SQL Server using your indexes? (Kimberly) Demo Scripts

Session: SQL204: SQL Server 2012 High Availability Enhancements (Jonathan) Demo Scripts

Session: SQL205: Free Tools for the DBA (Jonathan) Demo Scripts

Session: SQL306: ORMs for the DBA (Jonathan) Demo Scripts


TechEd Europe (June 26-29 2012, Amsterdam, Netherlands)

Session: Integrating SQL Server FileTables, Property Search, and FTS/Semantic Search (Bob) Demo Scripts


TechEd North America (June 11-14 2012, Orlando, Florida)

Session: Integrating SQL Server FileTables, Property Search, and FTS/Semantic Search (Bob) Demo Scripts

Session: Exploring SQL Server Data Tier Applications (Bob) Demo Scripts


Expert Seminar at Addskills (April 3-4 2012, Stockholm, Sweden)

Session: New Features in SQL Server 2012 For Developers (Bob) Demo Scripts


SQLBits X (March 30-31 2012, London, UK)

Session: Extended Events and the new Profiler in SQL Server 2012 (Bob) Demo Scripts

Session: SQL Spatial Stretches Out In SQL Server 2012 (Bob) Demo Scripts


DevWeek UK (March 26-29 2012, London, UK)

Precon: T-SQL New features in SQL Server 2012 for developers (Bob) Demo Scripts

Session: SQL Server security best practices (Bob) Demo Scripts

Session: Extended Events and the new Profiler in SQL Server 2012 (Bob) Demo Scripts

Session: Mission-critical SQLCLR: internals and best practices (Bob) Demo Scripts

Session: Full text and semantic search in SQL Server 2008 and 2012 (Bob) Demo Scripts

Session: Developing for SQL Server 2012 with SQL Server Data Tools (Bob) No demo scripts for this session


SQL Saturday #105 (March 24 2012, Dublin, Ireland)

Session: Searching over data and files with SQL Server 2012 (Bob) Demo Scripts


SQL Connections Spring (March 27 – 29, 2012 – Las Vegas, USA)

Pre-con (March 25): SPR202: The Building Blocks of a Healthy and Available SQL Server (Paul and Kimberly)

Pre-con (March 25): SPR301: Advanced Diagnostics with SQLServer 2012 Extended Events (Jonathan) Demo Scripts

Pre-con (March 26): SPR203: Leveraging SQL Server 2012 Features and Tools (Kimberly and Jonathan)

Post-con (March 30): SPS202: Optimizing Procedural Code: Understanding Plan Cache, Procedural Code and Recompilation (Kimberly) Demo Scripts

Session: SQL416: Wait Statistics: Avoiding ‘Knee-Jerk’ Performance Tuning (Paul) Demo Scripts

Session: SQL417: Advanced Recovery Techniques (Paul) Demo Scripts

Session: SQL218: Follow the Rabbit: Wrap-up Q&A (Paul and Kimberly) No demo scripts for this session

Session: SQL219: Performance Tuning through Indexing (Kimberly)

  • Demo Scripts
  • Companion content from SQL Server 2008 Internals Ch6 (Indexing) is here

Session: SQL320: Statistics: What, Why and How the Optimizer Uses Them (Kimberly) Demo Scripts

Session: SQL307: Deadlocking for Mere Mortals (Jonathan) Demo Scripts

Session: SQL208: Distributed Replay in SQL Server 2012 (Jonathan) Demo Scripts


Tech Days 2012 (February 15-18 2012, The Hague, Netherlands)

Session: T-SQL Improvements in SQL Server 2012 (Bob) Demo Scripts

Session: Full-text and Semantic Search in SQL Server 2012 (Bob) Demo Scripts

Session: Filestreams and FileTables in SQL Server 2012 (Bob) Demo Scripts

Session: Using SQL Azure Database Federations (Bob) Demo Scripts

Session: Exploring SQL Server Data Tier Applications (Bob) No demo scripts for this session