Infra Module: Azure SQL DB #1231
Description
Description
Our goal is to create a Azure SQL DB infrastructure deployment module, that takes the best practices of all our existing samples and simplifies the infra deployment. We want to take into account:
- Optionality on permissions (Entra Global Admin vs Azure Contributor)
- Storage Accounts, Security Groups, if applicable
- Service Principal vs Managed Identity permissioning
- Take into account SQL Server tooling
Our audience/persona are software and data engineers hoping to easily deploy the necessary compute and storage to set up a Azure SQL DB deployment.
Acceptance Criteria
- Must use a devcontainer
- Spike on AZD CLI
- Spike on Deployment Stacks
- IaC in Bicep or Terraform (consider using AVMs if they exist)
- Testing approach documented