 |
|
|
|
||
 |
|
|
| 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 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 |
|
| 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 |
|
|
||
| ||
| ||
|
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com |
|