This post was first published for my employer, OneDigit AG, here. dbatools really has the ability to change a DBAs work life. It is a free, very powerful and feature rich open source PowerShell module that offers you 550+ commands that allows you to take backups, restore them or just do a lot in SQL Server administration that you would need SSMS and some work for. With dbatools, you can do many tasks more and that with just a few lines of code....
If you’ve installed SQL Server Management Studio (SSMS) recently, chances are that you’ve noticed that Azure Data Studio (ADS) was installed too. Since SSMS Version 18.7, ADS gets installed alongside with SSMS by default. But you might not be familiar with ADS. What is it and how does it set apart from SSMS? And how to install SSMS alone? Introduction ADS is a free, open source and cross-platform SQL code editor with built-in IntelliSense that is also able to manage SQL Server in Azure, so just this description alone sets it quite apart from SSMS....