Azure SQL Database Development Inner and Outer Loops

on YouTube ↗01h 09m

" summary

Shows how SQL projects plus the SqlPackage CLI build a deployable DACPAC and push schema changes from VS Code/Azure Data Studio into Docker dev instances or Azure SQL in minutes, with SQLCMD variables for env-specific URLs. Demonstrates a Teams chatbot using Entity Framework and sp_invoke_external_rest_endpoint writing chat to the DB. CI pipelines extract databases into script folders, open GitHub pull requests, run sidecar DB containers for tests, and use DacFx contributors to filter or modify deployment steps.

AI-written summary · about

" chapters (7)

1. 0:00Introduction and context
2. 13:56SQL projects overview
3. 28:05Demo SQL projects in VS Code
4. 43:17Inner loop with SQL projects
5. 56:03Pipelines for SQL schema
6. 1:00:08DacFx and custom deployments
7. 1:07:31Summary and Q&A

" related talks

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