Aim: To restore a Long-Term Retention (LTR) backup of an Azure SQL Database after the associated SQL Server has been deleted. Microsoft’s documentation states that…
Tag: PowerShell
Following on from my last post, I had decided that automating the step to stop SQL Server would be a better option than relying on…
At home, my test environment for SQL Server runs on a Windows 10 PC. It’s the same PC that I use to do a bunch…
Writing this the week after SQLBits 2023, I’m realising that it’s the type of thing that I probably should have done at the start of…
I came across this error recently on a VM with multiple SQL Server instances installed. Initially a SQL 2016 instance had been installed & some…
I recently encountered this error when attempting to run Add-AzureAccount using Azure PowerShell on a Windows 8.1 machine. The error occurred regardless of whether I…
Aim: Increase logging generated as part of database deployment via Octopus to assist when investigating failed deployments & reviewing successful deployments. In a previous post…