powershell

Ever since my post about automated deployments of Azure VMs with SQL Server, I’ve been pondering on how to pick the best locations and to understand what exactly it is under the hood that you actually use with PowerShell. In a nutshell, Azure follows a structure called the Azure Resource Manager (ARM). Unfortunately, ARM is not human-readable, so you need to a tool to be efficient in using it. There are quite some tools available, and from Microsoft, there is Azure Bicep, Azure CLI and Azure PowerShell....

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....