 |
|
|
|
||
 |
|
|
| 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)
|
|
|
|
|
|
|
|
| SQL Immersion Event, San Diego, CA | |
| December 6 - 10, 2010 | |
| 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 |
|
|
|
|
| PASS Community Summit | |
| November 8 - 12, 2010 - Seattle, USA | |
| Pre-conference Workshop (November 8) (Paul & Kimberly): | |
| - |
Database Best Practices for the Involuntary DBA |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
| Post-conference Workshop (November 5) (Kimberly): | |
| - |
Indexing Strategies that work: Covering - Concepts, Concerns, Costs |
|
Demo Scripts |
|
| Conference Sessions: | |
| - |
DBA285S: DBA Mythbusters (Paul) |
|
Demo Scripts |
|
| - |
AD372S: Tales from the Trenches: GUIDs – Use, Abuse and How to Move Forward (Kimberly) |
|
Demo Scripts |
|
|
|
|
| TechEd Europe | |
| November 8- 12, 2010, Berlin, Germany | |
| Conference Sessions: | |
| - |
DAT401 A Database Developer and DBA Perspective: LINQ to SQL and Entity Framework vs. Stored Procedures (Bob) |
|
Demo Scripts |
|
| - |
DAT311 Introduction to SQL Server 2008 R2 Data-Tier Application Development (Bob) |
|
Demo Scripts |
|
| - |
DAT222 Code Name 'Denali' The near future of SQL Server
(Bob) |
|
Demo Scripts |
|
|
|
|
| SQL Connections Fall | |
| November 1 - 5, 2010 - Las Vegas, USA | |
| Pre-conference Workshop (November 1) (Paul & Kimberly): | |
| - |
SPR301: Database Best Practices for the Involuntary DBA |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
| Pre-conference Workshop (November 1) (Bob): | |
| - |
SPR302: Day of Scripting: Plumbing The Depths of SQL Server / PowerShell Integration |
|
Demo Scripts |
|
| Post-conference Workshop (November 5) (Kimberly): | |
| - |
SPS301: Tuning for High Performance |
|
Demo Scripts |
|
| Conference Sessions: | |
| - |
SDB306: Index Fragmentation: The Hidden Menace (Paul) |
|
Demo Scripts |
|
| - |
SDB407: Undocumented Tools and Trace Flags (Paul) |
|
Demo Scripts |
|
| - |
SDB305: DBA Mythbusters (Paul) |
|
No demos for this session. |
|
| - |
SDB308: Follow the Rabbit: Wrap-up Q&A (Paul & Kimberly) |
|
No demos for this session. |
|
| - |
SDB303: VLDB: Recovering from Isolated Disasters (Kimberly) |
|
Demo Scripts |
|
| - |
SDV305: GUIDs: Use, Abuse, and How To Move Forward (Kimberly) |
|
Demo Scripts |
|
| - |
SDV306: Index Internals: What you really need to know! (Kimberly) |
|
Companion content from SQL Server 2008 Internals Ch6 (Indexing) is here |
|
| - |
SDV308: Programming Filestreams and RBS in SQL Server 2008 R2 (Bob) |
|
Demo Scripts |
|
| - |
SDV309: Building, Deploying, and Monitoring StreamInsight Applications! (Bob) |
|
Demo Scripts |
|
| - |
SDV410: Auditing and Compliance Features in SQL Server 2008 (Bob) |
|
Demo Scripts |
|
|
|
|
| SQL Immersion Event, Bellevue, WA | |
| August 9 - 13, 2010 | |
| 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 |
|
|
|
|
| Microsoft TechReady 11 | |
| July 26 -30, 2010 - Seattle, USA | |
| Conference Sessions: | |
| - |
DB306: MasterClass: Disaster Recovery - Understanding Logging and Recovery (Paul) |
|
Demo Scripts |
|
| - |
DB305: MasterClass: Disaster Recovery - Recovering from Corruption (Paul) |
|
Demo Scripts |
|
| - |
DB308: MasterClass: Disaster Recovery - Creating an Effective Backup Strategy (Kimberly) |
|
Demo Scripts |
|
| - |
DB307: MasterClass: Disaster Recovery - Recovering from Isolated Disasters (Kimberly) |
|
Demo Scripts |
|
|
|
|
| SQLskills Disaster Recovery MasterClass | |
| July 7 - 8, 2010 - Dublin, Ireland | |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
|
|
|
| SQLskills Performance MasterClass | |
| July 5 - 6, 2010 - Dublin, Ireland | |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
|
|
|
| SQLskills Immersion Event | |
| June 28 - July 1, 2010 - Dublin, Ireland | |
|
Kimberly's Demo Scripts |
|
|
Paul's Demo Scripts |
|
|
|
|
| SQL UK MasterClass | |
| June 17, 2010 - London, UK | |
| Sessions: | |
| - |
Session 3: Disaster Recovery Demo-Fest (Paul and Kimberly) |
|
Paul's Demos |
|
|
Kimberly's Demos |
|
| - |
Session 4: GUIDs: Use, Abuse, and How To Move Forward (Kimberly) |
|
Demo Scripts |
|
|
|
|
| TechEd US | |
| June 5-10, 2010 - New Orleans, US | |
| Pre-conference Session: | |
| - |
PRC04: Setting Up and Managing a Secure and Compliant SQL Server |
|
Demo Scripts |
|
| Conference Sessions: | |
| - |
DAT301: A Database Developer and DBA Perspective: LINQ to SQL and Entity Framework vs. Stored Procedures |
|
Demo Scripts |
|
| - |
DAT402: Integrating Microsoft SQL Server Event Tracing with OS-Level Events and Database Client Events |
|
Demo Scripts |
|
|
|
|
| Vienna SQL Server User Group | |
| April 29, 2010 - Vienna, Austria | |
| Sponsored by bwin and Microsoft Austria. User group website is here. | |
|
|
|
Demo Scripts |
|
|
|
| SQL Connections Spring | |
| April 11 - 15, 2010 - Las Vegas, USA | |
| Pre-conference Workshop (April 11) (Paul & Kimberly): | |
| - |
Do You Feel The Need For Speed? Tuning for High Performance |
|
Demo Scripts |
|
| Conference Sessions: | |
| - |
SDB305: Leveraging Centralized Management Servers in SQL Server 2008 (Kimberly) |
|
No easily reproduced demos from the CMS session. For more information, check out our online course:
Microsoft eLearning Clinic 10259: SQL Server 2008: Database Infrastructure and Scalability |
|
| - |
SDV212: GUIDs: A Gift or a Gremlin? (Kimberly) |
|
Demo Scripts |
|
| - |
SDV310: SQL Server Covering: Concepts, Concerns, and Costs (Kimberly) |
|
Demo Scripts |
|
| - |
SDV311: Statistics: Are They Really Important? (Kimberly) |
|
Demo Scripts |
|
| - |
SDB306: DBA Mythbusters (Paul) |
|
No demos for this session. |
|
| - |
SDB307: Understanding Logging and Recovery in SQL Server (Paul) |
|
Demo Scripts |
|
| - |
SDB308: Building the Right Backup Strategy (Paul) |
|
Demo Scripts |
|
| - |
SDB309: Follow the Rabbit: Wrap-up Q&A (Paul & Kimberly) |
|
No Demos for this sessions |
|
|
|
|
| SQL Immersion Event, Boston | |
| March 29 - April 2, 2010 - Boston | |
| 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 |
|
|
|
|
| DevTeach | |
| March 8-12, 2010 - Toronto, Canada | |
|
Many thanks to the Toronto SQL Server User Group for having me present during the week! |
|
| Pre-conference Workshop (March 8) (Kimberly): | |
| - |
Indexing for Performance |
|
Demo Scripts |
|
| Post-conference Session (March 12) (Kimberly): | |
| - |
Developers Can't Ignore SQL Server Database Maintenance! |
|
Demo Scripts 1 |
|
|
Demo Scripts 2 |
|
| Conference Sessions: | |
| - |
SQL345: Optimizing Procedural Code (Kimberly) |
|
Demo Scripts |
|
| - |
SQL355: Tips and Tricks for Proper SQL Server Table Design (Kimberly) |
|
Demo scripts coming soon |
|
|
|
|
| |
| |
|
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com |
|