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 Windows means to us…
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 only shows us the…
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 scripting. Retrieving database file…
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 can grow very large,…
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 list all SQL Server…
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. In this blog post,…
_
Hi, my name is Peter Whyte. I’m an experienced SQL Database Administrator (DBA) & Blogger, working remotely from home in Edinburgh, Scotland.
I help maintain High Availability SQL Server database environments, troubleshoot issues, and optimize performance within my role as a Site Reliability Engineer (SRE) at GoDaddy. This blog includes a lot of information and skills required working as a SQL Server DBA.