Windows Drive Space Monitoring Using PowerShell Script Purpose: To automate disk space monitoring on a Windows server and send email alerts when free space falls below a defined threshold. This
Windows Drive Space Monitoring Using PowerShell Script Purpose: To automate disk space monitoring on a Windows server and send email alerts when free space falls below a defined threshold. This
Capture and Store SQL Server Database Log File Sizes Objective: This SOP outlines the steps to create a historical log of SQL Server database log file sizes using a SQL
SQL Server Database Mail Account Setup What is Database Mail? Database Mail is a feature in SQL Server that allows the engine to send email notifications to users. It’s commonly
Create SQL Server Operators How to Create SQL Server Operators SQL Server operators are aliases for people or groups that can receive notifications about job statuses, alerts, or system events
Generate and Map Database Users with Roles and Permissions This script is designed to automate the recreation of database users, role assignments, and permissions across a given SQL Server database.
Mirroring Status Notification Email Title SQL Server Database Mirroring Status Notification via Email Purpose This solution is designed to continuously monitor the mirroring status of SQL Server databases and notify
SQL Server Environment Inventory Script This all-in-one SQL Server script gives you a complete overview of your SQL Server instance and host environment. It’s ideal for system documentation, audits, compliance
SQL Server Database Free Space Monitoring and Alert Notification Purpose To proactively monitor free space usage for all user databases across a SQL Server instance and send email alerts when
SQL Server Disk Space Monitoring & Alert Script This T-SQL script checks disk space used by SQL Server data and log files. If any drive has less than 30% free