powershelldba.de
REF: PSDB-CTRL-2026-13 · REV 3 SCOPE: SQL Server 2016–2022 STATUS: VERIFIED IN PRODUCTION
Control report

SQL Server automation, built for the audit you already have to pass.

Eleven PowerShell modules for banks, insurers, and other regulated environments — each one documents its own audit trail, access control, and rollback path, so you're not building that evidence by hand afterward.

VERIFIED · IN PRODUCTION BANKS · INSURERS · ENTERPRISE 11 / 11 MODULES CONTROLLED
Design basis

Three control objectives, applied to every module.

These aren't marketing claims — they're the criteria each module was reviewed against before it shipped.

CO-1

Every action is logged

Audit trail and documentation are generated as part of the run, not reconstructed afterward from memory.

CO-2

Access is time-boxed

Elevated rights — temporary sysadmin, AD sync — expire automatically and are revoked without a follow-up ticket.

CO-3

Every run can be undone

Migrations, upgrades, and partitioning changes ship with a rollback path, tested before the forward path is.

Control matrix

What each module is responsible for.

A plain accounting of which controls apply where — read it the way your auditor will.

Module Audit trail Access control Idempotent Rollback path
sqmSQLTool Core engine · 132 commands
SQL Server Setup Standardized installs
AlwaysOn Manager Availability groups
SQL Migration Cross-domain migration
Inplace Upgrade Backup / uninstall / restore
Partitioning Sliding-window & archive cutover
Deadlock Collector Extended Events analysis
Operations Manager Central monitoring
SSRS Deployment Report & datasource rollout
Report Server Check SSRS validation
SSIS Analyzer Package audit & dependency map
Track record

Verified where an audit finding isn't an option.

132
Commands
11
Modules
3
Control objectives
100%
Open source

Request the module you need first.

Start with sqmSQLTool — every other module is built on it.