Recent |
2018-2016 |
2015-2014 |
2013-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 2021: Community Keynote (Kimberly/Paul) Video
- PASS 2020: Query Store Best Practices (Erin) Video
- PASS 2020: Understanding Execution Plans (Erin) Video
- PASS 2020: Extending Your Use of Extended Events (Erin) Video
- PASS 2019: Eliminating Anti-Patterns and RBAR for Faster Performance (Jon) Video
- PASS 2019: Deadlocking for Mere Mortals (Jon) Video
- PASS 2017: Query Store and Automatic Tuning in SQL Server (Erin) Video
- PASS 24hop 2014: Everything You Never Wanted to Know About Extended Events (Jon/Erin) Video
- PASS 24hop 2014: Common SQL Server Mistakes and How to Avoid Them (Tim) Video
- PASS 2014: Going Asynchronous with Service Broker (Jon) Video
- PASS 2014: Dealing with Multipurpose Procs and PSP (Parameter Sensitivity Problems) the RIGHT Way! (Kimberly) Video
- PASS 2013: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Video
- PASS 2013: Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (Kimberly) 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
