 |
|
|
|
||
 |
|
|
| Home |
|
|
| Services |
| Audit: availability/DR |
| Audit: maintenance/ops |
| Consulting |
| Design |
| Training/Custom Courses |
|
|
| Past Customers |
|
|
| Contact Us |
|
|
| Events |
| Upcoming Events |
| Example DBs & Scripts |
| SQL Immersion Events |
|
|
| Partners |
|
|
| Resources |
| Articles |
| Blogs |
| Books |
| Event Resources |
| Knowledge Base Articles |
| Interviews |
| Whitepapers |
|
|
 |
|
| Upcoming Events | Past Events | |
| |
| 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. |
Credit Sample Database (48MB zip/155MB backup/700MB restore) |
|
|
2008 Credit Sample Database (52MB zip/53MB compressed backup/700MB restore) |
|
|
Sales Sample Database (18MB zip/196MB backup/240MB restore) |
|
 |
|
Sample Corrupt Databases |
|
|
|
This zip file contains the six common corrupt databases that Paul used in the Corruption Survival Techniques and DBCC CHECKDB
conference sessions during 2008, and in all 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 too - except DemoFatalCorruption1 and DemoFatalCorruption2. To experiment with fatal corruptions on SQL Server 2008, use the two databases in the Sample 2008 Fatal Corruption Databases zip below. |
|
Sample Corrupt Databases (36MB zip/~400MB restored)
Sample 2008 Fatal Corruption Databases (232KB zip/~3MB restored)
|
|
|
|
|
|
|
|
| DevTeach | |
| March 8-12, 2010 - Toronto, Canada | |
|
Many thanks to the Toronto SQL Server User Group for having me present during the week! |
|
| Pre-conference Workshop (March 8) (Kimberly): | |
| - |
Indexing for Performance |
|
Demo Scripts |
|
| Post-conference Session (March 12) (Kimberly): | |
| - |
Developers Can't Ignore SQL Server Database Maintenance! |
|
Demo scripts coming soon |
|
| Conference Sessions: | |
| - |
SQL345: Optimizing Procedural Code (Kimberly) |
|
Demo Scripts |
|
| - |
SQL355: Tips and Tricks for Proper SQL Server Table Design (Kimberly) |
|
Demo scripts coming soon |
|
|
|
|
| |
| |
|
Privacy Policy. All Rights Reserved. Copyright 2010 SQLskills.com |
|