|
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)
|
|
|
|
|
| |
| PASS Community Summit Seattle |
| November 2003 - Seattle, WA |
|
PASS Community Summit
Seattle |
|
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: |
| - |
Indexes from Every Angle - Internals, Statistics, Performance & Maintenance, Tuesday, November 11, 8:30am to 4:30pm ì |
|
ÞOverall Rating: 4.85 of 5.00 | Competetive results for the PASS Seattle 2003 workshops were not posted. |
|
|
|
Demo Scripts
|
| Spotlight Session: |
| - |
Designing for Performance - General Database Optimizations, Wednesday, November 12, 4:30 to 5:45 ì |
|
ÞAwarded: PASS Community Summit Outstanding Session Award as the top rated session at PASS. |
|
ÞOverall Rating: 4.83 of 5.00 |
|
Conference Attendees or PASS Members can download the presentation here |
|
Presentation Highlight: The Anatomy of a Data Modification ì |
|
Demo Scripts
|
|
| |
|
| |
| SQL Server Magazine Connections - Fall 2003 |
| October 12-15, 2003 - La Quinta Resort & Club, Palm Springs, CA |
|
SQL Server Magazine Connections |
|
Presented by Penton Media, Inc. and SQL Server Magazine |
|
| Pre-Conference Session: |
| - |
Indexes from Every Angle - Internals, Performance and Maintenance (SPR203)
Sunday, 12 October 2003, 13:00 - 16:00
|
|
Presentation Highlight: Index Rebuild Concerns ì |
|
Demo Scripts
|
| Sessions: |
| - |
Database Recovery Models - What Everyone Should Know about Performance, Recovery and Logging (SDB308)
Monday, 13 October 2003, 11:00 - 12:30
|
|
Presentation Highlight: The Anatomy of a Data Modification ì |
|
Demo Scripts
|
| - |
Indexes from Every Angle - The Clustered Index Debate (SDB310)
Monday, 13 October 2003, 14:00 - 15:15
|
|
Demo Scripts
|
| - |
Optmizing Stored Procedure Performance (SDV436)
Tuesday, 14 October 2003, 08:00 - 09:00
|
|
Demo Scripts
|
| - |
Designing for Performance - General Database Optimizations (SDB309)
Tuesday, 14 October 2003, 09:30 - 10:45
|
|
Demo Scripts |
|
| |
|
| |
| VSLive! |
| September 8-12, 2003 - Orlando, FL |
|
VSLive! 2003 Orlando |
|
Presented by Fawcette Technical Publications |
|
| Workshop: |
| - |
Optimize your SQL Server 2000 Database with Ease
Tuesday, September 9, 9:00 AM - 6:00 PM
|
|
Demo Scripts
|
| Sessions: |
| - |
Indexing for Performance - Finding the Right Balance
Thursday, September 11, 10:30 AM - 11:30 AM
|
|
Demo Scripts
|
| - |
Understanding Logging and Recovery - What Programmers Always Avoid Until it's too Late!
Thursday, September 11, 11:45 AM - 12:45 PM
|
|
Demo Scripts |
|
Changing Recovery Models Slide(s) ì
|
|
| |
|
| |
| SQL Server Magazine Online Webseminar |
| September 2003 |
|
SQL Server Magazine University |
|
Presented by SQL Server Magazine |
|
|
| |
|
| |
| SQL Server Summer Academy |
| July 14-16, 2003 - Dubrovnik, Croatia |
|
SQL Server Summer Academy - Dubrovnik, Croatia |
|
Presented by Microsoft Corporation |
|
| Session: |
| - |
Indexes from Every Angle - Internals, Performance & Maintenance ì
Tuesday, July 15, 14:00 - 17:30
|
|
Demo Scripts
|
|
| |
|
| |
| Microsoft TechEd Barcelona |
| Jun 30 - July 4, 2003 - Barcelona, Spain |
|
Microsoft TechEd Barcelona |
|
Presented by Microsoft Corporation |
|
| Sessions: |
| - |
SQL Server 2000 Tips and Tricks for DBAs and Developers (DAT335) ì
Tuesday, 1 July, 15:15-16:30
|
|
Demo Scripts
|
| - |
Designing for Performance: Structures, Partitioning, Views and Constraints (DBA324) ì
Wednesday, 2 July, 08:30-09:45
|
|
Demo Scripts
|
| - |
Designing for Performance: Optimization with Indexes (DBA328) ì
Wednesday, 2 July, 16:45-18:00
|
|
Demo Scripts
|
| - |
Optimizing Stored Procedure Performance in SQL Server 2000 (DAT402) ì
Thursday, 3 July, 08:30-09:45
|
|
Demo Scripts
|
|
| |
|
| |
| South Sound .Net Users Group |
| June 12, 2003, 7:00 - 8:00 p.m. PT |
|
Presented by South Sound .Net Users Group |
|
| Session: |
| - |
Optimizing Stored Procedure Performance in SQL Server 2000 |
|
Demo Scripts
|
|
| |
|
| |
| Microsoft TechEd USA |
| June 2-6, 2003 - Dallas, TX |
|
Microsoft TechEd USA |
|
Presented by Microsoft Corporation |
|
"Tech Ed Top 20 Presenter" | A Tech Ed Top 20 Presenter is a presenter whose has had a session in the top 20 highest scoring sessions. |
|
|
| Sessions: |
| - |
Optimizing Stored Procedure Performance in SQL Server 2000 ì
Wednesday, June 4, 8:30 AM-9:45 AM
|
|
ÞTech Ed Top 20 Session. |
|
ÞOverall Rating: 8.5 of 9.0 |
|
Demo Scripts
|
| - |
Designing for Performance: Structures, Partitioning, Views and Constraints ì
Wednesday, June 4, 3:15 PM-4:30 PM
|
|
ÞTech Ed Top 20 Session. |
|
ÞOverall Rating: 8.6 of 9.0 |
|
Demo Scripts
|
| - |
SQL Server 2000 Tips and Tricks for DBAs and Developers ì
Thursday, June 5, 8:30 AM-9:45 AM
|
|
ÞTech Ed Top 20 Session. |
|
ÞOverall Rating: 8.6 of 9.0 |
|
Demo Scripts
|
| - |
Designing for Performance: Optimization with Indexes ì
Friday, June 6, 9:00 AM-10:15 AM
|
|
ÞTech Ed Top 20 Session. |
|
ÞOverall Rating: 8.7 of 9.0 |
|
Demo Scripts
|
| - |
Preserving SQL Server 2000 Performance Through Index Maintenance ì
Friday, June 6, 10:45 AM-12:00 PM
|
|
ÞTop Rated Session at Tech Ed. |
|
ÞOverall Rating: 8.9 of 9.0 |
|
Demo Scripts
|
|
| |
|
| |
| SQL Server Magazine Online Webseminar |
| May 16, 2003, 10:00 - 11:00 a.m. PT |
|
SQL Server Magazine University |
|
Presented by SQL Server Magazine |
|
| Session: |
| - |
Indexing for Performance, Part IV - Index Maintenance ì |
|
Buy this archive online. ì |
|
Demo Scripts |
|
Web Seminar Q&A ì |
|
| |
|
| |
| SQL Server Magazine Connections - Spring 2003 |
| May 6-9, 2003 - New Orleans, LA |
|
SQL Server Magazine Connections |
|
Presented by Penton Media, Inc. and SQL Server Magazine |
|
| Pre-Conference Session: |
| - |
Tuning Databases for High Performance on SQL Server 2000. ì
Tuesday, May 6, 9:00am - 4:00pm |
|
Demo Scripts |
| Sessions: |
| - |
The Clustered Index Debate ì
Wednesday, May 7, 8:00 - 9:15am |
|
Demo Scripts |
| - |
Backup/Restore Strategies for VLDBs ì
Thursday, May 8, 8:00 - 9:15am
|
|
Demo Scripts |
| - |
Understand and Optimize Stored Procedure Performance ì
Thursday, May 8, 9:30 - 10:45am
|
|
Demo Scripts |
| - |
Indexes from Every Angle - Indexed Views and Aggregations ì
Friday, May 9, 9:30 - 10:45am
|
|
Demo Scripts |
| - |
The Clustered Index Debate ì
Friday, May 9, 11:15am - 12:30pm (repeat) |
|
| |
|
| |
| SQL Server Magazine Online Webseminar |
| May 2, 2003, 10:00 - 11:00 a.m. PT |
|
SQL Server Magazine University |
|
Presented by SQL Server Magazine |
|
| Session: |
| - |
Indexing for Performance, Part III - Aggregations and Indexed Views ì |
|
Buy this archive online. ì |
|
Demo Scripts |
|
Web Seminar Q&A ì |
|
| |
|
| |
| VSLive! |
| April 2003 - Chicago, IL |
|
Data Access Track at VSLive! 2003
Chicago |
|
Presented by Fawcette Technical Publications |
|
| Sessions: |
| - |
Designing for Performance: General Database Optimizations ì |
|
Demo Scripts |
| Post-Conference Workshop: |
| - |
Build and Maintain High Performance Databases with SQL Server 2000, Thursday,
April 17, 9am to 6pm ì |
|
Demo Scripts |
|
| |
|
| |
| SQL Server Magazine Online Webseminar |
| April 11, 2003, 10:00 - 11:00 a.m. PT |
|
SQL Server Magazine University |
|
Presented by SQL Server Magazine |
|
| Session: |
| - |
Indexing for Performance, Part II - SARGs & Joins ì |
|
Buy this archive online. ì |
|
Demo Scripts |
|
Web Seminar Q&A ì |
|
| |
|
| |
| SQL Server Magazine Online Webseminar |
| April 4, 2003, 10:00 - 11:00 a.m. PT |
|
SQL Server Magazine University |
|
Presented by SQL Server Magazine |
|
| Session: |
| - |
Indexing for Performance, Part I - Overview & Internals ì |
|
Buy this archive online. ì |
|
Demo Scripts |
|
Web Seminar Q&A ì |
|
| |
|
| |
| SQLLive! |
| February 2003 - San Francisco, CA |
|
SQLLive! at VSLive! 2003 San Francisco |
|
Presented by Fawcette Technical Publications |
|
Acting as SQLTrack Manager | Managing the Session List, introducing the Speakers and verifying content to minimize overlap! |
|
|
| Sessions: |
| - |
Designing for Performance: General Database Optimizations ì |
| Post-Conference Workshop: |
| - |
Build and Maintain High Performance Databases with SQL Server 2000, Thursday, September 19, 9am to 6pm ì |
|
Demo Scripts |
|
| |
|
| |
| PASS Community Summit Seattle |
| November 2002 - Seattle, WA |
|
PASS Community Summit
Seattle |
|
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: |
| - |
Recovery with Backup & Restore, Monday, November 18, 8:30am to 4:30pm ì |
|
ÞAwarded the PASS Community Summit Outstanding Seminar Award. |
|
ÞOverall Rating: 4.92 of 5.00 |
|
Demo Scripts |
| Spotlight Session: |
| - |
Understand and Optimize Stored Procedure Performance, Wednesday, November 20, 9:45 to 11:15 ì |
|
ÞOverall Rating: 4.73 of 5.00 |
|
Conference Attendees or PASS Members can download the presentation here |
|
Demo Scripts |
|
| |
|
| |
| SQL Server Magazine LIVE! |
| October 2002 - Orlando, FL |
|
SQL Server Magazine LIVE! |
|
Presented by Penton Media, Inc. and SQL Server Magazine |
|
| Pre-Conference Session: |
| - |
Tuning High Performance SQL Server 2000 Databases, Sunday, October 27 1:00pm to 5:00pm ì |
|
ÞOverall Rating: 3.92 of 4.00 |
|
Demo Scripts |
| Sessions: |
| - |
Indexing for Optimal Performance SAA327 ì |
|
ÞOverall Rating: 3.85 of 4.00 |
|
Demo Scripts |
| - |
Indexed Views SAA328 ì |
|
ÞOverall Rating: 3.91 of 4.00 |
|
Demo Scripts |
| - |
Backup/Restore Strategies for VLDBs SAA329 ì |
|
ÞOverall Rating: 3.91 of 4.00 |
|
Demo Scripts |
|
| |
|
| |
| SQLLive! |
| September 2002 - Orlando, FL |
|
SQLLive! at VSLive! 2002 Orlando
|
|
Presented by Fawcette Technical Publications
|
|
Acting as SQLTrack Manager | Managing the Session List, introducing the Speakers and verifying content to minimize overlap! |
|
 |
