SQLskills My Account
SQL Immersion Events
Upcoming Events
Kimbery Tripps SQL Immersion Events
SQL Server Training
Paul Randal
Paul Randall
disaster recovery
Immerse Yourself In SQL Server

Upcoming Events | Past Events | Event Log

Sample Databases
As used in most conference sessions, these two 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.
 Credit Sample Database (48MB zip/155MB backup/700MB restore)

 Sales Sample Database (18MB zip/196MB backup/240MB restore)

 
SQL Connections, Spring 2008
April 20 - 24, 2008 - Orlando, USA
The Accidental DBA Workshop, presented by Paul S. Randal and Kimberly L. Tripp:
 Demo Scripts

Pre-conference Workshop presented by Bob Beauchemin:
- SPR302: SQL Server 2008 Overview for Developers Saturday, 19 Apr 2008
 Demo Scripts

Conference Sessions presented by Bob Beauchemin:
- SDB403: Diagnosis with Extended Events in SQL Server 2008
Tuesday, 22 April 2008
 Demo Scripts

- SDB304: PowerShell in SQL Server 2008
Tuesday, 22 April 2008
 Demo Scripts

- SDV306: Spatial Support in Microsoft SQL Server 2008
Wednesday, 23 April 2008
 Demo Scripts

- SDB307: Learn the XML You Need to Manage Your Database
Wednesday, 23 April 2008
 Demo Scripts

 
Miracle/SQLskills Seminars
March 31, 2008 - Reykjavik, Iceland
The Accidental DBA, presented by Paul S. Randal and Kimberly L. Tripp:
 Demo Scripts

 
Microsoft TechEd ITForum
November 12 - 16, 2007 - Barcelona, Spain
  Presented by Microsoft Corporation
Chalk-talks, presented by Paul S. Randal and Kimberly L. Tripp:
- DAT01-IS: SQL Server Upgrade Best Practices, Tips, and Tricks
- DAT02-IS: SQL Server 2005 Database Mirroring: Setup to Implementation to Monitoring
Instructor-Led Labs, presented by Paul S. Randal and Kimberly L. Tripp:
- DAT03-ILL: SQL Server Always On Technologies Instructor-Led Lab: Part 1 - Database Mirroring
- DAT04-ILL: SQL Server Always On Technologies Instructor-Led Lab: Part 2 - Database Snapshots
- DAT05-ILL: SQL Server Always On Technologies Instructor-Led Lab: Part 3 - Online Operations
Conference Sessions, presented by Kimberly L. Tripp:
- DAT301: SQL Server Indexing - Unraveling the Unknown
 Demo Scripts

- DAT205: The Next Release of Microsoft SQL Server: Manageability Overview
 Demo Scripts

Conference Sessions, presented by Paul S. Randal:
- DAT01-PD: Database Recovery Techniques
 Demo Scripts

- DAT305: Secrets to Fast Detection and Recovery from Database Corruptions
 Demo Scripts

Chalk-talks, presented by Paul S. Randal:
- DAT07-IS: DBCC Internals
 Demo Scripts

Conference Sessions, presented by Bob Beauchemin:
- DAT307: SQL Performance Query Tips and Techniques
 Code Samples

Chalk-talks, presented by Bob Beauchemin:
- DAT04-IS: New T-SQL Programmability Features in Microsoft SQL Server 2008
 Code Samples

- DAT10-IS: Using Windows Powershell with the SQL Server 2008 Provider and SMO
- DAT03-IS: Spatial Support in Microsoft SQL Server 2008 Provider and SMO
 
Microsoft TechEd Developers
November 5 - 9, 2007 - Barcelona, Spain
  Presented by Microsoft Corporation
Conference Sessions, presented by Bob Beauchemin:
- DAT307: Best Practices for Optimizing Procedural Code and Queries in SQL Server 2005 and Beyond
 Code Samples

- DAT308: Best Practices for Optimizing Service-Based Code in SQL Server 2005 and Beyond
 Code Samples

- DAT309: Best Practices for Optimizing SQLCLR in SQL Server 2005 and Beyond
 Code Samples

- DAT310: Best Practices for Optimizing Transactional Code in SQL Server 2005 and Beyond
 Code Samples

- DAT311: Best Practices for Optimizing XML Queries in SQL Server 2005 and Beyond
 Code Samples

