Using Azure Pipelines for Azure SQL Deployments | Data Exposed

From the creator

Many organizations have complex security and deployment requirements. In the second of this two-part series with Arvind Shyamsundar, we show you how to leverage Azure Pipelines features like multi-stage pipelines and AZ CLI support, to securely deploy an Azure SQL Server and Database into a private VNET in Azure. To learn how to get started with DevOps for Azure SQL, watch part one: https://youtu.be/j7OnxOz7YDY?WT.mc_id=dataexposed-c9-niner 0:00 Introduction 1:00 Changed-based approach 1:35 State-based approach 3:30 Demo 8:23 Demo Background 12:07 Back to Demo 19:11 Demo: pipeline execution 22:45 Key takeaways 24:50 Getting started ✔️ Resources: Download and install sqlpackage: https://docs.microsoft.com/en-us/sql/tools/sqlpackage-download?WT.mc_id=dataexposed-c9-niner Azure PowerShell task: https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/deploy/azure-powershell?WT.mc_id=dataexposed-c9-niner Github- SqlAzureDacpacDeploymentV1: https://github.com/Microsoft/azure-pipelines-tasks/tree/master/Tasks/SqlAzureDacpacDeploymentV1?WT.mc_id=dataexposed-c9-niner Azure SQL Database Deployment task: https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/deploy/sql-azure-dacpac-deployment?WT.mc_id=dataexposed-c9-niner Github - Virtual Environments: https://github.com/actions/virtual-environments/blob/master/images/win/Windows2019-Readme.md?WT.mc_id=dataexposed-c9-niner Add & use variable groups: https://docs.microsoft.com/en-us/azure/devops/pipelines/library/variabl

Published 2020-12-10 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.