✔ 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

a nice lil tutorial to help with useful tutorials

DbaClientX is a small PowerShell module that allows running queries against Sql Server

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

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.

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.

SQL Scripts and things I've accumulated.

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