| Sessions: |
| - |
Designing for Performance: General Database Optimizations ì |
|
ÞTop rated session of conference: 3.76 of 4.00 |
|
Demo Scripts |
| - |
Special Lunchtime Presentation, September 17: Tips & Tricks and Otherwise Coolstuff-for Administrators! ì |
|
ÞOverall Rating: 3.58 of 4.00 (second highest rated session) |
|
Demo Scripts |
| - |
Special Lunchtime Presentation, September 18: Tips & Tricks and Otherwise Coolstuff-for Developers! ì |
|
ÞOverall Rating: 3.56 of 4.00 (tied for third) |
|
Demo Scripts |
| Post-Conference Workshop: |
| - |
Build and Maintain High Performance Databases with SQL Server 2000, Thursday, September 19, 9am to 6pm ì |
|
Demo Scripts |
|
| |
|
| |
| PASS Regional Seminar Series |
| August 2002 - Las Vegas, NV |
|
PASS Regional Seminar Series |
|
Presented by PASS, the Professional Association for SQL Server |
|
| Workshop: |
| - |
Tuning High Performance SQL Server 2000 Databases ì |
|
Demo Scripts |
|
| |
|
| |
| PASS Regional Seminar Series |
| June 2002 - Chicago, IL |
|
PASS Regional Seminar Series |
|
Presented by PASS, the Professional Association for SQL Server |
|
| Workshop: |
| - |
Tuning High Performance SQL Server 2000 Databases ì |
|
Demo Scripts |
|
| |
|
| |
| SQLLive! |
| April 2002 - Sydney, Australia |
|
SQLLive! at VSLive! 2002 Sydney |
|
Presented by Fawcette Technical Publications |
|
| Sessions: |
| - |
Tune Up Your SQL Server 2000 Databases with Better Indexing ì |
|
ÞTop rated session of conference: 3.82 of 4.00 |
|
Demo Scripts |
| - |
SQL Server 2000: Tips & Tricks and Otherwise CoolStuff ì |
|
ÞOverall Rating: 3.63 of 4.00 |
|
Demo Scripts |
| - |
Optimize Your .NET SQL Server Database ì |
|
ÞOverall Rating: 3.79 of 4.00 |
|
Demo Scripts |
| - |
Optimize Stored Procedure Performance ì |
|
ÞOverall Rating: 3.68 of 4.00 |
|
Demo Scripts |
|
| |
|
| |
| VSLive! 2002 Chicago |
| April 2002 - Chicago, IL |
|
VSLive! 2002 Chicago |
|
Presented by Fawcette Technical Publications |
|
| Sessions: |
| - |
Optimize Your .NET SQL Server Database ì |
|
ÞTop rated session of conference: 3.78 of 4.00 |
|
Demo Scripts |
| Post-Conference Workshop: |
| - |
Build and Maintain High Performance Databases with SQL Server 2000 ì |
|
Demo Scripts |
|
| |
|
| |
| SQLLive! |
| February 2002 - San Francisco, CA |
|
SQLLive! at VSLive! 2002 Sydney |
|
Presented by Fawcette Technical Publications |
|
| Sessions: |
| - |
Tune Up Your SQL Server 2000 Databases with Better Indexing ì |
|
ÞHighest attendance of conference,
Overall Rating: 3.76 of 4.00 |
|
Demo Scripts |
| - |
Index Maintenance: Why & Automation ì |
|
ÞOverall Rating: 3.79 of 4.00 |
|
Demo Scripts |
| - |
SQL Server 2000: Tips & Tricks and Otherwise CoolStuff ì |
|
ÞTop rated session of conference: 3.88 of 4.00 |
|
Demo Scripts |
|
| |
|
| |
| PASS North America |
| January 2002 - Denver, CO |
|
PASS North America |
|
Presented by PASS, the Professional Association for SQL Server North America |
|
Awarded: Best Presentation for "Indexes from Every Angle, Session II" ì |
|
| Pre-conference Session: |
| - |
Achieving High Availability with SQL Server 2000, Monday, January 28, 8:30am to 4:30pm ì |
| Sessions: |
| - |
Indexes from Every Angle, Part I ì |
|
Conference Attendees or PASS Members can download the presentation here |
|
ÞOverall Rating: 4.95 of 5.00 |
|
Demo Scripts |
| - |
Indexes from Every Angle, Part II ì |
|
Conference Attendees or PASS Members can download the presentation here
|
|
ÞHighest Rated/Attended Session at PASS,
Overall Rating: 4.98 of 5.00 |
|
Demo Scripts |
|
| |
|
| |
| PASS-J Conference Japan |
| November 2001 - Tokyo, Japan |
|
Presented by PASS-J |
|
| Sessions: |
| - |
Query Tuning through Better Indexing (BS-A1) |
|
Demo Scripts |
| - |
Achieving High Availability with SQL Server 2000 (BS-A3) |
|
| |
|
| |
| Microsoft TechEd 1998 |
| June 1998 - New Orleans, LA |
|
Presented by Microsoft Corporation |
|
| Session: |
| - |
SQL Server 7.0 Performance Enhancements and Optimizations
|
|
ÞOverall Rating 4.98 of 5.00
|
|
| |
|
| |
| Microsoft TechEd 1996 |
| April 1996 - Los Angeles, CA |
|
Presented by Microsoft Corporation |
|
| Sessions: |
| - |
Designing a Fault Tolerant SQL Server (Part I) |
| - |
Designing a Fault Tolerant SQL Server (Part II) |
|
|
|
|
