 |
|
|
|
||
 |
|
|
| 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)
|
||
|
|
||
|
|
||
| SQLskills SQL Immersion Event | ||
| December 5 - 6, 2005 - Reykjavik, Iceland | ||
| Presented by Bob Beauchemin | ||
Brought to you by  | ||
| Demo Scripts Day 1 |
||
| Demo Scripts Day 2 |
||
|
||
| SQLskills SQL Immersion Event | ||
| November 21 - 23, 2005 - Zurich, Switzerland | ||
| Presented by Kimberly L. Tripp | ||
| Brought to you by Trivadis AG | ||
| Demo Scripts |
||
|
||
| SQLskills SQL Immersion Event | ||
| November 21 - 24, 2005 - Amsterdam, Netherlands | ||
| Presented by Bob Beauchemin | ||
| Brought to you by Class-A | ||
| Demo Scripts |
||
|
||
| Microsoft ITForum | ||
| November 14 - 18, 2005 - Barcelona, Spain | ||
|
http://www.microsoft.com/europe/msitforum/ | |
| Kimberly L. Tripp | ||
| Pre-Conference Seminar: | ||
| - |
Designing for Performance with SQL Server 2005 14 November 2005, 13:00 - 19:00 |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - |
SQL Server 2005: What's the Server Doing Now? (DAT303) 15 November 2005, 16:00 - 17:15 |
|
|
Demo Scripts |
||
| - |
SQL Server 2005 Security for System Administrators (DAT311) 15 November 2005, 17:45 - 19:00 |
|
|
Demo Scripts |
||
| - |
SQL Server 2005 Indexing: It Really Does Help! (DAT307) 16 November 2005, 09:45 - 11:00 |
|
|
Demo Scripts |
||
| - |
SQL Server 2005: Fixing Fragmentation from Disk to Log to Indexes (DAT309) 16 November 2005, 15:30 - 16:45 |
|
|
Demo Scripts |
||
| - |
Your High-Availability Options with SQL Server 2005 (CHT036) 17 November 2005, 08:15 - 09:30 |
|
| - |
Managing VLDB Databases in SQL Server 2005: Availability and Recovery Strategies (DAT315) 17 November 2005, 10:00 - 11:15 |
|
|
Demo Scripts |
||
| - |
Women in Technology (Lunch Forum) (WIT001) 17 November 2005, 12:45 - 14:15 |
|
| Bob Beauchemin | ||
| Conference Sessions: | ||
| - |
SQL Server 2005: Understanding the Operational Impact of Service Broker (DAT301) 17 November 2005, 15:45 - 17:00 |
|
|
Demo Scripts |
||
| - |
Architecting the Right Solution - Transact-SQL or SQLCLR : What DBA’s Should Know (DAT302) 15 November 2005, 14:15 - 15:30 |
|
|
Demo Scripts |
||
| - |
SQL Server 2005: Transact-SQL is Not Dead! (DAT304) 16 November 2005, 11:15 - 12:30 |
|
|
Demo Scripts |
||
| - |
SQL Server 2005: Architecting the Right Solution with New Type Choices (DAT310) 16 November 2005, 17:15 - 18:30 |
|
|
Demo Scripts |
||
|
||
| SQL Server Magazine Connections - Fall 2005 | ||
| November 7-10 - Mandalay Bay Resort and Casino, Las Vegas, NV | ||
| SQL Server Magazine Connections | ||
| Presented by Penton Media, Inc. and SQL Server Magazine | ||
| Kimberly L. Tripp | ||
| Pre-Conference Workshop: | ||
| - |
Understanding and Effectively Using SQL Server 2005's New Tools 7 November 2005, 9:00 to 16:00 |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - |
SQL Server 2005 Partitioning 9 November 2005, 14:00 - 15:15 |
|
|
Presentation Handout |
||
|
Demo Scripts |
||
| - |
SQL Server Index Creation Best Practices 10 November 2005, 9:30 - 10:45 |
|
|
Presentation Handout |
||
|
Demo Scripts |
||
| - |
SQL Server Index Maintenance Best Practices 10 November 2005, 11:15 - 12:30 |
|
|
Presentation Handout |
||
|
Demo Scripts |
||
| - |
SQL Server 2005: Optimizing Stored Procedure Performance 10 November 2005, 13:30 - 14:30 |
|
|
Presentation Handout |
||
|
Demo Scripts |
||
|
||
| Microsoft Tech*Ed 2005 Hong Kong | ||
| October 3 - 6, 2005 - Hong Kong Convention and Exhibition Center | ||
| Presented by Microsoft Corporation | ||
| Bob Beauchemin | ||
| Pre-conference Session: | ||
| - |
Get Ready for SQL Server 2005, what every developer should know |
|
|
Code Samples |
||
| Conference Sessions: | ||
| - |
SQLCLR vs. T-SQL: Best Practices for Development in the Database |
|
|
Code Samples |
||
| - |
Service-Oriented Data Architecture (SODA) How SQL Server 2005 Fits into the Service-Oriented Architecture (SOA) World |
|
|
Code Samples |
||
| - |
Integrated Innovation: Using ADO.NET 2.0 with SQL Server 2005 |
|
|
Code Samples |
||
| - |
Developing Secure Applications with SQL Server 2005 |
|
|
Code Samples |
||
| - |
Together at Last: Combining XML and Relational Data in SQL Server 2005 |
|
|
Code Samples |
||
| - |
Adding Alerting Functionality to Database Applications with SQL Server Notification Services |
|
|
Code Samples |
||
| - |
Introducing SSMA:Migrating from Oracle to SQL Server with 80% Less Effort |
|
|
||
| 2005 PASS Community Summit | ||
| September 27-30, 2005 - Grapevine, Texas | ||
|
2005 PASS Community Summit | |
| Presented by PASS, the Professional Association for SQL Server | ||
| Kimberly L. Tripp | Spotlight Presenter 
| |
| Pre-conference Session: | ||
| - |
The Next Generation DBA, Critical New SQL Server 2005 Features YOU Need to Learn! Tuesday, 27 September 2005, 09:00am - 05:00pm |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - |
Indexing Best Practices in SQL Server 200x - A Fast-paced Collection of Tips and Tricks for BOTH SQL Server 2000 and SQL Server 2005 Wednesday, 28 September 2005 |
|
|
Demo Scripts |
||
| Bob Beauchemin | Spotlight Presenter
| |
| Pre-conference Sessions: | ||
| - |
Part 1: Essential SQL Server 2005: New Features in SQL Server 2005 and .NET for Developers In-Depth Monday, 26 September 2005, 08:30am - 04:30pm |
|
|
CodeSamples |
||
| - |
Part 2: Essential SQL Server 2005: New Features in SQL Server 2005 and .NET for Developers In-Depth Tuesday, 27 September 2005, 08:30am - 04:30pm |
|
|
CodeSamples |
||
| Conference Session: | ||
| - |
SQL Server 2005 XQuery Primer Thursday, 29 September 2005, 10:15 - 11:45 |
|
|
CodeSamples |
||
|
||
| Microsoft Professional Developers Conference 2005 | ||
| September 11 - 16, 2005 - Los Angeles, CA | ||
|
Official 2005 PDC Site | |
| Presented by Microsoft Corporation | ||
| Details to be posted shortly! | ||
|
||
| Microsoft Tech*Ed Europe 2005 | ||
| July 4 - 8, 2005 - Amsterdam, the Netherlands |
||
|
Official Microsoft Tech*Ed Europe Site | |
| Presented by Microsoft Corporation | ||
| Pre-conference Seminar: | ||
| - | SQL Server 2005 Management Tools: Effectively Using and Understanding the new SQL Server 2005 Toolsetì Monday, 4 July 2005, 10:00 - 18:00 |
|
|
Scripts for the Self-paced Labs |
||
| Conference Sessions: | ||
| - |
SQL Server 2005: Bridging the Gap between Development and Administration ì Tuesday, July 5, 16:30 - 17:45 |
|
|
Demo Scripts |
||
| - |
SQL Server 2005 Security for System Administratorsì Wednesday, July 6, 10:15 - 11:30 |
|
|
Demo Scripts |
||
| - |
Understanding Index Usage and Indexing Best Practices in SQL Server 2005 ì Wednesday, July 6, 14:45 - 16:00 |
|
|
Demo Scripts |
||
| - |
Index Defragmentation Best Practices in SQL Server 2005ì Wednesday, July 6, 16:30 - 17:45 |
|
|
Demo Scripts |
||
| - |
VLDB Availability and Recovery Strategies for SQL Server 2005 ì Thursday, July 7, 10:15 - 11:30 |
|
|
Demo Scripts |
||
| - |
Understanding Transaction Isolation in SQL Server 2000 and 2005 ì Thursday, July 7, 14:45 - 16:00 |
|
|
Demo Scripts |
||
| - |
Achieving High Availability with SQL Server 2005ì Thursday, July 7, 18:15 - 19:30 |
|
|
Demo Scripts |
||
| - |
SQL Server 2005 Security for Database Developersì Friday, July 8, 12:00 - 13:15 |
|
|
Demo Scripts |
||
|
||
| Microsoft Tech*Ed US 2005 | ||
| June 5 - 10, 2005 - Orlando, Florida |
||
|
Official Microsoft Tech*Ed US Site | |
| Presented by Microsoft Corporation | ||
| Pre-conference Seminar: | ||
| - | Taming the Tools: Effectively Using and Understanding SQL Server 2005 Tools ì Sunday, 5 June 2005, 13:00 - 18:00 |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - |
Understanding Index Usage and Indexing Best Practices in SQL Server 2005 ì Monday, June 6, 17:00 - 18:15 Room: N 210 E |
|
|
Demo Scripts |
||
| - |
RD Community Booth Duty Tuesday, June 7, 10:00 - 12:00 |
|
| - |
GrokTalk - On Stored Procedure Recompilation Tuesday, June 7, 15:55 - 16:05 Find out more ì |
|
|
Demo Scripts |
||
| - |
VLDB Availability and Recovery Strategies for SQL Server 2005 ì Wednesday, June 8, 10:15 - 11:30 Room: N 230 |
|
|
Demo Scripts |
||
| - |
Women In Technology Luncheon Wednesday, June 8, 11:30 - 13:30 Find out more ì |
|
| - |
Understanding Transaction Isolation in SQL Server 2000 and 2005 ì Wednesday, June 8, 17:30 - 18:45 Room: N 320 D/H |
|
|
Demo Scripts |
||
| - |
SQL Server 2005: Bridging the Gap between Development and Administration ì Thursday, June 9, 10:15 - 11:30 Room: S 220 D |
|
|
Demo Scripts |
||
|
||
| 2005 PASS European Conference | ||
| May 11 - 13, 2005 - Munich, Germany | ||
|
2005 PASS European Conference | |
| Presented by PASS, the Professional Association for SQL Server | ||
Spotlight Presenter
| ||
| Pre-conference Session: | ||
| - |
The Next Generation DBA, Critical New SQL Server 2005 Features YOU Need to Learn!ì Wednesday, 11 May 2005, 09:00 - 17:00 |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - |
Indexing Best Practices in SQL Server 2000: From Creation to Performance to Maintenanceì Thursday, 12 May 2005, 15:00 - 16:15 |
|
|
Demo Scripts |
||
| - |
Changes to Indexing in SQL Server 2005: From Creation to Performance to Maintenance to Monitoringì Thursday, 12 May 2005, 16:45 - 18:00 |
|
|
Demo Scripts |
||
|
||
| Master Class on Achieving High Availability with SQL Server 2005 | ||
| May 2 - 4, 2005 - Copenhagen, Denmark | ||
|
Presented by For future Miracle events: here. |
|
|
Demo Scripts |
||
|
||
| Microsoft Professional Developers Summit 2005 | ||
| April 25 - 27, 2005 - Istanbul, Turkey |
||
|
http://www.microsoft.com/middleeast/egypt/english/events/MDC/ | |
| Conference Sessions: | ||
| - | SQL Server 2005: Bridging the Gap between Development and Administrationì Tuesday, 26 April 2005, 10:20 - 11:20 |
|
| - | SQL Server 2005: New Features in Performance, Manageability and Recovery, Part Iì Tuesday, 26 April 2005, 15:20 - 16:20 |
|
|
Demo Scripts |
||
| - | SQL Server 2005: New Features in Performance, Manageability and Recovery, Part IIì Tuesday, 26 April 2005, 16:40 - 17:40 |
|
|
Demo Scripts |
||
| - | SQL Server Indexing Best Practicesì Wednesday, 27 April 2005, 9:00 - 10:00 |
|
|
Demo Scripts |
||
| - | SQL Server 2005: Indexing New Featuresì Wednesday, 27 April 2005, 10:20 - 11:20 |
|
|
Demo Scripts |
||
| - | SQL Server Partitioning Strategies (for both SQL Server 2000 and SQL Server 2005)ì Wednesday, 27 April 2005, 11:40 - 12:40 |
|
|
Demo Scripts |
||
|
||
| SQL Server Magazine Connections - Spring 2005 | ||
| March 20 - 24, 2005 - Orlando, FL | ||
|
SQL Server Magazine Connections | |
| Presented by Penton Media, Inc. and SQL Server Magazine | ||
| Pre-conference Seminar: | ||
| - |
SPR353: SQL Server Indexes from Every Angle - Internals, Statistics, Performance, and Changes Expected in SQL Server 2005 Sunday, March 20, 09:00 to 16:00 |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - |
SDB356: SQL Server Partitioning, Part I: SQL Server 2000 Partitioned Views and SQL Server 2005 Partitioned Tablesì Tuesday, March 22, 2005 - 14:00 to 15:15 |
|
|
Demo Scripts |
||
| - |
SDB357: SQL Server Partitioning, Part II: Implementing SQL Server 2005 Partitioned Tablesì Tuesday, March 22, 2005 - 15:30 to 16:45 |
|
|
Demo Scripts |
||
| - |
SDB355: SQL Server 2005 - New Features for VLDBsì Wednesday, March 23, 2005 - 13:30 to 14:30 |
|
|
Demo Scripts |
||
| - |
SDB406: SDB406: SQL Server Index Maintenance Best Practicesì Wednesday, March 23, 2005 - 14:45 to 15:45 |
|
|
Demo Scripts |
||
|
||
| Microsoft Tech Days | ||
| March 16 - 17, 2005 - Interlaken, Switzerland | ||
|
Official Microsoft Tech Days 2005 Site | |
| Keynote Session: | ||
| - | SQL Server 2005: Bridging the Gap between Development and Administrationì Thursday, 17 March 2005, 09:00 - 10:00 |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - | Operational Best Practices: Recovery and Performance in SQL Server 2000ì Wednesday, 16 March 2005, 16:45 - 18:00 |
|
|
Demo Scripts |
||
| - | SQL Server 2000 Performance Best Practices and Getting Ready for SQL Server 2005ì Thursday, 17 February 2005, 12:00 - 13:15 |
|
|
Demo Scripts |
||
|
||
| .NET Managed User Group of Switzerland | ||
| March 14, 2005 - Microsoft Zurich | ||
| Presented by Digicomp Academy | ||
|
||
|
Demo Scripts |
||
|
||
| SQL Server 2005 Customer Visits | ||
| March 14, 2005 - Microsoft Zurich | ||
| Presented by Microsoft Corporation | ||
|
||
|
Demo
Scripts |
||
|
||
| SQL Server 2005 Ascend Program | ||
| February 28 - March 4, 2005 - Microsoft UK Delivery | ||
| Presented by Microsoft Corporation | ||
|
||
|
Demo Scripts |
||
|
||
| SQLLive! at VSLive San Francisco | ||
| February 8- 9, 2005 - San Francisco, CA | ||
|
SQLLive! | |
|
Presented by Fawcette Technical Publications | |
| Conference Sessions: | ||
| - | SQL Server 2000: Indexing Best Practicesì Wednesday, 9 February 2005, 15:15 - 16:15 |
|
|
Demo Scripts |
||
| - | SQL Server 2005: Indexing New Featuresì Wednesday, 9 February 2005, 16:30 - 17:30 |
|
|
Demo Scripts |
||
| Post-Conference Workshop: | ||
| - | SQL Server 2000: Optimizing Server-Side Processing in SQL Server: Transactions, Recovery, Logging and Lockingì Thursday, 10 February 2005, 09:00 - 18:00 |
|
|
Demo Scripts |
||
|
||
| Microsoft Developer and ITPro Days | ||
| February 1 - 2, 2005 - Brussels, Belgium | ||
|
http://www.microsoft.com/belux/fr/devitprodays/humanspirit.aspx | |
| Keynote Session: | ||
| - | SQL Server 2005: Bridging the Gap between Development and Administrationì Wednesday, 2 February 2005, 09:00 - 10:15 |
|
|
Demo Scripts |
||
| Conference Sessions: | ||
| - | SQL Server 2005 for DBAs, Part Iì Wednesday, 2 February 2005, 14:30 - 15:45 |
|
|
Demo Scripts |
||
| - | SQL Server 2005 for DBAs, Part IIì Wednesday, 2 February 2005, 16:00 - 17:15 |
|
|
Demo Scripts |
||
|
||
| Microsoft Middle East Developers Conference 2005 (MDC2005) | ||
| January 29 - 31, 2005 - Cairo, Egypt | ||
|
http://www.microsoft.com/middleeast/egypt/english/events/MDC/ | |
| General Session: | ||
| - | SQL Server 2005: Bridging the Gap between Development and Administrationì Sunday, 30 January 2005, 15:00 - 16:15 |
|
|
Slide Handouts |
||
| Conference Sessions: | ||
| - | SQL Server 2005: New Features in Performance, Manageability and Recoveryì Monday, 31 January 2005, 09:30 - 10:45 |
|
|
Slide Handouts |
||
| - | SQL Server 2005: Changes in Indexingì Monday, 31 January 2005, 11:00 - 12:15 |
|
|
Slide Handouts |
||
|
Demo Scripts |
||
|
||
| SQL Server 2005 Ascend Program | ||
| January 24 - 28, 2005 - Las Colinas, Texas | ||
| Presented by Microsoft Corporation | ||
|
||
|
Demo Scripts |
||
|
||
| SQL Server 2005 Ascend Program | ||
| January 10 - 14, 2005 - Charlotte, North Carolina | ||
| Presented by Microsoft Corporation | ||
|
||
|
Demo Scripts |
||
|
||
| ||
| ||
|
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com |
|