Pre-2007 Demo Scripts

2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007

Pre-2007 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.

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)
2014 SalesDB Sample Database (17MB zip/28MB compressed backup/240MB restore)
2008 IndexInternals Sample Database (6MB zip/6MB backup/410MB restore)
- Note: This database was originally created for the Microsoft Press book SQL Server 2008 Internals. Review this blog post for more information and an SSMS solution file with a number of scripts on internals.
Baseball Stats Sample Database (23MB zip/110MB backup)
- Note: This is based on the Lahman baseball database from here.
2012 Employee Case Study Sample Database (13MB zip/13MB backup/300MB 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.

2000 Corrupt Database (40KB zip/~1MB restored)
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)

There are a couple of corrupt 2014 AdventureWorks databases that are used during the IE0 class in this zip. (90MB zip/~670MB restored)

“BEST OF PASS” RECORDED SESSIONS

PASS 2017: Query Store and Automatic Tuning in SQL Server (Erin) Video
PASS 2015: DBA Mythbusters (Paul) Video
PASS 2015: SQL Server Indexing Performance (Kimberly) Video
PASS 2014: Advanced Data Recovery Techniques (Paul) Video
PASS 2014: Five Execution Plan Patterns to Watch For (Erin) Video

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 EaseFeatures, 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

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

Demo Scripts

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

Demo Scripts

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

Demo Scripts

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

Demo Scripts

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