dbatools

✔ SQL Server Environmental Validation

The documentation for dbatools module. Issues with command doc and bugs should be reported to dataplat/dbatools.

Resources for the SQL Collaborative

PowerShell SQL Server Admin Toolset — 165+ Funktionen fuer DBA-Automatisierung auf Basis von dbaTools

DbaClientX is a small PowerShell module that allows running queries against SQL Server, PostgreSQL, MySQL, SQLite, and Oracle

a nice lil tutorial to help with useful tutorials

🚀 A curated collection of SQL Server DBA scripts for monitoring, performance tuning, backup/restore, Always On AG, security, and troubleshooting, plus links to essential community tools.

An ansible collection that wraps the dbatools powershell module. Based upon lowlydba.sqlserver

Automate end-to-end SQL Server installation and configuration on Windows using Ansible with WinRM, dbatools, Ola Hallengren, and Brent Ozar tooling.

PowerShell WinForms-Tool fuer zweiphasige SQL Server Migrationen in getrennten Netzwerken

Operational reference documentation for SQL Server — performance tuning, disaster recovery, clustering, security hardening, and monitoring.

SQL Server DBA lab covering backup and recovery, log shipping, automation, performance monitoring, troubleshooting, and restore validation.

SQL Scripts and things I've accumulated.

PowerShell for safe SQL Server Always On failover and rolling patching - pre-flight validation including an AG listener network gate, prepare/resume across reboots, AWS/GCP/Azure driver updates. 9 exported commands.

PowerShell module complementing dbatools - search SQL Server instances for a string across SQL modules, Agent jobs, and linked servers.

A PowerShell-based SQL Server monthly patching runbook built as a Jupyter notebook for Azure Data Studio. Automates patch compliance checks, service management, CU downloads, standalone and FCI patching, post-patch verification, and SQL Agent job execution using dbatools and kbupdate.

Azure Bicep deployment for creating a lab of SQL Server

Personal reference library of dbaTools PowerShell commands for SQL Server administration — covering server build validation, instance inventory, HA/replication checks, database maintenance, and cross-instance migration.

SQL Automation Suite — overview of the tools for SQL Server installation, administration, high availability and migration

PowerShell reliability toolkit for SQL Server - backup recoverability, restore-chain validation, and Query Store regression detection. Built on dbatools.