Applying effective Source Control to your Database System
summary
Demonstrates using SSDT + Visual Studio to source-control database objects, produce a dacpac, and run an Azure DevOps pipeline that builds the dacpac artifact and deploys to local SQL Server instances and Azure. Shows a concrete example: creating a Counties table, using postdeployment scripts to seed data via a migration table, running a pull request merge, and a successful pipeline/release (one environment intentionally fails). Notes limitations: SSDT compares definitions and won’t drop objects or shrink columns automatically — use pre/post-deployment scripts for destructive changes.
AI-written summary · about
chapters (15)
- 0:00Introduction
- 1:48SQL process problems
- 4:40SQL Server Data Tools
- 12:15Demo overview
- 15:27Basic table with audit
- 17:14Schema migrations and seed data
- 21:52Deploy from Visual Studio
- 26:07Post-deploy scripts and tracking
- 30:10Branching in Azure DevOps
- 33:01Commit changes and PRs
- 36:16CI/CD for database
- 38:49Handling object removal
- 42:24Branching strategies
- 44:52Users and permissions in SSDT
- 45:55Q&A
related talks
01h 10mContinuous Integration for the BI Developer
49mUnveiling the magic of CI/CD for SQL Server using GitHub Actions
27mBuilding powerful DevOps pipelines with Microsoft Azure DevOps
56mAzure DevOps for .NET Teams
01h 03mVisual Studio Code and SQL Operations Studio
27m7 D's of Development
01h 01mFrom one release per quarter to 30 times a day
36mDevOps: Improving applications with DevOps