While looking through past performance talks and presentations I came across this talk done at a BlackBoard.com conference and since it was already in the public domain I thought it worth sharing here.  Keep in mind while the tuning principles are timeless there are some cool new techniques around performance turning and monitoring in SQL 2008+ like Extended Events (XEvents ).  Helping to deliver XEvents was truly a fun time.

image

(click the image above to see the presentation deck)