Connections 2011

Brad’s Sure DBA Checklist

Presentations

LuckyConnections

PerformanceChecklist

Books

SQL Server MVP Deep Dives, Volume 2
Microsoft® SQL Server® 2008 Internals (Pro – Developer)
Inside Microsoft® SQL Server® 2008: T-SQL Programming (Pro-Developer)

Query Performance Tuning: Start To Finish

Gathering Metrics

• Microsoft White Paper: Performance Tuning Waits and Queues.doc
  http://technet.microsoft.com/en-us/library/cc966413.aspx
• Microsoft White Paper: Troubleshooting Performance Problems in SQL Server 2008
  http://msdn.microsoft.com/en-us/library/dd672789.aspx
• Brad McGehee Mastering SQL Server Profiler
• Louis Davidson & Tim Ford’s Performance Tuning with SQL Server Dynamic Management Views (High Performance SQL Server)

Optimizer

• Dr. Dewitt’s Key Note, PASS Summit 2010
  http://www.facebook.com/l.php?u=http%3A%2F%2Fwww.slideshare.net%2FGraySystemsLab%2Fpass-summit-2010-keynote-david-dewitt&h=306f5
• Itzik Ben-Gan Inside Inside Microsoft SQL Server 2008: T-SQL Querying
• Kalen Delaney Microsoft SQL Server 2008 Internals (Pro – Developer)

Start to Finish Slides

Start to Finish Code

2 Comments

• 

  By Karl, April 27, 2012 @ 11:19 am

  Hi Grant

  I missed your presentation yesterday on Execution Plans: A Deep Dive. Was the session recorded? If so, please let me know the recorded link or send me the slides.

  Thanks
• 

  By Grant Fritchey, April 27, 2012 @ 1:02 pm

  Try this page http://www.scarydba.com/resources/

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment