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

Pre-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 (all sessions by Kimberly)


EastMed Developers Conference November 23 – 25, 2004 – Amman, Jordan

Session: SQL Server 2000 Designing for Performance: General Database Optimizations No Demo Scripts for this session

Session: SQL Server 2000 Optimizing Procedural Code Demo Scripts

Session: SQL Server 2000 Indexing for Performance: Index Creation Best Practices Demo Scripts

Session: SQL Server 2000 Indexing for Performance: Preventing, Controlling, and Minimizing Fragmentation Demo Scripts

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


Norwegian SQL Server User Group November 22, 2004 – Oslo, Norway

Workshop: SQL Server Indexes from Every Angle – Internals, Statistics, Performance and Maintenance Demo Scripts


Microsoft ITForum November 15 – 19, 2004 – Copenhagen, Denmark

Pre-Con: SQL Server 2000 Operational Best Practices Demo Scripts

Session: Indexing for Performance: Index Creation Best Practices (DAT348)  Demo Scripts

Session: Operational Best Practices: Performance and Recovery (DAT322)  Demo Scripts

Session: Indexing for Performance: Table/Index Fragmentation Best Practices (DAT348)  Demo Scripts


SQL Server Magazine Connections Fall Nov 7 – 10, 2004 – Las Vegas, NV

Pre-Con: SPR301: Designing for Performance – Database Creation, Table Creation, Partitioning, Indexing Demo Scripts

Session: SDV432: SQL Server Logging and Recovery – What Every Developer and DBA Should Talk About…Together! Demo Scripts

Session: SDB433: SQL Server Best Practices in Index Defragmentation Demo Scripts

Session: SDB417: SQL Server 2000 Optimizing Stored Procedure Performance Demo Scripts

Session: SDB418: SQL Server Performance Tuning – Follow the Rabbit Q&A No Demo Scripts for this session


Miracle Database Forum October 28 – 30, 2004 – Lalandia, Denmark

Workshop: Designing for Performance – Database Creation, Table Creation, Partitioning, Indexing Demo Scripts


2004 PASS Community Summit Sep 28 – Oct 1, 2004 – Orlando, Florida

Pre-Con: Optimizing Procedural Code – Understanding Logging, Locking and Performance! Demo Scripts

Session: SQL Server 2005 Partitioning: Understanding the Rolling Range Demo Scripts


Microsoft Tech*Ed Asia September 13-17, 2004 – Kuala Lumpur, Malaysia

Pre-Con: Designing for Performance – General Database Optimizations, Optimizing Procedural Code and Query Optimizations through Indexing Demo Scripts

Session: Logging and Recovery: Understand How Your Transactions Impact System Recovery and Performance Demo Scripts

Session: Preserving SQL Server Performance through Index Maintenance Demo Scripts

Session: Partitioning – from Past to Present to Future! Demo Scripts


Microsoft Tech*Ed September 8-10, 2004 – Yokohama, Japan

Session: SQL Server 2005 (code-named “Yukon”) Management Tools Demo Scripts


MSDN Webcast July 19, 2004

Webcast: Indexes from Every Angle – Proper Index Maintenance Demo Scripts


Microsoft Tech*Ed Europe June 29 – July 2, 2004 – Amsterdam, The Netherlands

Pre-Con: Building Data Driven Systems with SQL Server 2000 and SQL Server 2005 Demo Scripts

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

Session: Logging and Recovery: Understand How Your Transactions Impact System Recovery and Performance (DAT361) Demo Scripts


PASS SQL Server Summer Academy June 23-25, 2004 – Dubrovnik, Croatia

Pre-Con: Designing for Performance Demo Scripts

Session: Logging and Recovery Demo Scripts


MSDN Webcast June 11, 2004

Webcast: Indexes from Every Angle – Finding the Right Balance Demo Scripts


Microsoft Tech*Ed US May 23-28, 2004 – San Diego, CA

Pre-Con: Building Data Driven Systems with SQL Server 2000 and SQL Server 2005 (PRC002) Demo Scripts

