GitHub

A PowerShell script for automated SQL Server database backups with compression, rotation, cloud synchronization, and email notifications.

Vibe coded with minor human intervention using Windsurf AI and Claude 3.7 Sonnet. To set up a scheduled task to run the script daily: Open Task Scheduler. Create a new task. Set the trigger to run ...
Redmond Magazine

PowerShell-Based SQL Server Backups Revisited, Part 2

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...
GitHub

Script DB Permissions In Table - Before Restore.sql

Scripts database-level permissions (Users, Roles, Object-level, Schema-level, and DB-level) and stores them in [dbo].[tbl_DBPermission]. Includes a cleanup mechanism for old history. Parameters: ...