3: Managing deployments to different environments in Azure Pipelines

You can manage deployments to multiple environments when you use YAML pipelines in Azure Pipelines. For example, you can make sure that an approval is required before a pipeline deploys to a production environment.

You can use Environments feature in Azure Pipelines to setup these different environments. Afterwards, you can specify a large number of approvals and checks for each environment.

To specify these environments in YAML Pipelines you use deployment jobs.

You can read more about this in a post I wrote called One YAML pipeline for many Azure Synapse environments in Azure DevOps and adapt it for Azure SQL Database.