Chalk-talks, presented by Bob Beauchemin:
- DAT04-IS: SQL CLR Best Practices Discussion and Examples using Lessons Learned from Customer Deployments
- DAT05-IS: Server Service Broker Architecture for Performance Discussion Using Lessons Learned from Customer Deployments
- DAT07-IS: To ODBC or To OLE DB?
- DAT08-IS: Using Powershell and SQL Server Management Objects (SMO) Together to Manage SQL Server
 
Microsoft Tech*Ed 2007 Hong Kong
August 28 - 30, 2007 - Hong Kong Convention and Exhibition Center
  Presented by Microsoft Corporation
Pre-conference Seminar, presented by Bob Beauchemin:
- PRE001: Optimizing and Best Practices for SQL Server 2005 Features - With A Look to the Future
Saturday, 25 August 2007, 10:00 - 17:00
 Code Samples

Conference Sessions, presented by Bob Beauchemin:
- DAT316: Microsoft SQL Server 2005 Security Best Practices
- DAT329: Microsoft SQL Server Always-On Technologies: Advanced Indexing Strategies
 Code Samples

- DAT382: SQL Server in 2007: Working with Vista and SP2
 Code Samples

- DAT314: Implementing Scale-Out Solutions with Microsoft SQL Server 2005
 Code Samples

- DAT326: Microsoft SQL Server 2005 Compact Edition in Action
 
DevConnections Workshops - 2007
15 June 2007 - Amsterdam RAI, Amsterdam, The Netherlands
DevConnections Europe
Workshop delivered by Bob Beauchemin:
- Optimising And Best Practices for all SQL Server 2005 Features
Friday, 15 June 2007
 Demo Scripts

 
Microsoft Tech*Ed US 2007
June 4 - 8, 2007 - Orlando, FL
Official Microsoft Tech*Ed US Site
  Presented by Microsoft Corporation

Pre-conference Seminar, presented by Bob Beauchemin and Kimberly L. Tripp:
- PRCN06: Leveraging SQL Server Always-On Technologies to Achieve High Availability and Scalability ì
Sunday, 3 June 2007, 10:00 - 18:00
 Demo Scripts

Conference Sessions, presented by Bob Beauchemin:
- DAT314: Implementing Scale-Out Solutions with Microsoft SQL Server 2005
 Demo Scripts

Chalk Talks, presented by Bob Beauchemin:
- DAT01-TLC: DDL Triggers, Event Notifications, and WMI in SQL Server 2005
 Demo Scripts

- DAT12-TLC: Using Microsoft Windows PowerShell and SMO Together
 Slides and Demo Scripts

Conference Sessions, presented by Kimberly L. Tripp:
- DAT327: Microsoft SQL Server 2005 Always-On Demo Fest
 Demo Scripts

- DAT328: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error
 Demo Scripts

- DAT329: SQL Server 2005: Advanced Indexing Strategies
 Demo Scripts

Chalk Talks, presented by Kimberly L. Tripp and Paul Randal:
- DAT02-TLC: Microsoft SQL Server 2005 VDLB Maintenance Best Practices Q&A
 
 
Microsoft Developer and ITPro Days
March 28-29, 2007 - Ghent Belgium
Bob Beauchemin
Conference Sessions:
- Improve database application performance using SQL Server Service Broker
 Demo Scripts

- SQL Query Plans In Depth - 80/20 tuning
 Demo Scripts

- ADO.NET vNext - The Entity Data Model, Object Services, and LINQ
 Demo Scripts

- SQL Server in 2007: Working with Vista and SQL Server SP2
 Demo Scripts

 
SQL Server Magazine Connections - Spring 2007
March 25-29 - Marriott Orlando World Center, Orlando, FL
SQL Server Magazine Connections
Presented by Penton Media, Inc. and SQL Server Magazine

Pre-conference Workshop:
- SQL Server Tips and Tricks to Better Performance Sunday, 25 March 2007
 Demo Scripts

 Updated Session Slides (in pdf form)

Conference Sessions delivered by Kimberly L. Tripp:
- SDB307: SDB308: Recovering from Isolated Disasters and Human Error
Tuesday, 27 March 2007
 Demo Scripts

- SDV:312: Follow the Rabbit: Interactive Q&A on Availability
Tuesday, 27 March 2007
Co-presented with Paul S. Randal, Microsoft Corporation

