 |
|
|
|
||
 |
|
|
| 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 | |
| October 30 - November3, 2011 - Las Vegas, USA | |
| Pre-conference Workshop (November 30) (Paul & Kimberly): | |
| - |
SPR201: The Building Blocks of a Healthy and Available SQL Server |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
|
Hidden Slides and all links |
|
| Pre-conference Workshop (November 31) (Kimberly): | |
| - |
SPR303: Designing for Performance and Scalability |
|
Demo Scripts |
|
| Conference Sessions: | |
| - |
SQL419: Wait Statistics: Avoiding 'Knee-Jerk' Performance Tuning (Paul) |
|
Demo Scripts |
|
| - |
SQL422: Advanced Recovery Techniques (Paul) |
|
Demo Scripts |
|
| - |
SQL216: More DBA Mythbusters (Paul) |
|
No demos for this session. |
|
| - |
SQL225: Follow the Rabbit: Wrap-up Q&A (Paul & Kimberly) |
|
No demos for this session. |
|
| - |
SQL207: Precarious? Nefarious? Strategies that Work for Nonclustered Indexes! (Kimberly) |
|
Demo Scripts |
|
| - |
SQL310: Taking the Sting Out of Statistics (Kimberly) |
|
Demo Scripts |
|
| - |
SQL313: Filtered Indexes and Filtered Statistics: The good, the bad and the ugly (Kimberly) |
|
Demo Scripts |
|
|
|
|
| PASS Summit | |
| October 10 - 14, 2011 - Seattle, USA | |
| Workshops: | |
| - |
DBA-498-P: Extended Events Deep Dive (Jonathan) |
|
Demo scripts
|
|
| Conference Sessions: | |
| - |
DBA-316-S: More DBA Mythbusters (Paul) |
|
Demo scripts
|
|
| - |
DBA-315-S: VLDB Isolated Disasters (Kimberly) |
|
Demo scripts
|
|
| - |
DBA-313-S: Using Event Notifications in SQL Server 2005/2008 (Jonathan) |
|
Demo scripts
|
|
|
|
|
| SQL Connections Europe | |
| June 08 - 10, 2011 - Karlsruhe, Germany | |
| Pre-conference Workshop (June 8) (Paul & Kimberly): | |
| - |
SPR201: Performance Tuning From A to Z |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
| Conference Sessions: | |
| - |
SQL01: DBA Mythbusters (Paul) |
|
No demos for this session. |
|
| - |
SQL02: Corruption Survival Techniques (Paul) |
|
Demo scripts
(see this blog post for details)
|
|
| - |
SQL09: Building the Right Backup Strategy (Paul) |
|
Demo Scripts |
|
| - |
SQL06: Index Fragmentation: The Hidden Menace (Paul) |
|
Demo Scripts |
|
| - |
SQL03: Optimizing Procedural Code (Kimberly) |
|
Demo Scripts |
|
| - |
SQL04: Covering: Concepts, Concerns and Costs (Kimberly) |
|
Demo Scripts |
|
| - |
SQL05: Filtered Indexes and Filtered Stats (Kimberly) |
|
Demo Scripts |
|
|
|
|
| Dev Days 2011, Bob Beauchemin | |
| April 27-29 2011, The Hague, Netherlands | |
| - |
Pre-con: Multiple developer topics |
|
Demo Scripts |
|
| - |
Session: Full Text Search in SQL Server 2008 and Denali
|
|
Demo Scripts |
|
| - |
Session: Mission-Critical SQLCLR - Internals and Best Practices
|
|
Demo Scripts |
|
| - |
Session: Programming Filestreams and RBS in SQL Server 2008 R2
|
|
Demo Scripts |
|
| - |
Session: Extended Events Comes of Age in SQL Server Denali
|
|
Demo Scripts |
|
|
|
|
| SQL Connections Spring | |
| March 27 - 31, 2011 - Orlando, USA | |
| Pre-conference Workshop (March 27) (Paul & Kimberly): | |
| - |
SPR201: The Building Blocks of a Healthy and Available SQL Server |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
| Pre-conference Workshop (March 27) (Bob): | |
| - |
SPR302: Day of Scripting: Plumbing The Depths of SQL Server / PowerShell Integration |
|
Demo Scripts |
|
| Post-conference Workshop (March 31) (Kimberly): | |
| - |
SPS301: Indexing Strategies and Analysis |
|
Demo Scripts |
|
| Conference Sessions: | |
| - |
SDB310: Index Fragmentation: The Hidden Menace (Paul) |
|
Demo Scripts |
|
| - |
SDB412: Undocumented Tools and Trace Flags (Paul) |
|
Demo Scripts |
|
| - |
SDB208: DBA Mythbusters (Paul) |
|
No demos for this session. |
|
| - |
SDB213: Follow the Rabbit: Wrap-up Q&A (Paul & Kimberly) |
|
No demos for this session. |
|
| - |
SDB305: VLDB: Recovering from Isolated Disasters (Kimberly) |
|
Demo Scripts |
|
| - |
SDV303: Optimizing Procedural Code (Kimberly) |
|
Demo Scripts |
|
| - |
SDV302: Index Internals: What you really need to know! (Kimberly) |
|
Companion content from SQL Server 2008 Internals Ch6 (Indexing) is here |
|
| - |
SDB414: Expanding the Scope and Ease of Use of Query Plan Guides in SQL Server 2008 (Bob) |
|
Demo Scripts |
|
| - |
SDV306: Full Text Search in SQL Server 2008 and Denali (Bob) |
|
Demo Scripts |
|
| - |
SDV304: Spatial Data "Stretches Out" in SQL Server Denali (Bob) |
|
Demo Scripts |
|
|
|
|
| DevWeek 2011, Bob Beauchemin | |
| March 14 - 18, 2011 - London, UK | |
| - |
Pre-con: Writing SQL server database applications & stored procedures for best performance |
|
Demo Scripts |
|
| - |
Session: Performance enhancements in SQL Server 2008
|
|
Demo Scripts |
|
| - |
Session: A showcase application using SQL Server 2008
|
|
Demo Scripts |
|
| - |
Session: LINQ to SQL and Entity Framework vs. stored procedures
|
|
Demo Scripts |
|
| - |
Session: Modeling and implementing hierarchies with SQL Server
|
|
Demo Scripts |
|
| - |
Session: New Developer Features in SQL Server Denali
|
|
Demo Scripts |
|
|
|
|
| Public Class, Bob Beauchemin | |
| March 10-11, 2011 - Stockholm, Sweden | |
| - |
Demos for all modules: |
|
Demo Scripts |
|
|
|
|
| |
| |
|
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com |
|