SQLBits 2020

Life Hacks: dbatools edition

dbatools is an open source PowerShell module. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.

dbatools is an open source PowerShell module with over 500 commands to assist you with managing your SQL Server estate. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.

This session’s life hacks will include, among others:

  • Automate testing of your SQL Server backups
  • Mask sensitive data in your non production environments
  • Easily migrate databases, logins, etc. between servers
  • Test your environment for best practices
  • Export/back up server configurations