 |
|
|
|
||
 |
|
|
| Home |
|
|
| Remote DBA Service |
|
|
| Consulting and Performance |
|
|
| Server Health Checks |
|
|
| Training |
|
|
| Resources |
|
|
| Calendar |
|
|
| What our Customers say |
|
|
| What our Students say |
|
|
| About SQLskills.com |
|
| Upcoming Events | Past Events | |
| |
| 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | Pre-2004 | |
| |
|
Webcasts |
|
|
The webcasts page has links to Kimberly's 10-part MSDN series A Primer to Proper SQL Server Development and her 11-part TechNet series SQL Server 2005 for the IT Professional. It also has links to other recorded webcasts that are available. |
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. |
2000 Credit Sample Database (48MB zip/155MB backup/700MB restore) |
|
|
2008 Credit Sample Database (52MB zip/53MB compressed backup/700MB restore) |
|
|
2008 Sales Sample Database (18MB zip/196MB backup/240MB restore) |
|
 |
|
Sample Corrupt Databases |
|
|
|
This zip file contains the six common corrupt databases that Paul uses in Corruption Survival Techniques, DBCC CHECKDB, and disaster recovery conference sessions, and in most classes with corruption recovery demos. These databases are all from SQL Server 2005. For instructions, see
this blog post for details. Unzip and
restore (possibly, WITH MOVE) to use.
All the databases should restore and show corruptions on SQL Server 2008 and 2008 R2 too - except DemoFatalCorruption1 and DemoFatalCorruption2. To experiment with fatal corruptions on SQL Server 2008 or 2008 R2, use the two databases in the Sample 2008 Fatal Corruption Databases or Sample 2008 R2 Fatal Corruption Databases zip below. |
|
Sample Corrupt Databases (36MB zip/~400MB restored)
Sample 2008 Fatal Corruption Databases (232KB zip/~3MB restored)
Sample 2008 R2 Fatal Corruption Databases (260KB zip/~3MB restored)
|
|
|
|
|
|
|
|
| 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 |
|
|
|
| |
| |
|
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com |
|