Using Azure Pipelines for Azure SQL Deployments | Data Exposed

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:    • Getting Started with DevOps for Azure SQL ...  

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: docs.microsoft.com/en-us/sql/tools/sqlpackage-down…
Azure PowerShell task: docs.microsoft.com/en-us/azure/devops/pipelines/ta…
Github- SqlAzureDacpacDeploymentV1: github.com/Microsoft/azure-pipelines-tasks/tree/ma…
Azure SQL Database Deployment task: docs.microsoft.com/en-us/azure/devops/pipelines/ta…
Github - Virtual Environments: github.com/actions/virtual-environments/blob/maste…
Add & use variable groups: docs.microsoft.com/en-us/azure/devops/pipelines/li…
Multi-stage pipelines user experience: docs.microsoft.com/en-us/azure/devops/pipelines/ge…
Github - SqlDacpacDeploymentOnMachineGroupV0: github.com/microsoft/azure-pipelines-tasks/tree/ma…

📌 Let's connect:
Twitter: Arvind Shyamsundar, twitter.com/arvisam
Twitter: Anna Hoffman, twitter.com/AnalyticAnna
Twitter: AzureSQL, aka.ms/azuresqltw

🔴 To check out even more Data Exposed episodes, see our playlist: aka.ms/dataexposedyt

🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt

#AzurePipelines #AzureSQLDeployments #AzureSQL