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. […]
How to Open PowerShell as Administrator
Running PowerShell commands with elevated privileges becomes necessary at times, especially when configuring system settings, installing software, or troubleshooting issues. In this guide, we’ll demo various methods for opening PowerShell as an administrator on different versions of Windows, including how […]
MSSQL DBA and PowerShell Cheat Sheet
This post contains useful scripts for a SQL Server Database Administrator. This page will be updated as more SQL DBA blog posts are published here at DBASco.com. SQL DBA Scripts Diagnostic Scripts for SQL Server: 1. Performance Troubleshooting Script for […]
Using PowerShell to Get Last SQL Failover Time
For SQL Server Database Administrators, tracking the timing of cluster failovers is crucial for maintaining database availability and performance. PowerShell provides a quick way to retrieve the last SQL Server failover time by reading Event Logs, which we will share […]
Windows Terminal: The Best Terminal for Windows (2024)
This article presents an unbiased perspective on the best terminal for Windows in 2024 – Windows Terminal. Whether you’re a Windows Systems Administrator or an MSSQL DBA, having a reliable and feature-rich terminal can contribute to improving efficiency, and overall […]