Update: This post was originally published on March 8th, 2019 and a lot of things have changed over the last 2-3 years. Lots of things. However, ironically, I’m headed off to SQL Bits again for their 2022 Conference and thought it’d be a good time to update this list of […]
Microsoft Update Catalog
In today’s world of database administrations, there are a plethora of tools and resources that can be available to utilize to help solve problems, such as performance tuning, configuration, and many others. Some are third party tools, some are free, and some are provided by the vendor themselves. Regardless of […]
T-SQL Tuesday #91 – Start Talking
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T) and is not limited to just things around the SQL Server database engine. Each month a blogger hosts the event and anybody who wants to contribute can write a post about that […]
Quick Script: Index Sizes
In the world of performance monitoring, there a number of ways to identify problems. Each method is different and usually, neither way is better than another. Over the years, I’ve started look at metrics around non-clustered indexes to help find problems. Once while working at a client site, I was […]