Creating Azure SQL Database Users Programmatically using Azure DevOps

on YouTube ↗01h 05m

" summary

Automates creation of AAD-contained database users and role memberships by reading a single Excel workbook in source control and running a pipeline that uses Terraform to provision servers, Azure DevOps for CI/CD, Azure Key Vault for secrets, dbatools + PowerShell to run T-SQL as a Service Principal, and a system-assigned SQL Server identity. Pipeline adds/removes hosted-agent firewall rules, requires Directory Readers role on the SPN and SQL identity, enforces the workbook as the truth, and mostly works though demos show Azure-version and env hiccups.

AI-written summary · about

" chapters (7)

1. 0:00Start
2. 2:44Create Azure Sql Database Users
3. 17:51Azure Devops Pipeline
4. 19:20Connect Our Hosted Agent to Our Azure Sql Instance
5. 21:13Deploy the Permissions from the Excel Workbook
6. 37:42Data Validation
7. 1:02:44Lunch Break

" related talks

• 50mA Deep Dive into DevOps Practices with Azure SQLJerry Nixon, Carlos Robles · SQLBits 2024
• 48mConnecting the dots of Azure SQL DevOpsMuazma Zahid · SQLBits 2023
• 01h 09mAzure SQL Database Development Inner and Outer LoopsDrew Skwiers-Koballa · Visual Studio Live! Microsoft HQ 2022
• 40mCreate and Deploy Multi Tenant Applications on Azure with Azure DevOpsBenny Michielsen · DevOps Pro Europe 2019
• 37mAzure DevOps for EveryoneAbdelmajid Aneddame · BlaBlaConf 2021
• 46mLet Azure control your DevOps PipelinesPeter De Tender · PowerShell + DevOps Global Summit 2022
• 46mAutomating Infrastructure as Code with Azure DevOpsErick Moore · Indy Cloud Conf 2020
• 25mEnterprise Deployment to Azure and AWS in Azure DevOpsKyler Middleton · HashiTalks 2020