Next-gen SQL Projects with Microsoft.Build.Sql

on YouTube ↗01h 12m

" summary

Demo shows SDK-style projects build to a DACPAC output and run cross‑platform with .NET 8, SQLPackage CLI extracts schema from a running container into SQL files, and VS Code builds produce a DACPAC that triggers code analysis (there are 14 default rules and custom rules via package references). Fabric workspaces link a branch to a SQL project so updates become source‑controlled, and publish generates a deployment script that may rebuild a table (creates temp table, migrates data) — the demos run and validate these flows.

AI-written summary · about

" chapters (7)

1. 0:00DevOps foundations
2. 5:09EF Core and automation
3. 15:44Understanding SQL projects
4. 21:54Tooling and SQL package
5. 28:01Extensible database analysis
6. 40:29SQL database in Fabric
7. 50:08Deployment strategies

" related talks

• 45mSQL Projects for Database DevelopmentDrew Skwiers-Koballa · SQL Server Virtual Conference 2021
• 48mConnecting the dots of Azure SQL DevOpsMuazma Zahid · SQLBits 2023
• 01h 09mAzure SQL Database Development Inner and Outer LoopsDrew Skwiers-Koballa · Visual Studio Live! Microsoft HQ 2022
• 01h 00mDevOps for Your Relational Database FoundationsBrian A. Randell · NDC London 2021
• 50mA Deep Dive into DevOps Practices with Azure SQLJerry Nixon, Carlos Robles · SQLBits 2024
• 48mApplying effective Source Control to your Database SystemKarim Ourtani · SQLBits 2019
• 22mAdvanced Azure DevOps With Containers and Pipeline As CodeChris Adkin · SQLBits 2020
• 46mDatabase CI/CD with Docker Containers and Azure DevOpsChris Taylor · SQLBits 2020