DevOps for Your Relational Database Foundations
summary
Shows how a real SQL Server schema (Northwind) is reverse‑engineered into an SSDT project, committed to Git, built into a DACPAC output and wired into Azure DevOps CI/CD. Demo creates a build artifact (dacpac and create SQL), a release pipeline that auto‑deploys to shared Dev and Test with approval gates, runs the diffing publish to apply an added is_vip bit column, and uses pre/post deployment scripts and data‑motion patterns for nontrivial structural changes.
AI-written summary · about
chapters (24)
- 0:00Introduction
- 0:45What is DevOps
- 2:26Journey not destination
- 3:00People and process
- 3:30Technological win
- 5:55SQL Server
- 7:22Model Approach
- 9:24Migrations
- 10:35Considerations
- 19:11Demo
- 20:48Visual Studio
- 22:16SQL Server Database Project
- 23:09Import Options
- 24:11Connection Properties
- 26:06Database Catalog
- 26:51Database Snapshot
- 27:55Properties
- 30:01Publishing
- 30:44Data Tools Operations
- 34:14Version Control
- 37:42Pipelines
- 38:34Create Pipeline
- 48:38Build Pipeline Options
- 52:38Continuous Deployment
related talks
48mApplying effective Source Control to your Database System
48mConnecting the dots of Azure SQL DevOps
50mA Deep Dive into DevOps Practices with Azure SQL
50mBringing DevOps to the Database
01h 12mNext-gen SQL Projects with Microsoft.Build.Sql
01h 09mAzure SQL Database Development Inner and Outer Loops
48mDevOps Discovery: Navigating the Database Landscape
46mDatabase CI/CD with Docker Containers and Azure DevOps