- SDB:309: Follow the Rabbit: Interactive Q&A on the SE (Storage Engine) and RE (Relational Engine)
Wednesday, 28 March 2007
Co-presented with Paul S. Randal, Microsoft Corporation

Post-Conference Workshop:
- Crucial Database Maintenance Techniques
Thursday, 29 March 2007
Co-presented with Paul S. Randal, Microsoft Corporation

 
Microsoft ITForum
November 13 - 17, 2006 - Barcelona, Spain
Official Microsoft ITForum Site
  Presented by Microsoft Corporation

Pre-conference Seminar, presented by Kimberly L. Tripp:
- PRE006: Achieving High Availability with SQL Server 2005 Always On Technologies
Monday, 13 November 2006, 12:00 - 19:00

 Demo Scripts

Conference Sessions delivered by Bob Beauchemin:
- SQL Server 2005: Security - Best practices for accounts, keys, and data encryption
 Code Samples

- SQL Server 2005: Troubleshooting the Service Broker
 Code Samples

- SQL Server 2005: Learn the XML you need to manage your database
 Code Samples

Conference Sessions delivered and/or co-presented by Kimberly L. Tripp:
- DAT202: Upgrade with Ease Features, Tools and Best Practices for Upgrading to SQL Server 2005
Tuesday, 14 November 2006
 Demo Scripts

- DAT203: Best Practices in Building Robust, Recoverable and Reliable Systems
Wednesday, 15 November 2006
 Demo Scripts

- DAT305: Database Mirroring Best Practices and Performance Considerations
Wednesday, 15 November 2006
* 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.

- DAT401: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error
Thursday, 16 November 2006
 Demo Scripts

- DAT402: SQL Server 2005: Advanced Indexing Strategies
Friday, 17 November 2006
 Demo Scripts

- DAT303: End-to-End How a Query Executes presented by Paul S. Randal (I played "demo monkey" for Paul)
Friday, 17 November 2006
 Demo Scripts

Chalk Talks by Paul S. Randal (I played "demo monkey" for Paul):
- DATCT02: DBCC CHECKDB: Magic, Monsters, and Myths
Thursday, 16 November 2006
 Demo Scripts

- DATCT06: Database Maintenance in SQL Server 2005
Thursday, 16 November 2006
* No demo scripts from this session but look forward to more coming from Paul and I on this subject - maybe even a pre or post conference workshop next year!

 
SQL Server Magazine Connections - Fall 2006
November 6-10 - Mandalay Bay Resort and Casino, Las Vegas, NV
SQL Server Magazine Connections
Presented by Penton Media, Inc. and SQL Server Magazine
Conference Sessions delivered by Kimberly L. Tripp:
- SDB307: Building Blocks for a Reliable VLDB
Thursday, 9 November 2006
 Demo Scripts

- SDB306: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error
Thursday, 9 November 2006
 Demo Scripts

- DAT404: Table Partitioning Best Practices
Thursday, 9 November 2006
* No demo scripts from this session but LOTS of online resources. Check out Part 7 from the MSDN Webcast Series AND the full list of blog resources for that session.

- DAT403: Database Mirroring Best Practices
Thursday, 9 November 2006
* 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.

Post-Conference Workshop:
- SQL Server Tips and Tricks to Better Performance
 Demo Scripts

 
Microsoft TechEd Developers
November 6 - 10, 2006 - Barcelona, Spain
Official Microsoft Tech*Ed Developers Site
  Presented by Microsoft Corporation

Pre-conference Seminar, presented by Kimberly L. Tripp and Brian A. Randell:
- PRE005: Making the Most of SQL Server 2005: Developing World Class Database Applications
Monday, 6 November 2006, 12:00 - 19:00

 Demo Scripts

 Presentation with Hidden Slides

Conference Sessions delivered by Bob Beauchemin:
- SQL401: SQL Server 2005 Error Handling: T-SQL, SQLCLR and Clients
 Code Samples

- SQL402: Implementing the Service-Oriented Database Architecture with SQL Server 2005
 Code Samples

- SQL301: Coding SQL Server 2005 Plan Guides and Plan Forcing
 Code Samples

- SQL403: Understanding Interactions of Transactions, Batches, Nested Procedures, MARS, and SQLCLR in SQL Server 2005
 Code Samples

- SQL404: SQL Server 2005 Cache Sync/Query Notifications in Depth
 Code Samples

- ChalkTalk: SMO and Powershell
 Code Samples

