2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010

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

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


SQL Connections Fall November 9 – 13, 2009 – Las Vegas, USA

Pre-con (November 9):SQL Server 2005/2008: Database Maintenance Best Practices (Paul and Kimberly)

Post-con (November 13):SQL Server 2005/2008: Indexing for Performance (Kimberly)

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

Session: SDB303: Understanding Logging and Recovery in SQL Server (Paul) Demo Scripts

Session: SDB305: Building the Right Backup Strategy (Paul) Demo Scripts

Session: SDV307: SQL Server Covering: Concepts, Concerns, & Costs (Kimberly) Demo Scripts

Session: SDV308: SQL Server 2008 Sparse Columns: Structures, Storage, Speed (Kimberly) Demo scripts

Session: SDV309: Follow the Rabbit: Interactive Q & A on… Everything! (Paul and Kimberly) No demo scripts for this session


Microsoft TechEd Europe November 9 – 13, 2009 – Berlin, Germany

Session: DAT401: Auditing and Compliance Features in SQL Server 2008 (Bob) Demo scripts

Session: DAT405: Peeking into the plan cache with SQL Server 2008 (Bob) Demo scripts

Session: DAT03-IS: Filtered Indexes and Statistics in SQL Server 2008 (Bob) Demo scripts


SQL PASS Community Summit November 2 – 6, 2009 – Seattle, USA

Pre-con (November 2):SQL Server 2005/2008: Indexing for Performance (Kimberly)

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

Post-con (November 6): Disaster Recovery: Tips, Tricks, and Techniques (Paul) Demo Scripts

Spotlight Session: Understanding Logging and Recovery in SQL Server (Paul) Demo Scripts

Spotlight Session: SQL Server Covering: Concepts, Concerns, & Costs (Kimberly) Demo Scripts


SQL Connections Spring March 22 – 26, 2009 – Orlando, USA

Pre-con (March 21): A Day of SQL Server 2008 Spatial Data and Location-Aware Applications (Bob) Demo Scripts

Pre-con (March 22): SQL Server 2005/2008 Indexes from Every Angle – Internals, Statistics and Fragmentation (Paul and Kimberly) Demo Scripts (~5MB)

Post-con (March 26): SQL Server 2005/2008 Indexes from Every Angle – Are Your Indexing Strategies Working? (Paul and Kimberly) Demo Scripts (~5MB)

Session: SDV302: Programming Filestreams in SQL Server 2008 (Bob) Demo Scripts

Session: SDB304: Essential Database Maintenance (Paul and Kimberly) Demo Scripts (we didn’t do any, but these scripts are applicable)

Session: SDV308: Indexing for Performance (Kimberly) Demo Scripts

Session:SDB310: Corruption Survival Techniques (Paul)

Session: SDV314: Practical SQL Server Security for Architects and Developers (Bob) Demo Scripts

Session: SDB316: Scripting SQL Server 2008 Policies and Data Collection with PowerShell and SMO (Bob) Demo Scripts

Session: SDV320: SQL Server 2008 Sparse Columns and Filtered Indexes (Kimberly)

Session: SDB322: Follow the Rabbit: Interactive Q&A on Database Maintenance (Paul and Kimberly) No demo script for this session


PASS Community Summit November 17-21, 2008 – Seattle, Washington

Pre-con (November 18): Database Maintenance: From Planning to Practice to Post-Mortem (Paul and Kimberly) Demo Scripts

Pre-con (November 18): SQL Server 2008 Features For Developers In-Depth (Bob) Demo Scripts

Spotlight Session:Corruption Survival Techniques (Paul)

Session: Index Internals and Usage (Kimberly – stepped in at the last minute!) Demo Scripts

Spotlight Session: Using Spatial Data in SQL and in Clients (Bob) Demo Scripts


SQL Connections Fall November 9-14, 2008 Las Vegas, USA

Pre-con (November 9): Database Best Practices for the Involuntary DBA (Paul and Kimberly) Demo Scripts

Pre-con (November 10): Relational Data Warehousing: Leveraging Key Features of SQL Server 2005/2008 (Paul and Kimberly) Demo Scripts

Session: SDV303: Index Internals and Usage (Kimberly) Demo Scripts

Session: SDB405: Essential Database Maintenance (Paul and Kimberly) Demo Scripts

Session: SDB412: DBCC CHECKDB: The Definitive Guide (Paul)

Session: SDB313: Follow the Rabbit: Interactive Q&A on Database Maintenance (Paul and Kimberly) No demo scripts for this session


Microsoft TechEd EMEA Developers November 10 – 14, 2008 – Barcelona, Spain

Session: DAT302: Programming Filestreams in SQL Server 2008 (Bob) Demo Scripts

Session: DAT303: SQLCLR Enhancements in SQL Server 2008 (Bob) Demo Scripts

