How about a free suite of over 500 tools for SQL Server best practices, administration, development, and migration? Richard talks to Rob Sewell about the ever-growing dbatools PowerShell module. While its origins are in migrating SQL Server databases from one environment (and version) to another, the range of capabilities is extensive. Rob talks about the power of repeatability when attempting to do these potentially complex tasks - which is best served by scripting. But why write the scripts when they already exist? The conversation also digs into learning as a DBA, including getting involved with conferences like SQLBits!
Links:
- dbatools
- dbachecks
- dbatools on PowerShell Gallery
- SQL Server Management Objects
- dbatools in a month of lunches
- RunAs at SQL Bits!
Recorded January 10, 2023