Conference Sessions delivered by Kimberly L. Tripp:
- DAT408 & DAT409: SQL Server 2005: Advanced Indexing Strategies Part I and Part II
Tuesday, 7 November 2006, 14:15 - 15:30 (Part I) and 16:00 - 17:15 (Part II)
 Demo Scripts

- DAT410: SQL Server 2005: Optimizing Procedural Code
Tuesday, 7 November 2006, 17:45 - 19:00
 Demo Scripts

 
SQLskills Immersion Event - Cape Town, South Africa
October 30-31 to Nov 1, 2006 - Microsoft Offices in Cape Town, South Africa
  Presented by Microsoft Corporation

 Code Samples and Demo Scripts

 
 
SQLskills Immersion Event - Johannesburg, South Africa
October 26, 2006 - Indaba Hotel/Conference Center in Johannesburg, South Africa
  Presented by Microsoft Corporation

 Code Samples and Demo Scripts

 
 
Microsoft Tech*Ed South Africa 2006
October 23-25, 2006 - Sun City, South Africa
Official Microsoft Tech*Ed South Africa Site
  Presented by Microsoft Corporation

Conference Sessions, presented by Kimberly L. Tripp:
- DAT203: SQL Server Always On Technologies: Best Practices in Building Robust, Recoverable and Reliable Systems
Monday, 23 October 2006, 11:00 - 12:00, Session Room 3
 Demo Scripts

- DAT301: SQL Server Always On Technologies: Database Mirroring Best Practices and Performance Considerations
Monday, 23 October 2006, 16:15 - 17:15, Session Room 2
* 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.

- DAT402: SQL Server 2005: Optimizing Procedural Code
Tuesday, 24 October 2006, 09:15 - 10:15, Session Room 4
 Demo Scripts

- DAT306: SQLCMD Tips and Tricks
Tuesday, 24 October 2006, 11:45 - 12:45, Session Room 5
 Demo Scripts

- DAT401: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error
Tuesday, 24 October 2006, 14:30 - 15:30, Session Room 1
 Demo Scripts

- DAT403 & DAT404: SQL Server 2005: Advanced Indexing Strategies Part I and Part II
Wednesday, 25 October 2006, 9:00 - 11:15, Session Room 3
 Demo Scripts

 
 
SQLskills Immersion Event - New York Cityì
October 16 - 20, 2006 in New York City, NY
Learn more about each of our individually planned and focused Immersion Eventsì
 Code Samples and Demo Scripts

 Gert Draper's Data Dude Presentation

 
 
Microsoft Tech*Ed 2006 Hong Kong
September 25 - 27, 2006 - Hong Kong Convention and Exhibition Center
  Presented by Microsoft Corporation
Bob Beauchemin
Pre-conference Session:
- A Day of SQL Server 2005 for Developers
 Code Samples

 Presentation

Conference Sessions:
- SQL Querying Tips & Techniques
 Code Samples

- Next Generation Data Access in .NET: ADO.NET vNext
- Methodology for Upgrading to SQL Server 2005
- SQL Server 2005: Scaling for All
 Code Samples

- SQL Server Error Handling In T-SQL and In SqlClient
 Code Samples

- XQuery Deep Dive: How to Write and Optimize Your XQuery
 Code Samples

 
SQLskills Partner Events in Reading, UKì
August 8 - 11, 2006 - Reading, UK
  Partner events with UK SQL Server User Group: SQLServerFAQ.com

Master Classes presented by SQLskills
- SQL Server Tuning for High Performance
August 8-10, 2006, Presented by Kimberly L. Tripp

 Demo Scripts

- Day of Scaling Out with SQL Server 2005
August 11, 2006, Presented by Bob Beauchemin

 Demo Scripts

 
 
SQLskills Immersion Event - Chicagoland Areaì
July 31 - August 4, 2006 in Downers Grove, IL
Learn more about each of our individually planned and focused Immersion Eventsì

- SQL Server Tuning for High Performance
July 31 - August 3, 2006, Presented by Kimberly L. Tripp

 Demo Scripts

 
- Programming Scale-Out Applications with SQL Server 2005
July 31 - August 3, 2006, Presented by Bob Beauchemin

 Demo Scripts

 
 
SQLskills Partner Events
June 26 - 30, 2006 - Switzerland
  Partner events with Trivadis: Trivadis AG

