Performance

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…


Data Storage Internals

Wrapping up my week of Query Optimization page recommendations and while SQLity.NET  does have a lot of information on Query Optimization, it is an older series…