In the on-prem world, or when we’re working with SQL Servers on VMs, wherever they might live it was pretty easy with dbatools to run a query against all the databases, collect some info and collate it into one record set. This used to work with Azure SQL Instances too – but Azure auth, or cloud auth in general is hard and recently the
Connect-DbaInstancecommand needed to change to make it more reliable.So, this is a quick post to cover how we can still manage this.
Click through to see how.