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 […]
Extended Security Updates: No More Freebies
As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our environments. Microsoft has moved away from releasing service packs to releasing just cumulative updates and the occasional hotfixes. These hotfixes may or may not be security related, but it behooves […]
DBCC Clonedatabase and Query Store
Cloning things is all the rage these days…..even Storm Troopers. Anyway, by now, you probably have seen documentation on Query Store and DBCC Clonedatabase. Query Store, introduced in SQL Server 2016, is considered the “black box” or “flight recorder” of queries. It retains a history of executed queries, including run-time […]
SSMS Output Window
In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of databases. SSMS just sat there and waited for some unknown reason and became frustrating. The client eventually […]