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

2005 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 14 – 18, 2005 – Barcelona, Spain

Pre-Con: Designing for Performance with SQL Server 2005 (Kimberly) Demo Scripts

Session: SQL Server 2005: What’s the Server Doing Now? (DAT303) (Kimberly) Demo Scripts

Session: SQL Server 2005 Security for System Administrators (DAT311) (Kimberly) Demo Scripts

Session: SQL Server 2005 Indexing: It Really Does Help! (DAT307) (Kimberly) Demo Scripts

Session: SQL Server 2005: Fixing Fragmentation from Disk to Log to Indexes (DAT309) (Kimberly) Demo Scripts

Session: Managing VLDB Databases in SQL Server 2005: Availability and Recovery Strategies (DAT315) (Kimberly) Demo Scripts

Chalk-Talk: Your High-Availability Options with SQL Server 2005 (CHT036) (Kimberly) No demo scripts for this session

Session: SQL Server 2005: Understanding the Operational Impact of Service Broker (DAT301) (Bob) Demo Scripts

Session: Architecting the Right Solution – Transact-SQL or SQLCLR : What DBA’s Should Know (DAT302) (Bob) Demo Scripts

Session: SQL Server 2005: Transact-SQL is Not Dead! (DAT304) (Bob) Demo Scripts

Session: SQL Server 2005: Architecting the Right Solution with New Type Choices (DAT310) (Bob) Demo Scripts


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

Pre-Con: Understanding and Effectively Using SQL Server 2005′s New Tools (Kimberly) Demo Scripts

Session: SQL Server 2005 Partitioning (Kimberly) Demo Scripts

Session: SQL Server Index Creation Best Practices (Kimberly) Demo Scripts

Session: SQL Server Index Maintenance Best Practices (Kimberly) Demo Scripts

Session: SQL Server 2005: Optimizing Stored Procedure Performance (Kimberly) Demo Scripts


Microsoft Tech*Ed Hong Kong October 3 – 6, 2005 – Hong Kong

Pre-Con: Get Ready for SQL Server 2005, what every developer should know (Bob) Demo Scripts

Session: SQLCLR vs. T-SQL: Best Practices for Development in the Database (Bob) Demo Scripts

Session: Service-Oriented Data Architecture (SODA) How SQL Server 2005 Fits into the Service-Oriented Architecture (SOA) World (Bob) Demo Scripts

Session: Integrated Innovation: Using ADO.NET 2.0 with SQL Server 2005 (Bob) Demo Scripts

Session: Developing Secure Applications with SQL Server 2005 (Bob) Demo Scripts

Session: Together at Last: Combining XML and Relational Data in SQL Server 2005 (Bob) Demo Scripts

Session: Adding Alerting Functionality to Database Applications with SQL Server Notification Services (Bob) Demo Scripts

Session: Introducing SSMA: Migrating from Oracle to SQL Server with 80% Less Effort (Bob) No demo scripts for this session


2005 PASS Community Summit September 27-30, 2005 – Grapevine, Texas

Pre-Con: The Next Generation DBA: Critical New SQL Server 2005 Features YOU Need to Learn! (Kimberly) Demo Scripts

Pre-Con: Part 1: Essential SQL Server 2005: New Features in SQL Server 2005 and .NET for Developers In-Depth (Bob) Demo Scripts

Pre-Con: Part 2: Essential SQL Server 2005: New Features in SQL Server 2005 and .NET for Developers In-Depth (Bob) Demo Scripts

Spotlight Session: Indexing Best Practices in SQL Server 200x – A Fast-paced Collection of Tips and Tricks for BOTH SQL Server 2000 and SQL Server 2005 (Kimberly) Demo Scripts

Spotlight Session: SQL Server 2005 XQuery Primer (Bob) Demo Scripts


Microsoft Tech*Ed Europe July 4 – 8, 2005 – Amsterdam, the Netherlands

Pre-Con: SQL Server 2005 Management Tools: Effectively Using and Understanding the new SQL Server 2005 Toolset (Kimberly) Scripts for the Self-paced Labs

Session: SQL Server 2005: Bridging the Gap between Development and Administration (Kimberly) Demo Scripts

Session: SQL Server 2005 Security for System Administrators (Kimberly) Demo Scripts

Session: Understanding Index Usage and Indexing Best Practices in SQL Server 2005 (Kimberly) Demo Scripts

Session: Index Defragmentation Best Practices in SQL Server 2005 (Kimberly) Demo Scripts

Session: VLDB Availability and Recovery Strategies for SQL Server 2005 (Kimberly) Demo Scripts

Session: Understanding Transaction Isolation in SQL Server 2000 and 2005 (Kimberly) Demo Scripts

Session: Achieving High Availability with SQL Server 2005 (Kimberly) Demo Scripts

Session: SQL Server 2005 Security for Database Developers (Kimberly) Demo Scripts


