A Deep Dive into DevOps Practices with Azure SQL

on YouTube ↗50m

" summary

Demo-heavy walkthrough of Azure SQL DevOps shows concrete recipes: pack app plus database into Dev containers (Codespaces/VS Code), scaffold schema with SQL Database Projects to produce a .dacpac, and deploy via GitHub Actions using repo secrets. Terraform modules create the SQL server and Static Web App, post-deploy scripts insert static data, and Data API Builder exposes REST/Graph endpoints. Demos largely succeed (one local demo hiccups), proving the inner/outer loop workflow end-to-end.

AI-written summary · about

" chapters (10)

1. 0:00Introduction
2. 1:29DevOps fundamentals
3. 6:08Inner and outer loop concepts
4. 8:50Local development containers
5. 21:21The role of source control
6. 22:51Infrastructure as code
7. 26:39SQL database projects
8. 30:51CI/CD with GitHub Actions
9. 34:06End-to-end application demo
10. 48:13Summary and resources

" related talks

• 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
• 46mDatabase CI/CD with Docker Containers and Azure DevOpsChris Taylor · SQLBits 2020
• 22mAdvanced Azure DevOps With Containers and Pipeline As CodeChris Adkin · SQLBits 2020
• 56mDeploying Docker for Database DevOps DominanceDaniel Mallott · NDC Sydney 2020
• 01h 00mDevOps for Your Relational Database FoundationsBrian A. Randell · NDC London 2021
• 49mFrom the Classroom to the Boardroom – Azure SQL DB through DemosSilvano Coriani, Sanjay Mishra · SQLBits 2023
• 01h 12mNext-gen SQL Projects with Microsoft.Build.SqlDrew Skwiers-Koballa · Visual Studio Live! @ Microsoft HQ 2025