SQLskills.com | Immerse Yourself In SQL Server


	Home

	Events
	Current Events
	Upcoming Events
	Past Events
	SQL Immersion Events
	Event Log

	Services
	Mentoring
	Custom Courses

	Resources
	Articles
	Blogs
	Books
	Event Resources
	Interviews
	Knowledge Base Articles
	Q & A
	SQL Scripts
	Useful Links
	Whitepapers

	Partners

	Communications

	Contact Us

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)