USE Azure Managed Identity to Backup Azure SQL Managed Instance to Blob Storage, NOT SAS Tokens!!

‪@SQLBalls‬ aka, Bradley Ball, walks us through how to use Azure SQL Managed Instance Managed Identity to do COPY ONLY BACKUPS to URL. There's a few reason's to use this instead of SAS tokens, and we go through them. This is a safe and secure way to backup to URL.


How to take secure, on-demand backups on SQL Managed Instance
https://techcommunity.microsoft.com/t...

Chapters
00:00 Introduction
00:51 Layout the Steps to Backup to URL
01:07 Demo - Azure Blob Storage Add Managed Identity
02:04 Demo - Create Managed Identity & Backup Database
02:40 Demo - Make Backup Statement Dynamic
04:34 Demo - Validate Backup
05:05 Demo - Create Azure SQL MI SQL Agent Backup Job
05:48 Demo - Run the Job & Validate the Backup
06:15 Why we Should USE Managed Identity vs. SAS Tokens