Connecting the dots of Azure SQL DevOps
summary
Shows a workable pipeline: VS Code/Azure Data Studio + go SQL command creates a local SQL container with one line, SQL Projects build into DACPAC artifacts, and GitHub Actions or Azure DevOps run CI/CD to publish schema changes. Demos add a computed column, run pre/post-deploy scripts to preserve data, and reverse-sync a live database change. Preview SDK-style SQL projects produces smaller, faster DACPACs for large databases. Variables, incremental publishes, and DAC FX filters (exclude objects by name) are the concrete techniques demonstrated and shown to work.
AI-written summary · about
chapters (10)
- 0:00Start
- 2:19DevOps impact on application development
- 5:05DevOps impact on development culture
- 6:38Inner & Outer Development Loops
- 8:07Source control, source of truth
- 9:36DB Development Approaches
- 10:56SQL projects: interface to a database schema
- 12:42SQL Project Development Tools SQL Server Data Tools
- 15:25Anatomy of a Dacpac
- 19:16Example: Publish and create new database
related talks
01h 09mAzure SQL Database Development Inner and Outer Loops
50mA Deep Dive into DevOps Practices with Azure SQL
01h 12mNext-gen SQL Projects with Microsoft.Build.Sql
22mAdvanced Azure DevOps With Containers and Pipeline As Code
01h 00mDevOps for Your Relational Database Foundations
46mDatabase CI/CD with Docker Containers and Azure DevOps
49mUnveiling the magic of CI/CD for SQL Server using GitHub Actions- 49mUnveiling the magic of CI/CD for SQL Server using GitHub Actions