dbatools is a free, open-source PowerShell module with 600+ commands for SQL Server automation. Manage one instance or thousands with simple, consistent commands.

dbatools is a management tool that runs on your local machine and connects remotely to SQL Server instances. You don’t need to install anything on your SQL Servers themselves - it manages them …

Manages database security by adding users or roles as members to database roles, automating what would otherwise require manual T-SQL commands or SQL Server Management Studio clicks.

Think of it like SSMS: you install it on your local machine and connect remotely to SQL Server instances. dbatools is a PowerShell module that runs on your computer and manages SQL Servers over the …

A free, open-source PowerShell module with 600+ commands that make SQL Server administration simple, powerful, and fun.

Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported. For MFA support, please use Connect-DbaInstance.

Accepts database objects piped from Get-DbaDatabase or other dbatools commands. This allows you to filter databases using Get-DbaDatabase's extensive filtering options before checking encryption keys.

A free, open-source PowerShell module with 600+ commands that make SQL Server administration simple, powerful, and fun.

This function automatically downloads the latest version from GitHub, caches it locally, and installs the procedures into your specified database. You can install the complete toolkit or select specific …

Compares each database's collation against the SQL Server instance's default collation to identify mismatches. Database collation mismatches can cause string comparison issues, join failures, and …