dbatools is a free PowerShell module with over 100 SQL Server best practice, administration and migration commands included. Currently, other components of SQL Server such as SSRS and SSAS are not supported, but they are part of the overall goal.

Want to help build dbatools? We invite you to join the team.
 

Migration Commands


 

Best Practice Commands


 

General Administration Commands


 

Utils

Connect-DbaSqlServer
Invoke-SqlCmd2
Out-DbaDataTable
Write-DbaDataTable