 |
|
 |
My Account
|
|
| Home |
|
| Events |
| Current Events |
| Past Events |
| SQL Immersion Events |
| Event Log |
|
| Services |
| Mentoring |
| Custom Courses |
|
| Resources |
| Articles |
| Blogs |
| Books |
| Event Resources |
| Knowledge Base Articles |
| Q & A |
| SQL Scripts |
| Useful Links |
| Whitepapers |
|
| Partners |
|
| Communications |
|
| Contact Us |
|
 |
|
| 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 
| |
| 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
| |
| 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
| ||
| 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 |
|