Master Classes presented by Kimberly L. Tripp
- SQL Server Indexing for Performanceì
Zurich-Glattbrugg, Switzerland
Monday-Tuesday, 26-27 June 2006

 Demo Scripts

- SQL Server 2005: Designing for Performance and Availabilityì
Geneva, Switzerland
Thursday-Friday, 29-30 June 2006

 Demo Scripts

 
 
Microsoft Tech*Ed US 2006
June 11 - 16, 2006 - Boston, MA
Official Microsoft Tech*Ed US Site
  Presented by Microsoft Corporation

Pre-conference Seminar, presented by Kimberly L. Tripp and Brian A. Randell:
- PRE001: Making the Most of SQL Server 2005: Developing World Class Database Applications ì
Sunday, 11 June 2006, 10:00 - 18:00

 Demo Scripts

Conference Sessions, presented by Bob Beauchemin:
- DAT424: SQL Server Error Handling: T-SQL, SQLCLR and Clients
Wednesday, 14 June 2006, 14:00 - 15:15

 Demo Scripts

Chalk Talks, presented by Bob Beauchemin:
- DATTLC02: SQL Server 2005: DDL triggers, Event Notifications, and WMI in SQL Server 2005
Monday, 12 June 2006, 10:45 - 12:00, DAT Theater 1
- DATTLC30: Controlling the New SQL Server 2005 Features: Setup, Security and Monitoring
Tuesday, 13 June 2006, 08:30 - 09:45, DAT Theater 2
- DATTLC17: Plan Guides and Plan Forcing in SQL Server 2005
Thursday, 15 June 2006, 09:45 - 11:00, DAT Theater 1

Conference Sessions, presented by Kimberly L. Tripp:
- DAT325: SQL Server Always On Technologies: Best Practices in Building Robust, Recoverable and Reliable Systems
Tuesday, 13 June 2006, 10:15 - 11:30, Room 52AB
 Demo Scripts

- DAT413: SQL Server Always On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error
Wednesday, 14 June 2006, 14:00 - 15:15, Room 151AB
 Demo Scripts

- DAT437: SQL Server 2005: Advanced Indexing Strategies
Thursday, 15 June 2006, 16:30 - 17:45, Room 253ABC

 Demo Scripts

Chalk Talks, presented by Kimberly L. Tripp:
- DATTLC05: SQL Server 2005: Leveraging the Availability and Scalability Features of the Enterprise Edition
Monday, 12 June 2006, 17:00 - 18:15, DAT Theater 1
- DATTLC43: SQL Server 2005: SQLCMD Tips and Tricks
Thursday, 15 June 2006, 14:45 - 16:00, DAT Theater 2
 
 
SQL Server Magazine Connections - Spring 2006
April 2-6, Hyatt Grand Cypress Resort and Spa, Orlando, FL
SQL Server Magazine Connections
Presented by Penton Media, Inc. and SQL Server Magazine
Conference Sessions, presented by Kimberly L. Tripp:
- SDB303: SQL Server Isolation: Locking or Versioning?
4 April 2006, 11:15 - 12:30
 Demo Scripts

- SDB302: SQL Server Indexing: Finding the Right Balance
4 April 2006, 2:00 - 3:15
 Demo Scripts

- SDB301: SQL Server Availability Strategies: The Building Blocks for a Reliable VLDB
5 April 2006, 11:15 - 12:30
Post-Conference Workshop, presented by Kimberly L. Tripp:
- SPS301: SQL Server Availability Strategies: Building a Reliable VLDB in Depth
6 November 2006, 9:00 to 16:00
 Demo Scripts

 
SQLskills SQL Immersion Event
April 3, 2006 - Reykjavik, Iceland
Presented by Bob Beauchemin
  Brought to you by
Demo Scripts
 
SQLskills SQL Immersion Event
March 30 - 31, 2006 - Reykjavik, Iceland
Presented by Bob Beauchemin
  Brought to you by
Demo Scripts
 
UK SQL Server Community Event
March 16, 2006 - Edinburgh, Scotland
  Brought to you by UK SQL Server Community FAQ
Full-day Seminar, presented by Kimberly L. Tripp
- SQL Server 2005: New Features in Availability, 09:30-17:00
 Demo Scripts

 
Edinburgh SQL Server User Group Meeting
March 15, 2006 - Edinburgh, Scotland
  First meeting - EVER - sponsored by UK SQL Server Community FAQ