Session: DAT304: Supporting a Sparse Property Design in SQL Server 2008 (Bob) Demo Scripts

Session: DAT305: Performance Enhancements in SQL Server 2008 (Bob) Demo Scripts

Session: DAT314: Programming PowerShell in SQL Server 2008 (Bob) Demo Scripts


Microsoft TechEd EMEA IT Professionals November 3 – 7, 2008 – Barcelona, Spain

Instructor-Led Lab: DAT02-ILL: Combining Database Mirroring and Transactional Replication in SQL Server 2008 (Paul) Demo Scripts

Instructor-Led Lab:DAT04-ILL: Corruption Recovery Techniques (Paul)

Instructor-Led Lab: DAT01-ILL: SQL Server Worst Practices Fixed (Kimberly) No demo scripts for this session

Instructor-Led Lab: DAT03-ILL: Microsoft SQL Server 2008: Analyze and Tune your Workload (Kimberly) No demo scripts for this session

Session: DAT305: Microsoft SQL Server 200x: Are Your Indexing Strategies Working? (Kimberly) Demo Scripts

Session: DAT308: SQL Server Worst Practices Exposed, Part I (Kimberly) No demo scripts for this session

Session: DAT309: SQL Server Worst Practices Exposed, Part II (Kimberly) No demo scripts for this session

Session:DAT307: Surviving Database Corruption – From Detection to Resolution (Paul)

Session: DAT312: SQL Server 2008 Replication: Providing High-Availability Using Database Mirroring (Paul) Demo Scripts

Session: DAT313: Performance Benefits of new SQL Server 2008 T-SQL features (Bob) Demo Scripts

Session: DAT08-IS: Diagnosing Errors and Performance Problems using SQL Server Extended Events (Bob) Demo Scripts


Microsoft TechEd ITPro US June 9 – 13, 2008 – Orlando, FL

Session: DAT354: Are Your Indexing Strategies Working? (Kimberly) Demo Scripts

Session:DAT375: Corruption Survival Techniques (Paul)


Microsoft TechEd Developers US June 2 – 6, 2008 – Orlando, FL

Pre-con: PRC14: SQL Server 2008 New Features Overview for Developers (Bob) Demo Scripts

Session: DAT404: Practical SQL Server Security For Developers and Architects (Bob) Demo Scripts

Session: DAT401: End-to-End Tracing with SQL Server 2008 and ADO.NET (Bob) Demo Scripts

Session: DAT308: PowerShell in SQL Server 2008 (Bob) Demo Scripts


SQL Connections Spring April 20 – 24, 2008 – Orlando, USA

Pre-con: SPR201: The Accidental DBA Workshop (Paul and Kimberly) Demo Scripts

Pre-con: SPR302: SQL Server 2008 Overview for Developers (Bob) Demo Scripts

Session: SDB403: Diagnosis with Extended Events in SQL Server 2008 (Bob) Demo Scripts

Session: SDB304: PowerShell in SQL Server 2008 (Bob) Demo Scripts

Session: SDV306: Spatial Support in Microsoft SQL Server 2008 (Bob) Demo Scripts

Session: SDB307: Learn the XML You Need to Manage Your Database (Bob) Demo Scripts


Microsoft TechEd ITForum November 12 – 16, 2007 – Barcelona, Spain

Chalk-Talk: DAT01-IS: SQL Server Upgrade Best Practices, Tips, and Tricks (Paul and Kimberly) No demo scripts for this session

Chalk-Talk: DAT02-IS: SQL Server 2005 Database Mirroring: Setup to Implementation to Monitoring (Paul and Kimberly) No demo scripts for this session

Instructor-Led Lab: DAT03-ILL: SQL Server Always On Technologies Part 1 – Database Mirroring (Paul and Kimberly) No demo scripts for this session

Instructor-Led Lab: DAT04-ILL: SQL Server Always On Technologies Part 2 – Database Snapshots (Paul and Kimberly) No demo scripts for this session

Instructor-Led Lab: DAT05-ILL: SQL Server Always On Technologies Part 3 – Online Operations (Paul and Kimberly) No demo scripts for this session

Session: DAT301: SQL Server Indexing – Unraveling the Unknown (Kimberly) Demo Scripts

Session: DAT205: The Next Release of Microsoft SQL Server: Manageability Overview (Kimberly) Demo Scripts

Session: DAT01-PD: Database Recovery Techniques (Paul) Demo Scripts

Session: DAT305: Secrets to Fast Detection and Recovery from Database Corruptions (Paul) Demo Scripts

Chalk-Talk: DAT07-IS: DBCC Internals (Paul) No demo scripts for this session

Session: DAT307: SQL Performance Query Tips and Techniques (Bob) Demo Scripts

Chalk-Talk: DAT04-IS: New T-SQL Programmability Features in Microsoft SQL Server 2008 (Bob) Demo Scripts

