SQL Projects for Database Development

on YouTube ↗45m

" summary

Extension added September 2020 brings Azure Data Studio SQL Database Projects to Windows Mac and Linux and uses the .NET Core SDK to build a dacpac that sqlpackage can publish; workflow shows extracting a project from AdventureWorks, adding a rewards_account_id column, building a dacpac, publishing and running a post-deployment script that inserts test rows so schema and data changes actually apply. Schema Compare and a sqlpackage wizard are demonstrated, sqlpackage updates quarterly, and a companion repo (github.com/daisysquared/sql-development-tools) includes VS Code dev container examples with SQL Server.

AI-written summary · about

" chapters (16)

1. 0:00Intro
2. 1:10Why do SQL projects matter
3. 2:17Data tier application artifacts
4. 3:25declarative database development
5. 4:55SQL Package
6. 6:13SQL Package Script
7. 8:13Azure Data Studio
8. 9:18Database Projects
9. 10:43SQL Projects in Azure
10. 18:12Schema Comparison
11. 21:43Reopening Azure Data Studio
12. 27:43Editing in Azure Data Studio
13. 32:53VS Code
14. 35:58SQL Server
15. 36:29Setting up VS Code
16. 40:56SQL Development Tools

" related talks

• 01h 12mNext-gen SQL Projects with Microsoft.Build.SqlDrew Skwiers-Koballa · Visual Studio Live! @ Microsoft HQ 2025
• 01h 09mAzure SQL Database Development Inner and Outer LoopsDrew Skwiers-Koballa · Visual Studio Live! Microsoft HQ 2022
• 48mApplying effective Source Control to your Database SystemKarim Ourtani · SQLBits 2019
• 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
• 50mA Practical Starter Guide to SQL NotebooksDeborah Melkin · SQLBits 2023
• 50mA Practical Starter Guide to SQL NotebooksDeborah Melkin · SQLBits 2019
• 46mSQL Notebooks in Azure Data Studio for the DBARob Sewell · SQLBits 2020