 |
|
|
|
||
 |
|
|
| 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)
|
||
|
|
||
|
|
||
| 2008 PASS Community Summit | ||
| November 17-21, 2008 - Seattle, Washington | ||
|
2008 PASS Community Summit | |
| Presented by PASS, the Professional Association for SQL Server | ||
| Bob Beauchemin | Spotlight Presenter 
| |
| Pre-conference Session (November 18): | ||
| - |
SQL Server 2008 Features For Developers In-Depth |
|
|
CodeSamples |
||
| Spotlight Session: | ||
| - |
Using Spatial Data in SQL and in Clients |
|
|
CodeSamples |
||
| Paul S. Randal & Kimberly L. Tripp |
Spotlight Presenters
| |
| Pre-conference Session (November 18): | ||
| - |
Database Maintenance: From Planning to Practice to Post-Mortem |
|
|
CodeSamples
|
||
| Spotlight Session (Paul): | ||
| - |
Corruption Survival Techniques |
|
|
Code Samples
(see this blog post for details)
|
||
| Conference Session (Kimberly - stepped in at the last minute!): | ||
| - |
Index Internals and Usage |
|
|
CodeSamples
|
||
|
|
||
| SQL Connections, Fall 2008 | ||
| November 9-14, 2008 Las Vegas, USA | ||
| Pre-conference Session (November 9) (Paul & Kimberly): | ||
| - |
Database Best Practices for the Involuntary DBA |
|
|
Demo Scripts |
||
| Pre-conference Session (November 10) (Paul & Kimberly): | ||
| - |
Relational Data Warehousing: Leveraging Key Features of SQL Server 2005/2008 |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - |
SDV303: Index Internals and Usage (Kimberly) |
|
|
Demo Scripts |
||
| - |
SDB405: Essential Database Maintenance (Paul & Kimberly) |
|
|
Demo Scripts |
||
| - |
SDB412: DBCC CHECKDB: The Definitive Guide (Paul) |
|
|
Code Samples
(see this blog post for details)
|
||
| - |
SDB313: Follow the Rabbit: Interactive Q&A on Database Maintenance (Paul & Kimberly) |
|
|
||
| Microsoft TechEd EMEA Developers | ||
| November 10 - 14, 2008 - Barcelona, Spain | ||
| Presented by Microsoft Corporation | ||
| Conference Sessions, presented by Bob Beauchemin: | ||
| - |
DAT302: Programming Filestreams in SQL Server 2008 |
|
|
Code Samples |
||
| - |
DAT303: SQLCLR Enhancements in SQL Server 2008 |
|
|
Code Samples |
||
| - |
DAT304: Supporting a Sparse Property Design in SQL Server 2008 |
|
|
Code Samples |
||
| - |
DAT305: Performance Enhancements in SQL Server 2008 |
|
|
Code Samples |
||
| - |
DAT314: Programming PowerShell in SQL Server 2008 |
|
|
Code Samples |
||
|
||
| Microsoft TechEd EMEA IT Professionals | ||
| November 3 - 7, 2008 - Barcelona, Spain | ||
| Presented by Microsoft Corporation | ||
| Instructor-Led Labs, presented by Paul S. Randal: | ||
| - |
DAT02-ILL: Combining Database Mirroring and Transactional Replication in SQL Server 2008 |
|
|
Code Samples |
||
| - |
DAT04-ILL: Corruption Recovery Techniques |
|
|
Code Samples
(see this blog post for details)
|
||
| Instructor-Led Labs, presented by Kimberly L. Tripp: | ||
| - |
DAT01-ILL: SQL Server Worst Practices Fixed |
|
| - |
DAT03-ILL: Microsoft SQL Server 2008: Analyze and Tune your Workload |
|
| Conference Sessions, presented by Kimberly L. Tripp: | ||
| - |
DAT305: Microsoft SQL Server 200x: Are Your Indexing Strategies Working? |
|
|
Demo Scripts |
||
| - |
DAT308: SQL Server Worst Practices Exposed, Part I |
|
| - |
DAT309: SQL Server Worst Practices Exposed, Part II |
|
| Conference Sessions, presented by Paul S. Randal: | ||
| - |
DAT307: Surviving Database Corruption - From Detection to Resolution |
|
|
Code Samples
(see this blog post for details)
|
||
| - |
DAT312: SQL Server 2008 Replication: Providing High-Availability Using Database Mirroring |
|
|
Code Samples |
||
| Conference Sessions, presented by Bob Beauchemin: | ||
| - |
DAT313: Performance Benefits of new SQL Server 2008 T-SQL features |
|
|
Code Samples |
||
| - |
DAT08-IS: Diagnosing Errors and Performance Problems using SQL Server Extended Events |
|
|
Code Samples |
||
|
||
| SQLKnowHow/SQLskills Seminars | ||
| September 8-9, 2008 - Edinburgh, Scotland | ||
| Indexing for Performance, presented by Kimberly L. Tripp: | ||
|
Demo Scripts |
||
|
||
| Microsoft TechEd ITPro US 2008 | ||
| June 9 - 13, 2008 - Orlando, FL |
||
|
Official Microsoft Tech*Ed US ITPro Site | |
| Presented by Microsoft Corporation | ||
| Conference Sessions delivered by Kimberly L. Tripp: | ||
| - |
DAT354: Are Your Indexing Strategies Working? Tuesday, 10 June 2008 |
|
|
Demo Scripts |
||
| Conference Sessions delivered by Paul S. Randal: | ||
| - |
DAT375: Corruption Survival Techniques Wednesday, 11 June 2008 |
|
|
Code Samples
(see this blog post for details)
|
||
|
|
||
| Microsoft TechEd Developers US 2008 | ||
| June 2 - 6, 2008 - Orlando, FL |
||
|
Official Microsoft Tech*Ed US Developers Site | |
| Presented by Microsoft Corporation | ||
| Pre-conference Workshop delivered by Bob Beauchemin: | ||
| - |
PRC14: SQL Server 2008 New Features Overview for Developers
Monday, 2 June 2008 |
|
|
Demo Scripts |
||
| Conference Sessions delivered by Bob Beauchemin: | ||
| - |
DAT404: Practical SQL Server Security For Developers and Architects Tuesday, 3 June 2008 |
|
|
Demo Scripts |
||
| - |
DAT401: End-to-End Tracing with SQL Server 2008 and ADO.NET Wednesday, 4 June 2008 |
|
|
Demo Scripts |
||
| - |
DAT308: PowerShell in SQL Server 2008 Wednesday, 4 June 2008 |
|
|
Demo Scripts |
||
|
||
| 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 |
||
|
||
| ||
| ||
|
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com |
|