Microsoft Tech*Ed US June 5 – 10, 2005 – Orlando, Florida

Pre-Con: Taming the Tools: Effectively Using and Understanding SQL Server 2005 Tools (Kimberly) Demo Scripts

Session: Understanding Index Usage and Indexing Best Practices in SQL Server 2005 (Kimberly) Demo Scripts

Session: GrokTalk – On Stored Procedure Recompilation (Kimberly) Demo Scripts

Session: VLDB Availability and Recovery Strategies for SQL Server 2005 (Kimberly) Demo Scripts

Session: Understanding Transaction Isolation in SQL Server 2000 and 2005 (Kimberly) Demo Scripts

Session: SQL Server 2005: Bridging the Gap between Development and Administration (Kimberly) Demo Scripts


PASS European Conference May 11 – 13, 2005 – Munich, Germany

Pre-Con: The Next Generation DBA: Critical New SQL Server 2005 Features YOU Need to Learn! (Bob) Demo Scripts

Session: Indexing Best Practices in SQL Server 2000: From Creation to Performance to Maintenance (Bob) Demo Scripts

Session: Changes to Indexing in SQL Server 2005: From Creation to Performance to Maintenance to Monitoring (Bob) Demo Scripts


Microsoft Professional Developers Summit April 25 – 27, 2005 – Istanbul, Turkey

Session: SQL Server 2005: Bridging the Gap between Development and Administration (Kimberly) Demo Scripts

Session: SQL Server 2005: New Features in Performance, Manageability and Recovery, Part I (Kimberly) Demo Scripts

Session: SQL Server 2005: New Features in Performance, Manageability and Recovery, Part II (Kimberly) Demo Scripts

Session: SQL Server Indexing Best Practices (Kimberly) Demo Scripts

Session: SQL Server 2005: Indexing New Features (Kimberly) Demo Scripts

Session: SQL Server Partitioning Strategies (for both SQL Server 2000 and SQL Server 2005) (Kimberly) Demo Scripts


SQL Server Magazine Connections Spring March 20 – 24, 2005 – Orlando, FL

Pre-Con: SPR353: SQL Server Indexes from Every Angle – Internals, Statistics, Performance, and Changes Expected in SQL Server 2005 (Kimberly) Demo Scripts

Session: SDB356: SQL Server Partitioning, Part I: SQL Server 2000 Partitioned Views and SQL Server 2005 Partitioned Tables (Kimberly) Demo Scripts

Session: SDB357: SQL Server Partitioning, Part II: Implementing SQL Server 2005 Partitioned Tables (Kimberly) Demo Scripts

Session: SDB355: SQL Server 2005 – New Features for VLDBs (Kimberly) Demo Scripts

Session: SDB406: SDB406: SQL Server Index Maintenance Best Practices (Kimberly) Demo Scripts


Microsoft Tech Days March 16 – 17, 2005 – Interlaken, Switzerland

Keynote Session: SQL Server 2005: Bridging the Gap between Development and Administration (Kimberly) Demo Scripts

Session: Operational Best Practices: Recovery and Performance in SQL Server 2000 (Kimberly) Demo Scripts

Session: SQL Server 2000 Performance Best Practices and Getting Ready for SQL Server 2005 (Kimberly) Demo Scripts


.NET Managed User Group of Switzerland March 14, 2005 – Microsoft Zurich


SQL Server 2005 Ascend Program February 28 – March 4, 2005 – Microsoft UK Delivery


SQLLive! at VSLive February 8- 9, 2005 – San Francisco, CA

Post-Con: SQL Server 2000: Optimizing Server-Side Processing in SQL Server: Transactions, Recovery, Logging and Locking (Kimberly) Demo Scripts

Session: SQL Server 2000: Indexing Best Practices (Kimberly) Demo Scripts

Session: SQL Server 2005: Indexing New Features (Kimberly) Demo Scripts


Microsoft Developer and ITPro Days February 1 – 2, 2005 – Brussels, Belgium

Keynote Session: SQL Server 2005: Bridging the Gap between Development and Administration (Kimberly) Demo Scripts

Session: SQL Server 2005 for DBAs, Part I (Kimberly) Demo Scripts

Session: SQL Server 2005 for DBAs, Part II (Kimberly) Demo Scripts


Microsoft Middle East Developers Conference January 29 – 31, 2005 – Cairo, Egypt

General Session: SQL Server 2005: Bridging the Gap between Development and Administration (Kimberly) Demo Scripts

Session: SQL Server 2005: New Features in Performance, Manageability and Recovery (Kimberly) Slide Handouts

Session: SQL Server 2005: Changes in Indexing (Kimberly) Demo Scripts


SQL Server 2005 Ascend Program January 24 – 28, 2005 – Las Colinas, Texas


SQL Server 2005 Ascend Program January 10 – 14, 2005 – Charlotte, North Carolina