Category: SQLServer

SQL Server Login & Permission Audit Report Using Database Mail Overview Managing and reviewing user access is a critical part of database administration and information security. Organizations regularly perform Internal

Overview This solution implements SQL Server Audit to provide comprehensive monitoring of privileged activities, security changes, login activity, database modifications, permission changes, backup operations, and audit configuration changes. Audit records

  SQL Server Audit and Security Alerting for Privileged Login Activities Purpose This solution implements a Server-Level DDL Trigger in SQL Server to monitor privileged login-related activities in real time.

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.