Performance

SQL Saturday Atlanta 2018

Wow! Over 900 people are registered for the Atlanta SQL Saturday this weekend. Remember there are 10 tracks and over 70 sessions. But if you…


SQL Saturday Cleveland 2018

Returning back to Cleveland the weekend for another SQL Saturday. I am presenting a brand new session on “The Vocabulary of Performance Tuning”.  This session…


Free SQL Performance Scripts

This is why I love Twitter to keep up with the #SQLFamily. A question was asked by Chrissy LeMaire about scripts that Microsoft PFEs use…


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…


Get Started with Query Store

One of the newest features that everyone is talking about with Azure SQL Database or SQL Server 2016 is the Query Store which provides a mechanism of capturing…


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:…


SQL Server Startup Options

Startup options designate certain file locations needed during startup, and specify some server wide conditions. Most users do not need to specify startup options unless…


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…