SQLskills
SQL Immersion Events
Upcoming Events
Kimbery Tripps SQL Immersion Events
SQL Server Training
Paul Randal
Paul Randall
disaster recovery
Immerse Yourself In SQL Server
Upcoming Events | Past Events | Event Log
2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | Pre-2003

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)

 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 sessions during 2008. These databases are all from SQL Server 2005. For instructions, see this blog post for details. Unzip and restore (possibly, WITH MOVE) to use.
 Sample Corrupt Databases (36MB zip/~400MB restored)

 
SQL Connections, Spring 2009
March 22 - 26, 2008 - Orlando, USA
Pre-conference Session (March 21) (Bob):
- A Day of SQL Server 2008 Spatial Data and Location-Aware Applications
 Demo Scripts

Pre-conference Session (March 22) (Paul & Kimberly):
- SQL Server 2005/2008 Indexes from Every Angle - Internals, Statistics and Fragmentation
 Demo Scripts (~5MB)

Post-conference Session (March 26) (Paul & Kimberly):
- SQL Server 2005/2008 Indexes from Every Angle - Are Your Indexing Strategies Working?
 Demo Scripts (~5MB)

Conference Sessions:
- SDV302: Programming Filestreams in SQL Server 2008 (Bob)
 Demo Scripts

- SDB304: Essential Database Maintenance (Paul & Kimberly)
 Demo Scripts (we didn't do any, but these scripts are applicable)

- SDV308: Indexing for Performance (Kimberly)
 Demo Scripts

- SDB310: Corruption Survival Techniques (Paul)
 Demo scripts (see this blog post for details)

- SDV314: Practical SQL Server Security for Architects and Developers (Bob)
 Demo Scripts

- SDB316: Scripting SQL Server 2008 Policies and Data Collection with PowerShell and SMO (Bob)
 Demo Scripts

- SDV320: SQL Server 2008 Sparse Columns and Filtered Indexes (Kimberly)
 Demo Scripts (and the big database is here (~54MB)

- SDB322: Follow the Rabbit: Interactive Q&A on Database Maintenance (Paul & Kimberly)
 
Privacy Policy.
All Rights Reserved.
©2007 SYSolutions, Inc.
sqlskills.com
Events in Seattle Washington