 |
|
|
|
||
 |
|
|
| Home |
|
|
| Remote DBA Service |
|
|
| Consulting and Performance |
|
|
| Server Health Checks |
|
|
| Training |
|
|
| Resources |
|
|
| Calendar |
|
|
| Past Customers |
|
|
| What our Students say |
|
|
| About SQLskills.com |
|
| Upcoming Events | Past Events | |
| |
| 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | Pre-2005 | |
| |
|
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)
|
|
|
|
|
|
|
|
| Expert Seminar at Addskills, Bob Beauchemin | |
| April 3-4 2012, Stockholm, Sweden | |
| - |
Session: New Features in SQL Server 2012 For Developers
|
|
Demo Scripts |
|
|
|
|
| SQLBits X, Bob Beauchemin | |
| March 30-31 2012, London, UK | |
| - |
Session: Extended Events and the new Profiler in SQL Server 2012
|
|
Demo Scripts |
|
| - |
Session: SQL Spatial Stretches Out In SQL Server 2012
|
|
Demo Scripts |
|
|
|
|
| DevWeek UK, Bob Beauchemin | |
| March 26-29 2012, London, UK | |
| - |
Precon: T-SQL New features in SQL Server 2012 for developers
|
|
Demo Scripts |
|
| - |
Session: SQL Server security best practices
|
|
Demo Scripts |
|
| - |
Session: Extended Events and the new Profiler in SQL Server 2012
|
|
Demo Scripts |
|
| - |
Session: Mission-critical SQLCLR: internals and best practices
|
|
Demo Scripts |
|
| - |
Session: Full text and semantic search in SQL Server 2008 & 2012
|
|
Demo Scripts |
|
| - |
Session: Developing for SQL Server 2012 with SQL Server Data Tools
|
|
No demo scripts for this session |
|
|
|
|
| SQL Saturday #105, Bob Beauchemin | |
| March 24 2012, Dublin, Ireland | |
| - |
Session: Searching over data and files with SQL Server 2012
|
|
Demo Scripts |
|
|
|
|
| SQL Connections Spring | |
| March 27 - 29, 2012 - Las Vegas, USA | |
| Pre-conference Workshop (March 25) (Paul & Kimberly): | |
| - |
SPR202: The Building Blocks of a Healthy and Available SQL Server |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
| Pre-conference Workshop (March 25) (Jonathan): | |
| - |
SPR301: Advanced Diagnostics with SQLServer 2012 Extended Events |
|
Demo Scripts |
|
| Pre-conference Workshop (March 26) (Kimberly and Jonathan): | |
|
Kimberly's Demo Scripts |
|
|
Jonathan's Demo Scripts |
|
|
Session Links |
|
| Post-conference Workshop (March 30) (Kimberly): | |
| - |
SPS202: Optimizing Procedural Code: Understanding Plan Cache, Procedural Code and Recompilation |
|
Demo Scripts |
|
| Conference Sessions: | |
| - |
SQL416: Wait Statistics: Avoiding 'Knee-Jerk' Performance Tuning (Paul) |
|
Demo Scripts |
|
| - |
SQL417: Advanced Recovery Techniques (Paul) |
|
Demo Scripts |
|
| - |
SQL218: Follow the Rabbit: Wrap-up Q&A (Paul & Kimberly) |
|
No demos for this session. |
|
| - |
SQL219: Performance Tuning through Indexing (Kimberly) |
|
Demo Scripts |
|
|
Companion content from SQL Server 2008 Internals Ch6 (Indexing) is here |
|
| - |
SQL320: Statistics: What, Why and How the Optimizer Uses Them (Kimberly) |
|
Demo Scripts |
|
| - |
SQL307: Deadlocking for Mere Mortals (Jonathan) |
|
Demo Scripts |
|
| - |
SQL208: Distributed Replay in SQL Server 2012 (Jonathan) |
|
Demo Scripts |
|
|
|
|
| Tech Days 2012, Bob Beauchemin | |
| February 15-18 2012, The Hague, Netherlands | |
| - |
Session: T-SQL Improvements in SQL Server 2012
|
|
Demo Scripts |
|
| - |
Session: Full-text and Semantic Search in SQL Server 2012
|
|
Demo Scripts |
|
| - |
Session: Filestreams and FileTables in SQL Server 2012
|
|
Demo Scripts |
|
| - |
Session: Using SQL Azure Database Federations
|
|
Demo Scripts |
|
| - |
Session: Exploring SQL Server Data Tier Applications
|
|
No demo scripts for this session |
|
|
|
|
| |
| |
|
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com |
|