Presentations
Below are SQL Server presentations I have made at various user group meetings and conferences. Feel free to download for personal use. Be sure to download the latest version of my presentations, as I regularly update them.
SQLServerCentral.com Webinar
(July 9, 2012)
Using SQL Storage Compress in the Real World (PDF, 370 KB)
www.sqlservercentral.com
SQLServerCentral.com Webinar
(June 12, 2012)
Proactive Data Growth Management: Reducing Your Storage Footprint (PDF, 300 KB)
www.sqlservercentral.com
SQL Rally
Dallas, TX (May 8-11, 2012)
How to Perform a SQL Server Health Check (PDF, 1 MB)
How to Monitor Your SQL Server for Performance and High Availability (PDF, 250 KB)www.sqlrally.com
SQL Server Connections
Las Vegas, NV (March 26-29, 2012)
How to Defragment Indexes for Peak Performance (PDF, 1 MB)
How to Configure Database Options for Optimal Performance (PDF, 1 MB)www.devconnections.com
Code PaLOUsa 2012
Lousiville, KY (March 16, 2012)
Introduction to SQL Trace (PDF, 700 KB)
www.codepalousa.com
St. Louis SQL Server Users Group
St. Louis, MO (December 13, 2011)
How to Optimize TEMPDB Performance (PDF, 1 MB)
Inside the SQL Server Transaction Log (PDF, 1 MB)www.stlssug.org
Baltimore SQL Server Users Group
Baltimore, MD (December 12, 2011)
Introduction to SQL Trace (PDF, 700 KB)
www.bssug.org
SQL Server Connections
Las Vegas, NV (November 1-3, 2011)
Top 10 Database Maintenance Best Practices (PDF, 900 KB)
Using SQL Server Compresson to Boost Database Performance (PDF, 800 KB)www.devconnections.com
2011 PASS Summit
Seattle, WA (October 14, 2011)
Inside the SQL Server Transaction Log (PDF, 600 KB)
www.sqlpass.org
Oregon SQL Saturday
Portland, OR (October 8, 2011)
Best Practices Every SQL Server DBA Must Know (PDF, 1.2 MB)
www.sqlsaturday.com
Omaha SQL Saturday
Omaha, NE (August 27, 2011)
Best Practices Every SQL Server DBA Must Know (PDF, 800KB)
www.sqlsaturday.com
Red Gate Webinar
Online (August 23, 2011)
Using SQL Monitor 2.3 in the Real World (PDF,1 MB)
www.red-gate.com
devLINK
Chattanooga, TN (August 17-19, 2011)
Inside the SQL Server Transaction Log (PDF,1 MB)
www.devlink.net
San Francisco SQL Server Users Group
San Francisco, CA (June 8, 2011)
How to Perform a SQL Server Health Check (PDF, 900KB)
www.baadd.org
SQLBits
Brighton, England (April 7-9, 2011)
Back From the Dead–How to Restore a Server in 60 Minutes or Less (PDF, 700KB)
Monitoring the SQLServerCentral.com & Simple-Talk.com Cluster (PDF, 700KB)www.sqlbits.com
SQL Server Connections
Orlando, FL (March 28-30, 2011)
Database Maintenance Essentials (PDF, 1 MB)
How to Optimize TEMPDB Performance (PDF, 1.1MB)
Introduction to SQL Trace (ZIP, 600 KB)www.devconnections.com
SQL Server Monitoring Webinar
Online Webinar (November 16, 2010)
Monitoring SQL Server (PDF, 800 KB)
www.thefutureofmonitoring.com
2010 SQLPass Community Summit
Seattle, WA (November 8-12, 2010)
How to Optimize TEMPDB Performance (PDF, 700 KB)
How to Get the Most Out of the Maintenance Plan Wizard (PDF, 500 KB)www.sqlpass.org
SQL Server Connections
Las Vegas, NV (November 2-4, 2010)
How to Perform a SQL Server Health Check (PDF, 700 KB)
How to Analyze Performance Monitor Data Using PAL (PDF, 500 KB)
Identifying SQL Server Performance Problems Using SQL Trace (PDF, 700 KB)www.devconnections.com
SQLBits
York, England (October 1, 2010)
How to Perform a SQL Server Health Check (PDF, 700 KB)
Monitoring SQL Server (PDF, 850 KB)www.sqlbits.com
24 Hours of PASS
Online Presentation (September 16, 2010)
Automate Your Database Maintenance Using Ola Hallengren’s Free Script (PDF, 230 KB)
www.sqlpass.org
Baton Rouge SQL Saturday
Baton Rouge, LA (August 14, 2010)
Database Maintenance Essentials (PDF, 1.4MB)
Essential DBA Skills: Best Practices Every SQL Server DBA Must Know (PDF, 1MB)www.sqlsaturday.com
St. Louis SQL Server Users Group
St. Louis, MO (August 11, 2010)
Identifying SQL Server Performance Problems Using SQL Trace (ZIP, 800KB)
Essential DBA Skills: Introduction to Graphical Execution Plans (ZIP, 700KB)www.stlssug.org
devLINK Technical Conference
Nashville, TN (August 5-7, 2010)
Identifying SQL Server Performance Problems Using SQL Trace (ZIP, 600KB)
How and When to Implement Indexed Views (ZIP, 800KB)
Essential DBA Skills: Introduction to Graphical Execution Plans (ZIP, 700KB)www.devlink.net
Hawaii .NET Users Group
Honolulu, HI (July 21, 2010)
Essential DBA Skills: Best Practices Every SQL Server Developer Should Know to Administer Their SQL Servers (PDF, 700KB)
www.hawaiidotnet.org
Pensacola SQL Saturday
Pensacola, FL (June 5, 2010)
Best Practices Every SQL Server DBA Should Know (PDF, 700KB)
www.SQLSaturday.com
IndyTechFest
Indianopolis, IN (May 22, 2010)
Database Maintenance Essentials (PDF, 500KB)
www.IndyTechFest.com
North Texas SQL Server Users Group
Dallas, TX (May 20, 2010)
How to Analyze Performance Monitor Data Using PAL (PDF, 500KB)
northtexas.sqlpass.org
24 Hours of PASS
Online Presentation (May 19, 2010)
Manage Your DBA Career: Don’t Let It Manage You (PDF, 400KB)
www.sqlpass.org
Chicago SQLSaturday
Chicago, IL (April 17, 2010)
Introduction to Graphical Execution Plans in SQL Server 2005/2008 (PDF, 1MB)
How and When to Implement Indexed Views (PDF, 900KB)www.sqlsaturday.com
Chicago SQL Server Users Group
Chicago, IL (April 15, 2010)
How to Optimize tempdb Performance (PDF, 1MB)
chicago.sqlpass.org
Atlanta Microsoft Database Forum
Atlanta, GA (April 12, 2010)
How to Become an Exceptional DBA (PDF, 800KB)
www.atlantamdf.com
Baltimore SQL Server Users Group
Baltimore, MD (April 5, 2010)
How to Use the SQL Server 2008 Performance Data Collector to Analyze Query Performance (PDF, 600KB)
www.bssug.org
SQL Server Social Group
Cambridge, England (March 24, 2010)
How to Use the SQL Server 2008 Performance Data Collector to Analyze Query Performance (PDF, 600KB)
www.sqlsocial.com
SQL Lunch
Online Webinar (February 25, 2010)
Introduction to SQL Server Graphical Execution Plans (PDF, 1MB)
www.sqllunch.com
Pragmatic Works February SQL Server 101 Series
Online Webinar (February 23, 2010)
How to be an Exceptional DBA (PDF, 800KB)
PragmaticWorks.com
Olympia Area SQL Server Users Group
Tumwater, WA (February 11, 2010)
How and When to Use Indexed Views (PDF, 1.6MB)
olympia.sqlpass.org
Oregan SQL Develpers User Group
Portland, OR (February 10, 2010)
Introduction to Graphical Execution Plans (PDF, 1.4MB)
osql-d.sqlpass.org
Fall 2009 SQL Server Connections
Las Vegas, NV (November 12, 2009)
Free Software for SQL Server DBAs (PDF, 700KB)
www.devconnections.com
Fall 2009 SQL Server Connections
Las Vegas, NV (November 11, 2009)
Optimizing tempdb Performance (PDF, 1MB)
Introducing the SQL Server 2008 Data Collector (PDF, 800KB)www.devconnections.com
2009 PASS Community Summit
Seattle, WA (November 4, 2009)
Identifying Performance Problems With SQL Trace (PDF, 300KB)
Demo T-SQL Files (ZIP, 5K)www.sqlpass.org
2009 PASS Community Summit
Seattle, WA (November 3, 2009)
Mange Your DBA Career, Don’t Let it Manage You (PDF, 400K)
www.sqlpass.org
Dunedin .NET Users Group
Dunedin, New Zealand (October 22, 2009)
DBA 101: Best Practices All DBAs Should Know (PDF, 800K)
www.dot.net.nz/UserGroupPages/DunedinNET.aspx
Christchurch .NET Users Group
Christchurch, New Zealand (October 21, 2009)
How to Become an Exceptional DBA (PDF, 700K)
www.dot.net.nz/UserGroupPages/ChristchurchNET.aspx
Wellington SQL Server Users Group
Wellington, New Zealand (October 20, 2009)
Optimizing tempd Performance (PDF, 1MB)
wellington.sqlpass.org
Auckland SQL Server Users Group
Auckland, New Zealand (October 19, 2009)
DBA 101: Best Practices All DBAs Should Know (PDF, 800K)
www.aucklandsql.com
Sydney SQL Server Users Group
Sydney, Australia (October 13, 2009)
Getting the Most Out of the SQL Server 2005/2008 Profiler (PDF, 2MB)
www.sqlserver.org.au
Melbourne CBD SQL PASS Chapter
Melbourne, Australia (October 12, 2009)
Getting the Most Out of the SQL Server 2005/2008 Profiler (PDF, 2MB)
melbourne.sqlpass.org
SQL Down Under Code Camp
Wagga Wagga, Australia (October 10-11, 2009)
DBA 101: Best Practices All DBAs Should Know (PDF, 800K)
Introducing the SQL Server 2008 Data Collector (PDF, 800K)www.sqldownunder.com/SDUCodeCamp/tabid/100/Default.aspx
Newcastle Coders Group
Newcastle, Australia (October 7, 2009)
Getting the Most Out of the SQL Server 2005/2008 Profiler (PDF, 2MB)
www.ncg.asn.au
Perth SQL Server Users Group
Perth, Australia (October 2, 2009)
Introducing the SQL Server 2008 Performance Data Collector (PDF, 800K)
www.perthsqlserver.com
Perth .NET Users Group
Perth, Australia (October 1, 2009)
Introduction to How to Interpret SQL Server Execution Plans (PDF, 800K)
www.perthdotnet.org
24 Hours of PASS
Virtual Conference (September 1, 2009)
Using SQLDiag.exe to Troubleshoot SQL Server Problems (PDF, 350KB)
www.sqlpass.org
devLINK Technical Conference
Nashville, TN (August 13-15, 2009)
Mastering the SQL Server 2008 Data Collector (PDF, 3 MB)
Getting the Most Out of the SQL Server 2005/2008 Profiler (PDF, 3MB)
Database Maintenance Optimization Strategies for the Database Professional (PDF, 2MB)www.devlink.net

