Microsoft continues to expand the Azure ecosystem rapidly. One of the most recent delivered improvements was Azure SQL Database Serverless option. The new serverless model, which is currently in public preview, provides a compute tier for a single database that scales dynamically with the workload. This new compute tier […]
Azure SQL DB Failover Group Orphaned Users
I have a client that resides in the Azure data platform arena, focusing mainly on Platform as a Service (PaaS) and Azure SQL DB. They have a decent landscape of Azure resources and currently utilize failover groups within SQL DB to facilitate high availability. Under the covers, failover groups are […]
Restoring a Database from Azure
In a previous post, I described how you can use Azure storage to store SQL Server database backup files. This flexible option offers the ability to get your critical backups off site and in certain regions, they could be configured to be automatically redundant to a secondary region. Having backups […]
Adding Azure Virtual Machine Boot Diagnostics
A couple of weeks ago, I blogged about boot diagnostics and how they can help you troubleshoot issues when virtual machines won’t start. But what if you selected to disabled boot diagnostics when the virtual machine was created? Can you go back and retro-actively add them back? Yes, Virginia, yes […]