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

2006 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


Microsoft ITForum November 13 – 17, 2006 – Barcelona, Spain

Pre-con: PRE006: Achieving High Availability with SQL Server 2005 Always On Technologies (Kimberly) Demo Scripts

Session: SQL Server 2005: Security – Best practices for accounts, keys, and data encryption (Bob) Demo Scripts

Session: SQL Server 2005: Troubleshooting the Service Broker (Bob) Demo Scripts

Session: SQL Server 2005: Learn the XML you need to manage your database (Bob) Demo Scripts

Session: DAT202: Upgrade with Ease Features, Tools and Best Practices for Upgrading to SQL Server 2005 (Kimberly) Demo Scripts

Session: DAT203: Best Practices in Building Robust, Recoverable and Reliable Systems (Kimberly) Demo Scripts

Session:DAT305: Database Mirroring Best Practices and Performance Considerations (Kimberly)

  • No demo scripts from this session as it was mostly about performance. Check out Parts 7 and 8 from the TechNet Webcast Series AND the full list of blog resources for Database Mirroring. There are a bunch of resources to review here. here.

Session: DAT401: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error (Kimberly) Demo Scripts

Session: DAT402: SQL Server 2005: Advanced Indexing Strategies (Kimberly) Demo Scripts

Session: DAT303: End-to-End How a Query Executes (Paul at MS) Demo Scripts

Chalk-Talk: DATCT02: DBCC CHECKDB: Magic, Monsters, and Myths (Paul at MS) Demo Scripts


SQL Server Magazine Connections Fall November 6-10 – Las Vegas, NV

Post-Con: SQL Server Tips and Tricks to Better Performance (Kimberly) Demo Scripts

Session: SDB307: Building Blocks for a Reliable VLDB (Kimberly) Demo Scripts

Session: SDB306: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error (Kimberly) Demo Scripts

Session: SDB404: Table Partitioning Best Practices (Kimberly) No demo scripts for this session

Session:SDB403: Database Mirroring Best Practices (Kimberly)

  • No demo scripts from this session as it was mostly about performance. Check out Parts 7 and 8 from the TechNet Webcast Series AND the full list of blog resources for Database Mirroring. There are a bunch of resources to review here. here.

Microsoft TechEd Developers November 6 – 10, 2006 – Barcelona, Spain

Pre-Con:PRE005: Making the Most of SQL Server 2005: Developing World Class Database Applications (Kimberly)

Session: SQL401: SQL Server 2005 Error Handling: T-SQL, SQLCLR and Clients (Bob) Demo Scripts

Session: SQL402: Implementing the Service-Oriented Database Architecture with SQL Server 2005 (Bob) Demo Scripts

Session: SQL301: Coding SQL Server 2005 Plan Guides and Plan Forcing (Bob) Demo Scripts

Session: SQL403: Understanding Interactions of Transactions, Batches, Nested Procedures, MARS, and SQLCLR in SQL Server 2005 (Bob) Demo Scripts

Session: SQL404: SQL Server 2005 Cache Sync/Query Notifications in Depth (Bob) Demo Scripts

ChalkTalk: SMO and Powershell (Bob) Demo Scripts

Session: DAT408 & DAT409: SQL Server 2005: Advanced Indexing Strategies Part I and Part II (Kimberly) Demo Scripts

Session: DAT410: SQL Server 2005: Optimizing Procedural Code (Kimberly) Demo Scripts


Microsoft Tech*Ed South Africa October 23-25, 2006 – Sun City, South Africa

Session: DAT203: SQL Server Always On Technologies: Best Practices in Building Robust, Recoverable and Reliable Systems (Kimberly) Demo Scripts

Session:DAT301: SQL Server Always On Technologies: Database Mirroring Best Practices and Performance Considerations (Kimberly)

  • No demo scripts from this session as it was mostly about performance. Check out Parts 7 and 8 from the TechNet Webcast Series AND the full list of blog resources for Database Mirroring. There are a bunch of resources to review here. here.

Session: DAT402: SQL Server 2005: Optimizing Procedural Code (Kimberly) Demo Scripts