User Group Session #2, presented by Kimberly L. Tripp
- SQL Server: Tips and Tricks in Tuning, 19:30-21:00
 Demo Scripts

 
UK SQL Server Community Event
March 14, 2006 - Reading, UK
  Brought to you by UK SQL Server Community FAQ
Full-day Seminar, presented by Kimberly L. Tripp
- SQL Server: Indexes from Every Angle, 09:30-17:00
 Demo Scripts

 
SQLskills SQL Immersion Event
March 9 - 10, 2006 - Amsterdam, Netherlands
Presented by Bob Beauchemin
  Brought to you by Class-A
Demo Scripts Day 1
Demo Scripts Day 2

 
Microsoft DevDays 2006
March 7 - 8, 2006 - Amsterdam, Netherlands
Bob Beauchemin
Conference Sessions:
- ADO.NET 2.0: Base Classes, Factories, Schemas and Tracing
 Demo Scripts

- SQL Server 2005-Enabled Features in Data Access
 Demo Scripts

- SQL Server 2005 Error Handling: T-SQL, SQLCLR and Clients
 Demo Scripts

- SQL Server 2005 In-Database access - SQLCLR Techniques and Best Practices in Detail
 Demo Scripts

 
SQLskills SQL Immersion Event
January 24 - 27, 2006 - Reykjavik, Iceland
Presented by Kimberly L. Tripp
  Brought to you by
Demo Scripts
Course Materials
 
SQLskills SQL Immersion Event
December 5 - 6, 2005 - Reykjavik, Iceland
Presented by Bob Beauchemin
  Brought to you by
Demo Scripts Day 1
Demo Scripts Day 2

 
SQLskills SQL Immersion Event
November 21 - 23, 2005 - Zurich, Switzerland
Presented by Kimberly L. Tripp
  Brought to you by Trivadis AG
Demo Scripts

 
SQLskills SQL Immersion Event
November 21 - 24, 2005 - Amsterdam, Netherlands
Presented by Bob Beauchemin
  Brought to you by Class-A
Demo Scripts

 
Microsoft ITForum
November 14 - 18, 2005 - Barcelona, Spain
http://www.microsoft.com/europe/msitforum/
Kimberly L. Tripp
Pre-Conference Seminar:
- Designing for Performance with SQL Server 2005
14 November 2005, 13:00 - 19:00
 Demo Scripts

Conference Sessions:
- SQL Server 2005: What's the Server Doing Now? (DAT303)
15 November 2005, 16:00 - 17:15
 Demo Scripts

- SQL Server 2005 Security for System Administrators (DAT311)
15 November 2005, 17:45 - 19:00
 Demo Scripts

- SQL Server 2005 Indexing: It Really Does Help! (DAT307)
16 November 2005, 09:45 - 11:00
 Demo Scripts

- SQL Server 2005: Fixing Fragmentation from Disk to Log to Indexes (DAT309)
16 November 2005, 15:30 - 16:45
 Demo Scripts

- Your High-Availability Options with SQL Server 2005 (CHT036)
17 November 2005, 08:15 - 09:30

- Managing VLDB Databases in SQL Server 2005: Availability and Recovery Strategies (DAT315)
17 November 2005, 10:00 - 11:15
 Demo Scripts

- Women in Technology (Lunch Forum) (WIT001)
17 November 2005, 12:45 - 14:15

Bob Beauchemin
Conference Sessions:
- SQL Server 2005: Understanding the Operational Impact of Service Broker (DAT301)
17 November 2005, 15:45 - 17:00
 Demo Scripts

- Architecting the Right Solution - Transact-SQL or SQLCLR : What DBA’s Should Know (DAT302)
15 November 2005, 14:15 - 15:30
 Demo Scripts

- SQL Server 2005: Transact-SQL is Not Dead! (DAT304)
16 November 2005, 11:15 - 12:30
 Demo Scripts

- SQL Server 2005: Architecting the Right Solution with New Type Choices (DAT310)
16 November 2005, 17:15 - 18:30
 Demo Scripts

 
SQL Server Magazine Connections - Fall 2005
November 7-10 - Mandalay Bay Resort and Casino, Las Vegas, NV
SQL Server Magazine Connections
Presented by Penton Media, Inc. and SQL Server Magazine
Kimberly L. Tripp
Pre-Conference Workshop:
- Understanding and Effectively Using SQL Server 2005's New Tools
7 November 2005, 9:00 to 16:00
 Demo Scripts

