SQLskills
SQL MCM
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
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)
 
EastMed Developers Conference - EDC 2004
November 23 - 25, 2004 - Amman, Jordan
http://www.microsoft.com/middleeast/edc
Conference Sessions:
- SQL Server 2000 Designing for Performance: General Database Optimizationsì
Wednesday, 24 November 2004, 14:45 - 16:00
- SQL Server 2000 Optimizing Procedural Codeì
Wednesday, 24 November 2004, 16:30 - 17:45
 Demo Scripts
- SQL Server 2000 Indexing for Performance: Index Creation Best Practicesì
Thursday, 25 November 2004, 9:00 - 10:15
 Demo Scripts
- SQL Server 2000 Indexing for Performance: Preventing, Controlling, and Minimizing Fragmentationì
Thursday, 25 November 2004, 10:45 - 12:00
 Demo Scripts
- SQL Server Partitioning Strategies (Covers both SQL Server 2000 and SQL Server 2005)ì
Thursday, 25 November 2004, 14:45 - 16:00
 Demo Scripts
 
 
Norwegian SQL Server User Group presents a special one-day Immersion Event
November 22, 2004 - Oslo, Norway
Presented by Norwegian SQL Server User Group
Full-day Seminar:
- SQL Server Indexes from Every Angle - Internals, Statistics, Performance and Maintenanceì
Monday, November 22, 9:00 to 18:00
 Demo Scripts
 
 
Microsoft ITForum
November 15 - 19, 2004 - Copenhagen, Denmark
http://www.microsoft.com/europe/msitforum/
Pre-conference Seminar:
- SQL Server 2000 Operational Best Practicesì
Monday, November 15, 10:00 to 18:00
ÞITForum Top Rated Preconference Workshop
 Demo Scripts
Conference Sessions:
- Indexing for Performance: Index Creation Best Practices (DAT348) ì
Tuesday, November 16, 18:15 to 19:30
ÞITForum Top Rated Session - Rated Number 4 Overall
ÞOverall Rating: 8.47 of 9.0
 Demo Scripts
- Operational Best Practices: Performance and Recovery (DAT322) ì
Wednesday, November 17, 18:15 to 19:30
ÞITForum Top Rated Session - Rated Number 1 Overall
ÞOverall Rating: 8.61 of 9.0
 Demo Scripts
- Indexing for Performance: Table/Index Fragmentation Best Practices (DAT348) ì
Thursday, November 18, 16:30-17:45
ÞITForum Top Rated Session - Rated Number 2 Overall
ÞOverall Rating: 8.57 of 9.0
 Demo Scripts
 
 
SQL Server Magazine Connections - Fall 2004
Nov 7 - 10, 2004 - Las Vegas, NV
SQL Server Magazine Connections
Presented by Penton Media, Inc. and SQL Server Magazine
Pre-conference Seminar:
- SPR301: Designing for Performance - Database Creation, Table Creation, Partitioning, Indexing
Sunday, November 7, 09:00 to 16:00
 Demo Scripts
Conference Sessions:
- SDV432: SQL Server Logging and Recovery - What Every Developer and DBA ShouldTalk About...together!
Tuesday, November 9, 14:00 to 15:15
 Demo Scripts
- SDB433: SQL Server Best Practices in Index Defragmentation
Tuesday, November 9, 15:45 to 17:00
 Demo Scripts
- SDB417: SQL Server 2000 Optimizing Stored Procedure Performance
Wednesday, November 10, 11:15 to 12:30
 Demo Scripts
- SDB418: SQL Server Performance Tuning - Follow the Rabbit Q&A
Wednesday, November 10, 14:00 to 15:15
No Demo Scripts
 
 
Miracle Database Forum
October 28 - 30, 2004 - Lalandia, Denmark
Miracle Database Forum Invitation
Full day Conference Workshop:
- Designing for Performance - Database Creation, Table Creation, Partitioning, Indexing
Friday, October 29, 09:00 to 17:00
 Demo Scripts
 
