End-to-End Database DevOps: CI/CD Pipelines for Azure SQL With Torsten Strauss

Implementing Database DevOps remains one of the most challenging aspects of modern CI/CD workflows. This session demonstrates how to build a fully automated YAML-based Azure DevOps pipeline for continuous integration and controlled deployment of Azure SQL Databases. The process starts with compiling the database project into a DACPAC. Based on the generated DACPAC, the pipeline creates a deployment report showing the schema changes that would be applied to the target Azure SQL Database and publishes it directly to the pull request, enabling transparent review and approval before any deployment occurs. Both the DACPAC and the deployment report are published as versioned artifacts, providing a reliable foundation for auditing, traceability, and controlled release management. After approval, the pipeline deploys the validated changes to the target environment with a strong focus on consistency, traceability, and reduced deployment risk. For production deployments, the pull request is automatically tagged with deployment metadata, creating a clear link between source changes, reviewed deployment reports, released artifacts, and the production state. To promote scalability and standardization, the solution uses reusable YAML templates stored in a central repository, making the approach easy to adopt across teams, projects, and environments. By the end of this session, attendees will understand how to design repeatable, low-risk, and fully automated database deployments that integrate seamlessly into existing Azure DevOps workflows while supporting versioning, auditing, and enterprise-grade change management. Speaker's Bio: Torsten Strauß (MVP) is the CEO of inside-sqlserver and Principal Microsoft SQL Consultant at Sarpedon Quality Lab. He is a multi-certified Microsoft expert with a strong focus on Azure DevOps, SQL Server performance optimization, and the development of scalable SQL Server and Azure SQL solutions. Torsten has delivered more than 340 technical sessions at national and international conferences and user groups. Since 2018, he has been recognized annually as a Microsoft Most Valuable Professional for Data Platform - and since 2025 also for Developer Technologies. He is a Microsoft Certified Trainer and has been listed among Sessionize’s Top Speakers for three consecutive years. About the Portland Azure Data User Group: The Portland Azure Data User Group is a community of people excited about the endless possibilities of cloud computing, data analytics, and security on Microsoft Azure. We run the gamut from new to experienced users and welcome anyone who shares an interest in cloud-scalable infrastructure, applications, tools, analytics, identity management, and security. You can join the community here: https://www.meetup.com/portland-azure...