Session: Indexing for Performance – Improving Aggregations and Indexed Views (DAT348) Demo Scripts

Session: Partitioning – from Past to Present to Future! (DAT350) Demo Scripts

Session: The Clustered Index Debate (DAT351) Demo Scripts

Session: Preserving SQL Server Performance through Index Maintenance (DAT349) Demo Scripts

Session: Logging and Recovery: Understand How Your Transactions Impact System Recovery and Performance (DAT361) Demo Scripts

Session: SQL Server 2005: Backup and Restore Engine (DAT324) Demo Scripts


SQL Server Connections April 18-21, 2004 – Orlando, FL

Pre-Con: Indexes from Every Angle – Internals, Performance and Maintenance (SPR301) Demo Scripts

Session: Optmizing Stored Procedure Performance (SDB419) Demo Scripts

Session: Follow the Rabbit – Performance Tuning Q&A (SDB418) Demo Scripts

Session: Database Recovery Models – What Everyone Should Know about Performance, Recovery and Logging (SDB321) Demo Scripts

Session: Indexing for Performance – Finding the Right Balance (SDB420) Demo Scripts


SQLLive! March 23-27, 2004 – San Francisco, CA

Workshop: Indexing for Speed – Internals, Statistics, Performance, Maintenance Demo Scripts

Session: Understanding Logging and Recovery – What Programmers Always Avoid Until it’s too Late! Demo Scripts

Session: Indexing for Performance – Finding the Right Balance Demo Scripts


PASS Community Summit November 2003 – Seattle, WA

Pre-Con: Indexes from Every Angle – Internals, Statistics, Performance & More Demo Scripts

Spotlight Session: Designing for Performance – General Database Optimizations Demo Scripts


SQL Server Magazine Connections Fall October 12-15, 2003 – Palm Springs, CA

Pre-Con: Indexes from Every Angle – Internals, Performance and Maintenance (SPR203) Demo Scripts

Session: Database Recovery Models – What Everyone Should Know about Performance, Recovery and Logging (SDB308) Demo Scripts

Session: Indexes from Every Angle – The Clustered Index Debate (SDB310) Demo Scripts

Session: Optmizing Stored Procedure Performance (SDV436) Demo Scripts

Session: Designing for Performance – General Database Optimizations (SDB309) Demo Scripts


VSLive! September 8-12, 2003 – Orlando, FL

Workshop: Optimize your SQL Server 2000 Database with Ease Demo Scripts

Session: Indexing for Performance – Finding the Right Balance Demo Scripts

Session: Understanding Logging and Recovery – What Programmers Always Avoid Until it’s too Late! Demo Scripts


SQL Server Magazine Online Webseminar September 2003

Session: Part I – Performance Tuning – Where do you begin? No demo scripts for this session

Session: Part II – Performance Tuning – Optimizing Query Performance Demo Scripts

Session: Part III – Performance Tuning – Optimizing Procedural Code Demo Scripts

Session: Part IV – Performance Tuning – Optimizing Procedural Code (continued) Demo Scripts


SQL Server Summer Academy July 14-16, 2003 – Dubrovnik, Croatia

Session: Indexes from Every Angle – Internals, Performance & Maintenance Demo Scripts


Microsoft Tech*Ed Jun 30 – July 4, 2003 – Barcelona, Spain

Session: SQL Server 2000 Tips and Tricks for DBAs and Developers (DAT335) Demo Scripts

Session: Designing for Performance: Structures, Partitioning, Views and Constraints (DBA324) Demo Scripts

Session: Designing for Performance: Optimization with Indexes (DBA328) Demo Scripts

Session: Optimizing Stored Procedure Performance in SQL Server 2000 (DAT402) Demo Scripts


South Sound .Net Users Group June 12, 2003

Session: Optimizing Stored Procedure Performance in SQL Server 2000 Demo Scripts


Microsoft Tech*Ed USA June 2-6, 2003 – Dallas, TX

