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. […]
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 […]
SQL Server Script: Disable All SQL Agent Jobs
SQL Server Agent jobs play a crucial role in automating tasks and processes within your SQL Server environment. However, there are instances where you might need to temporarily disable multiple jobs due to maintenance, troubleshooting, or other reasons. In this […]
SQL Server Script: Get Last Backup Dates
Staying informed about the last backup times is crucial for maintaining data integrity and ensuring rapid recovery in case of unexpected incidents. In this blog post, we’ll share a SQL Server script that provides a comprehensive view of the last […]