Chalk-Talk: DAT10-IS: Using Windows Powershell with the SQL Server 2008 Provider and SMO (Bob) No demo scripts for this session

Chalk-Talk: DAT03-IS: Spatial Support in Microsoft SQL Server 2008 Provider and SMO (Bob) No demo scripts for this session


Microsoft TechEd Developers November 5 – 9, 2007 – Barcelona, Spain

Session: DAT307: Best Practices for Optimizing Procedural Code and Queries in SQL Server 2005 and Beyond (Bob) Demo Scripts

Session: DAT308: Best Practices for Optimizing Service-Based Code in SQL Server 2005 and Beyond (Bob) Demo Scripts

Session: DAT309: Best Practices for Optimizing SQLCLR in SQL Server 2005 and Beyond (Bob) Demo Scripts

Session: DAT310: Best Practices for Optimizing Transactional Code in SQL Server 2005 and Beyond (Bob) Demo Scripts

Session: DAT311: Best Practices for Optimizing XML Queries in SQL Server 2005 and Beyond (Bob) Demo Scripts

Chalk-Talk: DAT04-IS: SQL CLR Best Practices Discussion and Examples using Lessons Learned from Customer Deployments (Bob) No demo scripts for this session

Chalk-Talk: DAT05-IS: Server Service Broker Architecture for Performance Discussion Using Lessons Learned from Customer Deployments (Bob) No demo scripts for this session

Chalk-Talk: DAT07-IS: To ODBC or To OLE DB? (Bob) No demo scripts for this session

Chalk-Talk: DAT08-IS: Using Powershell and SQL Server Management Objects (SMO) Together to Manage SQL Server (Bob) No demo scripts for this session


Microsoft Tech*Ed 2007 Hong Kong August 28 – 30, 2007 – Hong Kong

Pre-Con: PRE001: Optimizing and Best Practices for SQL Server 2005 Features – With A Look to the Future (Bob) Demo Scripts

Session: DAT316: Microsoft SQL Server 2005 Security Best Practices (Bob) No demo scripts for this session

Session: DAT329: Microsoft SQL Server Always-On Technologies: Advanced Indexing Strategies (Bob) Demo Scripts

Session: DAT382: SQL Server in 2007: Working with Vista and SP2 (Bob) Demo Scripts

Session: DAT314: Implementing Scale-Out Solutions with Microsoft SQL Server 2005 (Bob) Demo Scripts

Session: DAT326: Microsoft SQL Server 2005 Compact Edition in Action (Bob) No demo scripts for this session


DevConnections Workshops 15 June 2007 – Amsterdam, The Netherlands

Pre-con: Optimizing And Best Practices for all SQL Server 2005 Features (Bob) Demo Scripts


Microsoft Tech*Ed US June 4 – 8, 2007 – Orlando, FL

Pre-con: PRCN06: Leveraging SQL Server Always-On Technologies to Achieve High Availability and Scalability (Bob and Kimberly) Demo Scripts

Session: DAT314: Implementing Scale-Out Solutions with Microsoft SQL Server 2005 (Bob) Demo Scripts

Chalk-Talk: DAT01-TLC: DDL Triggers, Event Notifications, and WMI in SQL Server 2005 (Bob) Demo Scripts

Chalk-Talk: DAT12-TLC: Using Microsoft Windows PowerShell and SMO Together (Bob) Slides and Demo Scripts

Session: DAT327: Microsoft SQL Server 2005 Always-On Demo Fest (Kimberly) Demo Scripts

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

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

Chalk-Talk: DAT02-TLC: Microsoft SQL Server 2005 VDLB Maintenance Best Practices Q&A (Paul and Kimberly) No demo scripts for this session


Microsoft Developer and ITPro Days March 28-29, 2007 – Ghent, Belgium

Session: Improve database application performance using SQL Server Service Broker (Bob) Demo Scripts

Session: SQL Query Plans In Depth – 80/20 tuning (Bob) Demo Scripts

Session: ADO.NET vNext – The Entity Data Model, Object Services, and LINQ (Bob) Demo Scripts

Session: SQL Server in 2007: Working with Vista and SQL Server SP2 (Bob) Demo Scripts


SQL Server Magazine Connections Spring March 25-29, 2007 – Orlando, FL

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

Post-Con: Crucial Database Maintenance Techniques(Paul and Kimberly) No demo scripts for this session

Session: SDB308: Recovering from Isolated Disasters and Human Error (Kimberly) Demo Scripts

Session: SDV:312: Follow the Rabbit: Interactive Q&A on Availability (Paul and Kimberly) No demo scripts for this session

Session: SDB:309: Follow the Rabbit: Interactive Q&A on the SE and RE (Paul and Kimberly) No demo scripts for this session


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


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


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