Sudo for Windows was announced recently (February 8, 2024) in the Windows Insider Preview Build 26052. This release was a great excuse for me to update my system sharply to see it in action! What the introduction of sudo on […]
Get Most Frequently Executed Queries in SQL Server
As a SQL Server Database Administrator, troubleshooting query performance issues might unfortunately be a common task. Pinpointing the most frequently executed queries is akin to peering into the heartbeat of your system. Understanding which queries are running most often not […]
Get Database FileNames and Paths in SQL Server
This post shares a SQL Script to retrieve filenames, paths and other information for all databases on a SQL Server instance. As well as this, I share SQL for parsing filenames from paths which may be useful to you for […]
Moving Temp DB in SQL Server
A common best practice in SQL Server, is to have your Temp TB files stored on a separate drive, especially ensuring it’s not on the C:\ drive, sharing with the Windows OS. This is because the SQL Server Temp database […]
List all SQL Agent Jobs in SQL Server
Listing SQL Agent jobs on a SQL Server instance is occasioanlly needed for DBAs or ETL Experts to help monitor scheduled jobs that may be critical for a business process or report. In this post, I share SQL scripts that […]
SQL Script to Get CPU Utilization History
Understanding CPU utilization history can sometimes be needed for diagnosing system or performance on a SQL Server instance. By analyzing historical CPU data, you can identify patterns, trends, and anomalies that help improve resource allocation and enhance overall system efficiency. […]