Recent |
2018-2016 |
2015-2014 |
Pre-2010
2013-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
2013 CONFERENCE DEMOS
SQLintersection Fall (October 27-31, 2013, Las Vegas, US)
Precon: Queries Gone Wild: Real-World Solutions (Kimberly) Demo Scripts
Postcon: Practical Disaster Recovery Techniques (Paul) Demo Scripts
Session: Making SQL Server Faster – Part 1: Simple Things (Paul) Demo Scripts
Session: Making SQL Server Faster – Part 2: Not So Simple Things (Paul) Demo Scripts
Session: Understanding Logging and Recovery (Paul) Demo Scripts
Session: Understanding and Implementing an Index Strategy (Kimberly) Demo Scripts
Session: Query Plan Analysis (Kimberly) Demo Scripts
Session: The VLT: Optimizing Performance for Large Tables (Kimberly) Demo Scripts
Session: Saving the SQL Server Planet (Kimberly) Demo Scripts
Session: Solving Complex Problems with Extended Events (Jonathan) Demo Scripts
Session: Deadlocking for Mere Mortals (Jonathan) Demo Scripts
Session: Best Practice ORM Usage with SQL Server (Jonathan) Demo Scripts
Session: Key Considerations for Faster T-SQL Performance (Jonathan) Demo Scripts
Session: Making the Leap From Profiler to Extended Events (Erin) Demo Scripts
Session: Key Considerations for Better Schema Design (Erin) Demo Scripts
Session: Free Tools for More Free Time (Erin) Demo Scripts
PASS Summit (October 14-18, 2013, Charlotte, US)
Precon: Practical Disaster Recovery Techniques (Paul) Demo Scripts
Session: Waits, Latches, and Spinlocks: Internals and Analysis (Paul) Demo Scripts
Session: Index Fragmentation: Internals, Analysis, and Solutions (Paul) Demo Scripts
Session: Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (Kimberly) Demo Scripts
Session: Making the Leap from Profiler to Extended Events (Erin) Demo Scripts
Session: SQL Server Archaeology: Dig into the Past with system_health Jonathan) Demo Scripts
SQLintersection Spring (April 7-12, 2013, Las Vegas, US)
Precon: Indexing Strategies that Work: Covering – Concepts, Concerns, Costs (Kimberly) Demo Scripts
Precon: Understanding Statement Execution and Optimizing Stored Procedures (Kimberly) Demo Scripts
Postcon: Solving Query Performance Problems (Kimberly and Joe) Joe’s Demo Scripts Kimberly’s Demo Scripts
Session: SQL228: Database Design Matters (Kimberly) Demo Scripts
Session: SQL231: Indexes, Data Access and What Works! (Kimberly) Demo Scripts
Session: PANEL3: Ask Anything Index (Kimberly, Joe, Kendra Little) Resources
Session: PANEL4: Ask Anything Performance (Kimberly, Paul, Brent Ozar) Resources
Session: SQL201: Making SQL Server Faster: Part 1 – Simple Things (Paul) Demo Scripts
Session: SQL402: Making SQL Server Faster: Part 2 – Not So Simple Things (Paul) Demo Scripts
Session: SQL317: SQL Core: CPU Performance Issues (Joe) Demo Scripts
Session: SQL318: SQL Core: Performance Issue Patterns (Joe) Demo Scripts
Session: SQL227: Columnstore Index Ramp-Up (Joe) Demo Scripts
Expert Seminar at Addskills (March 12-13, 2013, Stockholm, Sweden)
Demo Scripts
DevWeek UK (March 4-8, 2013, London, UK)
Precon: Writing SQL Server Database Applications and Stored Procedures For Best Performance (Bob) Demo Scripts
Session: Modeling and implementing hierarchies with SQL Server (Bob) Demo Scripts
Session: FileStreams and FileTables in SQL Server 2012 (Bob) Demo Scripts
Session: Server and client tracing using ETW, Extended Events and SQL Server 2012 (Bob) Demo Scripts
Session: Data Movement and Windows Azure SQL Database (Bob) Demo Scripts
Session: T-SQL improvements in SQL Server 2012 (Bob) Demo Scripts
Session: SQLCLR internals, .NET 4 support, and the new memory manager in SQL Server 2012 (Bob) Demo Scripts
2012 CONFERENCE DEMOS
SQLServerDays 2012 (November 19-20 2012, Schelle, Belgium)
Precon: New Features in SQL Server 2012 (Bob) Demo Scripts
Session: Spatial Data and processing “grow up” in SQL Server 2012 (Bob) Demo Scripts
Session: Performance and Query Optimizations in SQL Server 2012 (Bob) Demo Scripts
SQL Connections Fall (October 28 – November 2, 2012 – Las Vegas, USA)
Precon (October 28): SPR201: Leveraging SQL Server 2012 Features and Tools (Kimberly and Jonathan) Kimberly’s Demo Scripts Jonathan’s Demo Scripts Session Links
Precon (October 29): SPR202: Optimizing Procedural Code: How to create High Performance Procedures (Kimberly) Demo Scripts
Session: SQL216: Making SQL Server Faster: Part 1 – Simple Things (Paul) Demo Scripts
Session: SQL417: Making SQL Server Faster: Part 2 – Not So Simple Things (Paul) Demo Scripts
Session: SQL218: Follow the Rabbit: Wrap-up Q&A (Paul & Kimberly) Demo Scripts
Session: SQL219: Database Design Matters (Kimberly) Demo Scripts
Session: SQL220: Why isn’t SQL Server using your indexes? (Kimberly) Demo Scripts
Session: SQL204: SQL Server 2012 High Availability Enhancements (Jonathan) Demo Scripts
Session: SQL205: Free Tools for the DBA (Jonathan) Demo Scripts
Session: SQL306: ORMs for the DBA (Jonathan) Demo Scripts
TechEd Europe (June 26-29 2012, Amsterdam, Netherlands)
Session: Integrating SQL Server FileTables, Property Search, and FTS/Semantic Search (Bob) Demo Scripts
TechEd North America (June 11-14 2012, Orlando, Florida)
Session: Integrating SQL Server FileTables, Property Search, and FTS/Semantic Search (Bob) Demo Scripts
Session: Exploring SQL Server Data Tier Applications (Bob) Demo Scripts
Expert Seminar at Addskills (April 3-4 2012, Stockholm, Sweden)
Session: New Features in SQL Server 2012 For Developers (Bob) Demo Scripts
SQLBits X (March 30-31 2012, London, UK)
Session: Extended Events and the new Profiler in SQL Server 2012 (Bob) Demo Scripts
Session: SQL Spatial Stretches Out In SQL Server 2012 (Bob) Demo Scripts
DevWeek UK (March 26-29 2012, London, UK)
Precon: T-SQL New features in SQL Server 2012 for developers (Bob) Demo Scripts
Session: SQL Server security best practices (Bob) Demo Scripts
Session: Extended Events and the new Profiler in SQL Server 2012 (Bob) Demo Scripts
Session: Mission-critical SQLCLR: internals and best practices (Bob) Demo Scripts
Session: Full text and semantic search in SQL Server 2008 and 2012 (Bob) Demo Scripts
Session: Developing for SQL Server 2012 with SQL Server Data Tools (Bob) No demo scripts for this session
SQL Saturday #105 (March 24 2012, Dublin, Ireland)
Session: Searching over data and files with SQL Server 2012 (Bob) Demo Scripts
SQL Connections Spring (March 27 – 29, 2012 – Las Vegas, USA)
Precon (March 25): SPR202: The Building Blocks of a Healthy and Available SQL Server (Paul and Kimberly) Kimberly’s Demo Scripts Paul’s Demo Scripts
Precon (March 25): SPR301: Advanced Diagnostics with SQLServer 2012 Extended Events (Jonathan) Demo Scripts
Precon (March 26): SPR203: Leveraging SQL Server 2012 Features and Tools (Kimberly and Jonathan) Kimberly’s Demo Scripts Jonathan’s Demo Scripts
Session Links
Postcon (March 30): SPS202: Optimizing Procedural Code: Understanding Plan Cache, Procedural Code and Recompilation (Kimberly) Demo Scripts
Session: SQL416: Wait Statistics: Avoiding ‘Knee-Jerk’ Performance Tuning (Paul) Demo Scripts
Session: SQL417: Advanced Recovery Techniques (Paul) Demo Scripts
Session: SQL218: Follow the Rabbit: Wrap-up Q&A (Paul and Kimberly) No demo scripts for this session
Session: SQL219: Performance Tuning through Indexing (Kimberly) Demo Scripts Companion content from SQL Server 2008 Internals Ch6 (Indexing) is
here
Session: SQL320: Statistics: What, Why and How the Optimizer Uses Them (Kimberly) Demo Scripts
Session: SQL307: Deadlocking for Mere Mortals (Jonathan) Demo Scripts
Session: SQL208: Distributed Replay in SQL Server 2012 (Jonathan) Demo Scripts
Tech Days 2012 (February 15-18 2012, The Hague, Netherlands)
Session: T-SQL Improvements in SQL Server 2012 (Bob) Demo Scripts
Session: Full-text and Semantic Search in SQL Server 2012 (Bob) Demo Scripts
Session: Filestreams and FileTables in SQL Server 2012 (Bob) Demo Scripts
Session: Using SQL Azure Database Federations (Bob) Demo Scripts
Session: Exploring SQL Server Data Tier Applications (Bob) No demo scripts for this sessionCONFERENCE DEMOS
2011 CONFERENCE DEMOS
SQL Connections Fall October 30 – November3, 2011 – Las Vegas, USA
Precon (November 30): SPR201: The Building Blocks of a Healthy and Available SQL Server (Paul and Kimberly) Kimberly’s Demo Scripts Paul’s Demo Scripts Hidden Slides and all links
Precon (November 31): SPR303: Designing for Performance and Scalability (Kimberly) Demo Scripts
Session: SQL419: Wait Statistics: Avoiding ‘Knee-Jerk’ Performance Tuning (Paul) Demo Scripts
Session: SQL422: Advanced Recovery Techniques (Paul) Demo Scripts
Session: SQL216: More DBA Mythbusters (Paul) No demos for this session.
Session: SQL225: Follow the Rabbit: Wrap-up Q&A (Paul and Kimberly) No demos for this session.
Session: SQL207: Precarious? Nefarious? Strategies that Work for Nonclustered Indexes! (Kimberly) Demo Scripts
Session: SQL310: Taking the Sting Out of Statistics (Kimberly) Demo Scripts
Session: SQL313: Filtered Indexes and Filtered Statistics: The good, the bad and the ugly (Kimberly) Demo Scripts
PASS Summit October 10 – 14, 2011 – Seattle, USA
Precon: DBA-498-P: Extended Events Deep Dive (Jonathan) Demo scripts
Spotlight Session: DBA-316-S: More DBA Mythbusters (Paul) Demo scripts
Spotlight Session: DBA-315-S: VLDB Isolated Disasters (Kimberly) Demo scripts
Spotlight Session: DBA-313-S: Using Event Notifications in SQL Server 2005/2008 (Jonathan) Demo scripts
SQL Connections Europe June 08 – 10, 2011 – Karlsruhe, Germany
Precon (June 8):SPR201: Performance Tuning From A to Z (Paul and Kimberly) Kimberly’s Demo Scripts Paul’s Demo Scripts
Session: SQL01: DBA Mythbusters (Paul) No demos for this session.
Session: SQL02: Corruption Survival Techniques (Paul) Demo scripts (see
this blog post for details)
Session: SQL09: Building the Right Backup Strategy (Paul) Demo Scripts
Session: SQL06: Index Fragmentation: The Hidden Menace (Paul) Demo Scripts
Session: SQL03: Optimizing Procedural Code (Kimberly) Demo Scripts
Session: SQL04: Covering: Concepts, Concerns and Costs (Kimberly) Demo Scripts
Session: SQL05: Filtered Indexes and Filtered Stats (Kimberly) Demo Scripts
Dev Days 2011 April 27-29 2011, The Hague, Netherlands
Pre-con: Multiple developer topics (Bob) Demo Scripts
Session: Full Text Search in SQL Server 2008 and Denali Demo Scripts
Session: Mission-Critical SQLCLR – Internals and Best Practices Demo Scripts
Session: Programming Filestreams and RBS in SQL Server 2008 R2 Demo Scripts
Session: Extended Events Comes of Age in SQL Server Denali Demo Scripts
SQL Connections Spring March 27 – 31, 2011 – Orlando, USA
Precon (March 27): SPR201: The Building Blocks of a Healthy and Available SQL Server (Paul and Kimberly) Kimberly’s Demo Scripts Paul’s Demo Scripts
Pre-con (March 27): SPR302: Day of Scripting: Plumbing The Depths of SQL Server / PowerShell Integration (Bob) Demo Scripts
Post-con (March 31): SPS301: Indexing Strategies and Analysis (Kimberly) Demo Scripts
Session: SDB310: Index Fragmentation: The Hidden Menace (Paul) Demo Scripts
Session: SDB412: Undocumented Tools and Trace Flags (Paul) Demo Scripts
Session: SDB208: DBA Mythbusters (Paul) No demos for this session
Session: SDB213: Follow the Rabbit: Wrap-up Q&A (Paul and Kimberly) No demos for this session
Session: SDB305: VLDB: Recovering from Isolated Disasters (Kimberly) Demo Scripts
Session: SDV303: Optimizing Procedural Code (Kimberly) Demo Scripts
Session: SDV302: Index Internals: What you really need to know! (Kimberly) Companion content from SQL Server 2008 Internals Ch6 (Indexing) is
here
Session: SDB414: Expanding the Scope and Ease of Use of Query Plan Guides in SQL Server 2008 (Bob) Demo Scripts
Session: SDV306: Full Text Search in SQL Server 2008 and Denali (Bob) Demo Scripts
Session: SDV304: Spatial Data “Stretches Out” in SQL Server Denali (Bob) Demo Scripts
DevWeek 2011 March 14 – 18, 2011 – London, UK
Precon: Writing SQL server database applications and stored procedures for best performance (Bob) Demo Scripts
Session: Performance enhancements in SQL Server 2008 (Bob) Demo Scripts
Session: A showcase application using SQL Server 2008 (Bob) Demo Scripts
Session: LINQ to SQL and Entity Framework vs. stored procedures (Bob) Demo Scripts
Session: Modeling and implementing hierarchies with SQL Server (Bob) Demo Scripts
Session: New Developer Features in SQL Server Denali (Bob) Demo Scripts
Public Class March 10-11, 2011 – Stockholm, Sweden (Bob) Demos for all modules:
Demo Scripts
