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)   SQL Connections, Fall 2009 November 9 - 13, 2009 - Las Vegas, USA Pre-conference Session (November 9) (Paul & Kimberly): - SQL Server 2005/2008: Database Maintenance Best Practices  Kimberly's Demo Scripts  Paul's Demo Scripts Post-conference Session (November 13) (Kimberly): - SQL Server 2005/2008: Indexing for Performance Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here. Class demos:  Demo Scripts Conference Sessions: - SDB303: Understanding Logging and Recovery in SQL Server (Paul)  Demo Scripts - SDB305: Building the Right Backup Strategy (Paul)  Demo Scripts - SDV307: SQL Server Covering: Concepts, Concerns, & Costs (Kimberly)  Demo Scripts - SDV308: SQL Server 2008 Sparse Columns: Structures, Storage, Speed (Kimberly)  Demo scripts - SDV309: Follow the Rabbit: Interactive Q & A on... Everything! (Paul & Kimberly)   Microsoft TechEd Europe 2009 November 9 - 13, 2009 - Berlin, Germany   Presented by Microsoft Corporation Conference Sessions, presented by Bob Beauchemin: - DAT401: Auditing and Compliance Features in SQL Server 2008  Code Samples - DAT405: Peeking into the plan cache with SQL Server 2008  Code Samples - DAT03-IS: Filtered Indexes and Statistics in SQL Server 2008  Code Samples   SQL PASS Community Summit, 2009 November 2 - 6, 2009 - Seattle, USA Pre-conference Session (November 2) (Kimberly): - SQL Server 2005/2008: Indexing for Performance Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here. Class demos:  Demo Scripts Post-conference Session (November 6) (Paul): - Disaster Recovery: Tips, Tricks, and Techniques  Demo Scripts Spotlight Sessions: - Understanding Logging and Recovery in SQL Server (Paul)  Demo Scripts - SQL Server Covering: Concepts, Concerns, & Costs (Kimberly)  Demo Scripts   SQL Immersion Event, Melbourne, Australia October 19 - 22, 2009 SQL Server 2005/2008: Performance Tuning: From Design to Indexing to Optimizing Procedural Code: - Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here. Class demos:  Demo Scripts SQL Server 2005/2008: Database Maintenance and Availability: From Performance to Disaster Recovery: - Demos for all modules:  Demo Scripts   SQL Immersion Event, Dublin, Ireland September 21 - 25, 2009 - Microsoft EPCD2, Dublin, Ireland Kimberly's Modules: - Partitioning: demos are on the DVD we gave out, whitepaper is here. - Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here. Class demos:  Demo Scripts Paul's Modules: - Demos for all modules:  Demo Scripts   SQL Connections, Spring 2009 March 22 - 26, 2009 - 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. Copyright 2011 SQLskills.com