Advanced Azure DevOps With Containers and Pipeline As Code
summary
Shows how to run Azure DevOps YAML pipeline as code that builds a DACPAC, publishes it as an artifact, then spins up four parallel sidecar containers running SQL Server on Ubuntu agents, each mounted to its own seed Docker volume clone, deploys the DACPAC to each, enables CLR, runs distinct tSQLt tests (one intentionally fails), and downloads and merges XML test results to fail the pipeline if any test fails. Templates and artifact publish/download are used to reuse steps.
AI-written summary · about
chapters (15)
- 0:00Introduction
- 0:40Chris Adkin
- 1:44Agenda
- 5:05CI Pipelines
- 7:23Continuous Delivery
- 8:14SQL Server
- 9:58Build Environment
- 15:07Pipeline Jobs
- 16:58Storage
- 17:19Format
- 17:37Template
- 17:55Artifacts
- 19:18Merge test results
- 19:43Resources
- 21:37Questions
related talks
48mConnecting the dots of Azure SQL DevOps
01h 09mAzure SQL Database Development Inner and Outer Loops
50mA Deep Dive into DevOps Practices with Azure SQL
49mUnveiling the magic of CI/CD for SQL Server using GitHub Actions
49mModern CI/CD Pipeline with Azure DevOps
53mContinuous Delivery with Azure Web Apps
46mAutomating Infrastructure as Code with Azure DevOps
45mUsing Azure Devops to Build and Deploy a Docker Image to Azure