PASS Denmark
Monthly User Group Meeting - Copenhagen, Denmark
Guest Lecture Session:
- SQL Server 2000 Performance Best Practices and Favorite New SQL Server 2005 Features
Wednesday, October 27
(not sure exactly when or where... but if you're a member you probably already know :)
 
Miracle Iceland and SQLskills team up to offer a SQL Immersion Event in Iceland
Tuning High Performance Databases using SQL Server 2000
Reykjavik University, Reykjavik, Iceland
October 19-22, 2004 presented by Kimberly L. Tripp
Event Details
 Library Sample Database Backup (1.24 MB)
 Credit Sample Database Backup (48 MB)
 Demo Scripts
 
SQLskills SQL Immersion Event
Oct 11 - 15, 2004 - Chicago, Illinois
Tuning High Performance Databases using SQL Server 2000
Oct 11-14, 2004 presented by Kimberly L. Tripp
Event Details
 Library Sample Database Backup (1.24 MB)
 Credit Sample Database Backup (48 MB)
 Demo Scripts
 Chicago Pictures

Data Access Best Practices - Immerse yourself in ADO.NET and Data Architectures
Oct 15, 2004 presented by William R. Vaughn
Event Details

 
 
2004 PASS Community Summit
Sep 28 - Oct 1, 2004 - Orlando, Florida
2004 PASS Community Summit
  Presented by PASS, the Professional Association for SQL Server
  Spotlight Presenter 
By Invitation Only, Spotlight Presenters deliver a pre- or post-conference session as well as a longer (90 minutes) presentations at the conference!
 
Pre-conference Session:
- Optimizing Procedural Code – Understanding Logging, Locking and Performance!ì
Tuesday, 28 September 2004, 09:00 - 17:00
Presentation Highlight: The Anatomy of a Data Modification ì
Presentation Addition: Optimizing VLFs ì
Demo Scripts
Session:
- SQL Server 2005 Partitioning: Understanding the Rolling Rangeì
Friday, 1 October 2004, 16:00 - 17:30
ÞAwarded: PASS Community Summit Outstanding Session Award as the top rated session at PASS.
ÞOverall Rating: 4.77 of 5.00
Demo Scripts
 
Microsoft Tech*Ed Asia 2004
September 13-17, 2004 - Kuala Lumpur, Malaysia
http://www.microsoft.com/malaysia/events/teched/
Pre-conference Seminar:
- Designing for Performance - General Database Optimizations, Optimizing Procedural Code and Query Optimizations through Indexingì
Monday, Sept 13, 09:00 to 17:00
 Library Sample Database Backup (1.24MB)
 Demo Scripts
Conference Sessions:
- SQL Server Expert Panel
Tuesday, Sept 14, 17:30 to 18:15
- Logging and Recovery: Understand How Your Transactions Impact System Recovery and Performanceì
Wednesday, Sept 15, 14:15 to 15:30
 Demo Scripts
- Preserving SQL Server Performance through Index Maintenanceì
Thursday, Sept 16, 17:15 to 18:30
 Demo Scripts
- Partitioning - from Past to Present to Future!ì
Friday, Sept 17, 12:00 to 13:15
 Demo Scripts
- Ask the Experts Closing Lunch
Friday, Sept 17, 13:15 to 14:30
 
 
Microsoft Tech*Ed Japan 2004
September 8-10, 2004 - Yokohama, Japan
http://www.microsoft.com/japan/Tech•Ed/
Conference Session:
- SQL Server 2005 (code-named "Yukon") Management Tools
Wednesday, Sept 8, 13:30 to 14:45
Resources:
- Web Data Administrator for IIS
- Cassini Web Server
- Dedicated Forum on SQLJunkies for Web Data Administration
 Demo Scripts
 
 
MSDN Webcast
July 19, 11:00 am to 12:30 pm - Pacific Time
http://msdn.microsoft.com/training/webcasts/
 
Webcast:
- Indexes from Every Angle - Proper Index Maintenance
  Demo Scripts
 
 
Microsoft Tech*Ed Europe 2004
June 29 - July 2, 2004 - Amsterdam, The Netherlands
http://www.microsoft.com/europe/teched/
Pre-conference Seminar:
- Building Data Driven Systems with SQL Server 2000 and SQL Server 2005
Monday, June 28, 2004
 Library Sample Database Backup (1.24MB)
 Demo Scripts

Conference Sessions:
- SQL Server 2000 Indexing Best Practices (DAT348) ì
Wednesday, June 30, 10:15 A.M. to 11:30 A.M.
 Demo Scritps

- Logging and Recovery: Understand How Your Transactions Impact System Recovery and Performance (DAT361) ì
Thursday, July 1, 10:15 A.M. to 11:30 A.M.
 Demo Scritps

 
 
2004 PASS SQL Server Summer Academy
June 23-25, 2004 - Dubrovnik, Croatia
http://sqlpass.org/events/croatia04/
  - All Pictures - in small format (108KB)
  - Group Shot in Front of University Of Dubrovnik (622KB)
  - Watching the Game - Portugal v. UK (780KB)
Pre-conference Session:
- Designing for Performanceì
 Library Sample Database Backup (1.24MB)
 Demo Scripts

Conference Session:
- Logging and Recovery
 Demo Scripts
 
 
MSDN Webcast
June 11, 11:00 am to 12:30 pm - Pacific Time
http://msdn.microsoft.com/training/webcasts/
 
Webcast:
- Indexes from Every Angle - Finding the Right Balance
  Demo Scripts
For a complete list of resources, click here.
 
 
Microsoft Tech*Ed US 2004
May 23-28, 2004 - San Diego, CA
http://www.microsoft.com/seminar/teched2004/default.mspx
Pre-conference Seminar:
- Building Data Driven Systems with SQL Server 2000 and SQL Server 2005 (PRC002)ì
Sunday, May 23, 2004, 10:00 A.M. to 5:00 P.M.
 Library Sample Database Backup (1.24MB)
 Demo Scripts

Conference Sessions:
- Indexing for Performance - Improving Aggregations and Indexed Views (DAT348)ì
Monday, May 24, 5:00 P.M. to 6:15 P.M., Room 8
 demo scritps

- Partitioning - from Past to Present to Future! (DAT350)ì
Tuesday, May 25, 10:45 A.M. to 12:00 noon, Room 8
 demo scritps

- The Clustered Index Debate (DAT351)ì
Wednesday, May 26, 10:15 A.M. to 11:30 A.M., Room 8
 demo scritps

- Preserving SQL Server Performance through Index Maintenance (DAT349)ì
Thursday, May 27, 10:15 A.M. to 11:30 A.M., Room 8
 demo scritps

- Logging and Recovery: Understand How Your Transactions
Impact System Recovery and Performance (DAT361)ì
Thursday, May 27, 3:15 P.M. to 4:30 P.M., Room 8
 demo scritps

- SQL Server 2005: Backup and Restore Engine (DAT324)ì
Thursday, May 27 5:00 P.M. to 6:15 P.M., Room 8
 demo scritps

MVP Community Lounge
Tuesday, May 25, 12:30 P.M. to 2:00 P.M.
Women in Technology Luncheon
Wednesday, May 26, 11:30 A.M. to 2:00 P.M.
Regional Director Community Lounge
Wednesday, May 26, 2:30 P.M. to 4:00 P.M.
 
 
SQL Server Connections
April 18-21, 2004 - Orlando, FL
SQL Server Connections
Presented by Penton Media, Inc. and SQL Server Magazine
Pre-conference Session:
- Indexes from Every Angle - Internals, Performance and Maintenance (SPR301)
Sunday, 18 April 2004, 09:00 - 16:00 (well, 18:00, actually :)
Presentation Highlight: Index Rebuild Concerns ì
Demo Scripts
Sessions:
- Optmizing Stored Procedure Performance (SDB419)
Tuesday, 20 April 2004, 14:00 - 15:15
Presentation Highlight: The Anatomy of a Data Modification ì
Demo Scripts
- Follow the Rabbit - Performance Tuning Q&A (SDB418)
Tuesday, 20 April 2004, 15:45 - 17:00
Demo Scripts
- Database Recovery Models - What Everyone Should Know about Performance, Recovery and Logging (SDB321)
Wednesday, 21 April 2004, 08:00 - 09:15
Demo Scripts
- Indexing for Performance - Finding the Right Balance (SDB420)
Wednesday, 21 April 2004, 09:30 - 10:45
Demo Scripts
 
 
SQLLive!
March 23-27, 2004 - San Francisco, CA
SQLLive!
Presented by Fawcette Technical Publications
Workshop:
- Indexing for Speed - Internals, Statistics, Performance, Maintenance
Demo Scripts
Sessions:
- Understanding Logging and Recovery - What Programmers Always Avoid Until it's too Late!
Demo Scripts
- Indexing for Performance - Finding the Right Balance
Demo Scripts
 
 
Master Class on Performance Tuning
March 8-10, 2004 - Copenhagen, Denmark
Master Class on Performance Tuning
Presented by and Solid Quality Learning.
Demo Scripts
 
 
Master Class on Logging & Recovery
March 12, 2004 - Reykjavik, Iceland
Master Class on Logging & Recovery
Presented by and Solid Quality Learning.
Demo Scripts
 
 
Privacy Policy.
All Rights Reserved.
Copyright 2011 SQLskills.com
 sqlskills.com
Events in Seattle Washington