SpecTECHular recordings
Recordings are now available from the October 12th New Horizons SpecTECHular event. You can find my session on “The Vocabulary of Performance Tuning” here.
Optimization
Automatic Tuning in SQL 2017
Automatic tuning in SQL Server 2017, notifies you whenever a potential performance issue is detected, and lets you apply corrective actions, or lets the Database…
October – IndyPass
Identifying and Fixing Parameter Sniffing (Tuesday October 18th, 2016 – 6:00 pm) Presenter: Brent Ozar from Brent Ozar Unlimited You swear nothing changed – but…
FREE Plan Explorer
SQL Sentry is introducing the new unified Plan Explorer! This edition includes all features of Plan Explorer PRO, plus two new and incredibly powerful features:…
The PROCESS of Queries
If you can’t make it to a SQL Saturday to see my presentation on The PROCESS of Queries? That is OK. Because I made it…
Wait Type Library
Wow, Paul Randal has put together probably the most comprehensive library of all wait types and latch classes that have existed since SQL Server 2005….
Wait Statistics Guide
Wait a minute… How could I have a week of favorite performance tuning resources without including one of my favorites. That’s right we are visiting…
Query Optimization Papers
When talking about SQL Performance and Optimization, I always like to point to this excellent post by Benjamin Nevarez where he discusses which sources he used to…
Working with Wait Statistics
A list of favorite blog posts would not be complete without a trip over to SQL Skills and Paul Randal where he asks,”How many times…