Conference Sessions:
- SQL Server 2005 Partitioning
9 November 2005, 14:00 - 15:15
 Presentation Handout
 Demo Scripts

- SQL Server Index Creation Best Practices
10 November 2005, 9:30 - 10:45
 Presentation Handout
 Demo Scripts

- SQL Server Index Maintenance Best Practices
10 November 2005, 11:15 - 12:30
 Presentation Handout
 Demo Scripts

- SQL Server 2005: Optimizing Stored Procedure Performance
10 November 2005, 13:30 - 14:30
 Presentation Handout
 Demo Scripts

 
Microsoft Tech*Ed 2005 Hong Kong
October 3 - 6, 2005 - Hong Kong Convention and Exhibition Center
  Presented by Microsoft Corporation
Bob Beauchemin
Pre-conference Session:
- Get Ready for SQL Server 2005, what every developer should know
 Code Samples

Conference Sessions:
- SQLCLR vs. T-SQL: Best Practices for Development in the Database
 Code Samples

- Service-Oriented Data Architecture (SODA) How SQL Server 2005 Fits into the Service-Oriented Architecture (SOA) World
 Code Samples

- Integrated Innovation: Using ADO.NET 2.0 with SQL Server 2005
 Code Samples

- Developing Secure Applications with SQL Server 2005
 Code Samples

- Together at Last: Combining XML and Relational Data in SQL Server 2005
 Code Samples

- Adding Alerting Functionality to Database Applications with SQL Server Notification Services
 Code Samples

- Introducing SSMA:Migrating from Oracle to SQL Server with 80% Less Effort
 
2005 PASS Community Summit
September 27-30, 2005 - Grapevine, Texas
2005 PASS Community Summit
  Presented by PASS, the Professional Association for SQL Server
Kimberly L. Tripp
  Spotlight Presenter 
By Invitation Only, Spotlight Presenters deliver a pre- or post-conference session as well as a longer (90 minutes) presentations at the conference!
 
Pre-conference Session:
- The Next Generation DBA, Critical New SQL Server 2005 Features YOU Need to Learn!
Tuesday, 27 September 2005, 09:00am - 05:00pm
 Demo Scripts

Conference Sessions:
- Indexing Best Practices in SQL Server 200x - A Fast-paced Collection of Tips and Tricks for BOTH SQL Server 2000 and SQL Server 2005
Wednesday, 28 September 2005
 Demo Scripts

   
Bob Beauchemin
  Spotlight Presenter 
By Invitation Only, Spotlight Presenters deliver a pre- or post-conference session as well as a longer (90 minutes) presentations at the conference!
 
Pre-conference Sessions:
- Part 1: Essential SQL Server 2005: New Features in SQL Server 2005 and .NET for Developers In-Depth
Monday, 26 September 2005, 08:30am - 04:30pm
 CodeSamples

- Part 2: Essential SQL Server 2005: New Features in SQL Server 2005 and .NET for Developers In-Depth
Tuesday, 27 September 2005, 08:30am - 04:30pm
 CodeSamples

Conference Session:
- SQL Server 2005 XQuery Primer
Thursday, 29 September 2005, 10:15 - 11:45
 CodeSamples

 
Microsoft Professional Developers Conference 2005
September 11 - 16, 2005 - Los Angeles, CA
Official 2005 PDC Site
  Presented by Microsoft Corporation
  Details to be posted shortly!
 
Microsoft Tech*Ed Europe 2005
July 4 - 8, 2005 - Amsterdam, the Netherlands
Official Microsoft Tech*Ed Europe Site
  Presented by Microsoft Corporation

Pre-conference Seminar:
- SQL Server 2005 Management Tools: Effectively Using and Understanding the new SQL Server 2005 Toolsetì
Monday, 4 July 2005, 10:00 - 18:00
 Scripts for the Self-paced Labs
 Lab Manual for the Self-paced Labs

Conference Sessions:
- SQL Server 2005: Bridging the Gap between Development and Administration ì
Tuesday, July 5, 16:30 - 17:45
 Demo Scripts

- SQL Server 2005 Security for System Administratorsì
Wednesday, July 6, 10:15 - 11:30
 Demo Scripts

- Understanding Index Usage and Indexing Best Practices in SQL Server 2005 ì
Wednesday, July 6, 14:45 - 16:00
 Demo Scripts