Session: DAT306: SQLCMD Tips and Tricks (Kimberly) Demo Scripts

Session: DAT401: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error (Kimberly) Demo Scripts

Session: DAT403 & DAT404: SQL Server 2005: Advanced Indexing Strategies Part I and Part II (Kimberly) Demo Scripts


Microsoft Tech*Ed Hong Kong September 25 – 27, 2006 – Hong Kong

Pre-Con:A Day of SQL Server 2005 for Developers (Bob)

Session: SQL Querying Tips & Techniques (Bob) Demo Scripts

Session: Next Generation Data Access in .NET: ADO.NET vNext (Bob) No demo scripts for this session

Session: Methodology for Upgrading to SQL Server 2005 (Bob) No demo scripts for this session

Session: SQL Server 2005: Scaling for All (Bob) Demo Scripts

Session: SQL Server Error Handling In T-SQL and In SqlClient (Bob) Demo Scripts

Session: XQuery Deep Dive: How to Write and Optimize Your XQuery (Bob) Demo Scripts


Microsoft Tech*Ed US June 11 – 16, 2006 – Boston, MA

Pre-Con: PRE001: Making the Most of SQL Server 2005: Developing World Class Database Applications (Kimberly) Demo Scripts

Session: DAT424: SQL Server Error Handling: T-SQL, SQLCLR and Clients (Bob) Demo Scripts

Chalk-Talk: DATTLC02: SQL Server 2005: DDL triggers, Event Notifications, and WMI in SQL Server 2005 (Bob) No demo scripts for this session

Chalk-Talk: DATTLC30: Controlling the New SQL Server 2005 Features: Setup, Security and Monitoring (Bob) No demo scripts for this session

Chalk-Talk: DATTLC17: Plan Guides and Plan Forcing in SQL Server 2005 (Bob) No demo scripts for this session

Session: DAT325: SQL Server Always On Technologies: Best Practices in Building Robust, Recoverable and Reliable Systems (Kimberly) Demo Scripts

Session: DAT413: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error (Kimberly) Demo Scripts

Session: DAT437: SQL Server 2005: Advanced Indexing Strategies (Kimberly) Demo Scripts

Chalk-Talk: DATTLC05: SQL Server 2005: Leveraging the Availability and Scalability Features of the Enterprise Edition (Kimberly) No demo scripts for this session

Chalk-Talk: DATTLC43: SQL Server 2005: SQLCMD Tips and Tricks (Kimberly) No demo scripts for this session


SQL Server Magazine Connections Spring April 2-6, 2006, Orlando, FL

Post-con: SPS301: SQL Server Availability Strategies: Building a Reliable VLDB in Depth (Kimberly) Demo Scripts

Session: SDB303: SQL Server Isolation: Locking or Versioning? (Kimberly) Demo Scripts

Session: SDB302: SQL Server Indexing: Finding the Right Balance (Kimberly) Demo Scripts

Session: SDB301: SQL Server Availability Strategies: The Building Blocks for a Reliable VLDB (Kimberly) No demo scripts for this session


UK SQL Server Community Event March 16, 2006 – Edinburgh, Scotland

Workshop: SQL Server 2005: New Features in Availability (Kimberly) Demo Scripts


Edinburgh SQL Server User Group Meeting March 15, 2006 – Edinburgh, Scotland

Session: SQL Server: Tips and Tricks in Tuning (Kimberly) Demo Scripts


UK SQL Server Community Event March 14, 2006 – Reading, UK

Workshop: SQL Server: Indexes from Every Angle (Kimberly) Demo Scripts


Microsoft DevDays March 7 – 8, 2006 – Amsterdam, Netherlands

Session: ADO.NET 2.0: Base Classes, Factories, Schemas and Tracing (Bob) Demo Scripts

Session: SQL Server 2005-Enabled Features in Data Access (Bob) Demo Scripts

Session: SQL Server 2005 Error Handling: T-SQL, SQLCLR and Clients (Bob) Demo Scripts

Session: SQL Server 2005 In-Database access – SQLCLR Techniques and Best Practices in Detail (Bob) Demo Scripts