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 […]
How to Check SQL Server Versions
As Database Administrators (DBAs), safeguarding the security of our SQL Server instances is paramount. Regular monthly patching is a critical practice, especially for Windows servers, to ensure a secure database environment. In this guide, we’ll explore methods on how to […]
SQL Server Scripts to Backup Databases
Ensuring regular SQL Server backups are happening is a crucial aspect of maintaining data integrity and ensuring business continuity. In this article, we introduce two scripts designed to generate SQL commands, each catering to specific database backup scenarios: – Generate […]
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 […]