Secure Azure SQL Server Backups Using Managed Identities

Posted on April 23, 2025 by blobeater

I do believe most people know about the ability to backup your SQL server databases to URL (from Azure VMs). If you recall you would use the storage key ( ideally not) or a SAS token, from there you would create a SQL credential that is bound to the SAS token (as a secret). Lots of moving parts especially when it comes to rotation time. So now, if you are on the newer versions of SQL server (SQL Server 2022 Cumulative Update 17 ) start thinking about backups via managed identities.

Continue reading →

Microsoft Entra Authentication for Azure PostgreSQL

Posted on February 3, 2025 by blobeater

Straight from Microsoft’s documentation “Microsoft Entra authentication is a mechanism of connecting to Azure Database for PostgreSQL flexible server by using identities defined in Microsoft Entra ID. With Microsoft Entra authentication, you can manage database user identities and other Microsoft services in a central location, which simplifies permission management.”

Continue reading →

Minimize Downtime with SQL MI Disaster Recovery

Posted on October 18, 2024 by blobeater

I speak to many people who use cloud technologies, especially database tech and how little consideration they give to their MISSION CRITICAL Databases that run in the cloud and its Disaster Recovery process. When I say mission critical, I mean its relative to the company I am talking to, so what might be a tier 1 app for you might not be the case for Bob.

Continue reading →