Session: Optimizing Stored Procedure Performance in SQL Server 2000 Demo Scripts

Session: Designing for Performance: Structures, Partitioning, Views and Constraints Demo Scripts

Session: SQL Server 2000 Tips and Tricks for DBAs and Developers Demo Scripts

Session: Designing for Performance: Optimization with Indexes Demo Scripts

Session: Preserving SQL Server 2000 Performance Through Index Maintenance Demo Scripts


SQL Server Magazine Online Webseminar May 16, 2003

Session: Indexing for Performance, Part IV – Index Maintenance Demo Scripts


SQL Server Magazine Connections Spring May 6-9, 2003 – New Orleans, LA

Pre-Con: Tuning Databases for High Performance on SQL Server 2000 Demo Scripts

Session: The Clustered Index Debate Demo Scripts

Session: Backup/Restore Strategies for VLDBs Demo Scripts

Session: Understand and Optimize Stored Procedure Performance Demo Scripts

Session: Indexes from Every Angle – Indexed Views and Aggregations Demo Scripts


SQL Server Magazine Online Webseminar May 2, 2003

Session: Indexing for Performance, Part III – Aggregations and Indexed Views Demo Scripts


VSLive! April 2003 – Chicago, IL

Post-Con: Build and Maintain High Performance Databases with SQL Server 2000  Demo Scripts

Session: Designing for Performance: General Database Optimizations Demo Scripts


SQL Server Magazine Online Webseminar April 11, 2003

Session: Indexing for Performance, Part II – SARGs & Joins Demo Scripts


SQL Server Magazine Online Webseminar April 4, 2003

Session: Indexing for Performance, Part I – Overview & Internals Demo Scripts


SQLLive! February 2003 – San Francisco, CA

Session: Designing for Performance: General Database Optimizations Demo Scripts


PASS Community Summit November 2002 – Seattle, WA

Pre-Con: Recovery with Backup & Restore Demo Scripts

Spotlight Session: Understand and Optimize Stored Procedure Performance Demo Scripts


SQL Server Magazine LIVE! October 2002 – Orlando, FL

Pre-Con: Tuning High Performance SQL Server 2000 Databases Demo Scripts

Session: Indexing for Optimal Performance SAA327 Demo Scripts

Session: Indexed Views SAA328 Demo Scripts

Session: Backup/Restore Strategies for VLDBs SAA329 Demo Scripts


SQLLive! September 2002 – Orlando, FL

Post-Con: Build and Maintain High Performance Databases with SQL Server 2000 Demo Scripts

Session: Designing for Performance: General Database Optimizations Demo Scripts

Session: Tips & Tricks and Otherwise Coolstuff-for Administrators! Demo Scripts

Session: Tips & Tricks and Otherwise Coolstuff-for Developers! Demo Scripts


PASS Regional Seminar Series August 2002 – Las Vegas, NV

Workshop: Tuning High Performance SQL Server 2000 Databases Demo Scripts


PASS Regional Seminar Series June 2002 – Chicago, IL

Workshop: Tuning High Performance SQL Server 2000 Databases Demo Scripts


SQLLive! April 2002 – Sydney, Australia

Session: Tune Up Your SQL Server 2000 Databases with Better Indexing Demo Scripts

Session: SQL Server 2000: Tips & Tricks and Otherwise Cool Stuff Demo Scripts

Session: Optimize Your .NET SQL Server Database Demo Scripts

Session: Optimize Stored Procedure Performance Demo Scripts


VSLive! April 2002 – Chicago, IL

Post-Con: Build and Maintain High Performance Databases with SQL Server 2000 Demo Scripts

Session: Optimize Your .NET SQL Server Database Demo Scripts


PASS North America January 2002 – Denver, CO

Pre-Con: Achieving High Availability with SQL Server 2000 No demo scripts for this session

Session: Indexes from Every Angle, Part I Demo Scripts

Session: Indexes from Every Angle, Part II Demo Scripts