- Index Defragmentation Best Practices in SQL Server 2005ì
Wednesday, July 6, 16:30 - 17:45
 Demo Scripts

- VLDB Availability and Recovery Strategies for SQL Server 2005 ì
Thursday, July 7, 10:15 - 11:30
 Demo Scripts

- Understanding Transaction Isolation in SQL Server 2000 and 2005 ì
Thursday, July 7, 14:45 - 16:00
 Demo Scripts

- Achieving High Availability with SQL Server 2005ì
Thursday, July 7, 18:15 - 19:30
 Demo Scripts

- SQL Server 2005 Security for Database Developersì
Friday, July 8, 12:00 - 13:15
 Demo Scripts

 
 
Microsoft Tech*Ed US 2005
June 5 - 10, 2005 - Orlando, Florida
Official Microsoft Tech*Ed US Site
  Presented by Microsoft Corporation

Pre-conference Seminar:
- Taming the Tools: Effectively Using and Understanding SQL Server 2005 Tools ì
Sunday, 5 June 2005, 13:00 - 18:00
 Demo Scripts

Conference Sessions:
- Understanding Index Usage and Indexing Best Practices in SQL Server 2005 ì
Monday, June 6, 17:00 - 18:15
Room: N 210 E
 Demo Scripts

- RD Community Booth Duty
Tuesday, June 7, 10:00 - 12:00

- GrokTalk - On Stored Procedure Recompilation
Tuesday, June 7, 15:55 - 16:05
Find out more ì
 Demo Scripts

- VLDB Availability and Recovery Strategies for SQL Server 2005 ì
Wednesday, June 8, 10:15 - 11:30
Room: N 230
 Demo Scripts

- Women In Technology Luncheon
Wednesday, June 8, 11:30 - 13:30
Find out more ì

- Understanding Transaction Isolation in SQL Server 2000 and 2005 ì
Wednesday, June 8, 17:30 - 18:45
Room: N 320 D/H
 Demo Scripts

- SQL Server 2005: Bridging the Gap between Development and Administration ì
Thursday, June 9, 10:15 - 11:30
Room: S 220 D
 Demo Scripts

 
 
2005 PASS European Conference
May 11 - 13, 2005 - Munich, Germany
2005 PASS European Conference
  Presented by PASS, the Professional Association for SQL Server
  Spotlight Presenter 
By Invitation Only, Spotlight Presenters deliver a pre- or post-conference session as well as a longer (90 minutes) presentations at the conference!
 
Pre-conference Session:
- The Next Generation DBA, Critical New SQL Server 2005 Features YOU Need to Learn!ì
Wednesday, 11 May 2005, 09:00 - 17:00
 Demo Scripts

Conference Sessions:
- Indexing Best Practices in SQL Server 2000: From Creation to Performance to Maintenanceì
Thursday, 12 May 2005, 15:00 - 16:15
 Demo Scripts

- Changes to Indexing in SQL Server 2005: From Creation to Performance to Maintenance to Monitoringì
Thursday, 12 May 2005, 16:45 - 18:00
 Demo Scripts

 
Master Class on Achieving High Availability with SQL Server 2005
May 2 - 4, 2005 - Copenhagen, Denmark
Presented by
For future Miracle events: here.
 Demo Scripts

 
 
Microsoft Professional Developers Summit 2005
April 25 - 27, 2005 - Istanbul, Turkey
http://www.microsoft.com/middleeast/egypt/english/events/MDC/
Conference Sessions:
- SQL Server 2005: Bridging the Gap between Development and Administrationì
Tuesday, 26 April 2005, 10:20 - 11:20
- SQL Server 2005: New Features in Performance, Manageability and Recovery, Part Iì
Tuesday, 26 April 2005, 15:20 - 16:20
 Demo Scripts

- SQL Server 2005: New Features in Performance, Manageability and Recovery, Part IIì
Tuesday, 26 April 2005, 16:40 - 17:40
 Demo Scripts

- SQL Server Indexing Best Practicesì
Wednesday, 27 April 2005, 9:00 - 10:00
 Demo Scripts

- SQL Server 2005: Indexing New Featuresì
Wednesday, 27 April 2005, 10:20 - 11:20
 Demo Scripts

- SQL Server Partitioning Strategies (for both SQL Server 2000 and SQL Server 2005)ì
Wednesday, 27 April 2005, 11:40 - 12:40