Visual Studio Code and SQL Operations Studio

on YouTube ↗01h 03m

" summary

Visual Studio Code and Azure Data Studio (formerly SQL Operations Studio) run cross‑platform on Windows macOS and Linux and focus on lightweight, scriptable workflows. Demo shows installing the editors on production machines that manage ~1,200 websites across ~800 servers, connecting to local SQL Server 2019 preview and Azure SQL, creates and runs T‑SQL scripts (no GUI new‑database wizard), uses snippets and stored procedures that return JSON, exports query results to CSV/Excel/JSON, and uses integrated terminal and debugger with extensions.

AI-written summary · about

" chapters (9)

1. 0:00Introduction and speaker background
2. 3:24Introducing the tools
3. 9:18Installation and setup
4. 14:45Interface and customization
5. 25:34SQL scripting with Azure Data Studio
6. 33:00Cloud database management
7. 38:48Web development with VS Code
8. 49:05Productivity tips and tricks
9. 58:11Q&A and closing remarks

" related talks

• 20mIntro to Azure Data StudioHeidi Hastling · SQLBits 2024
• 51mAzure Data Studio and the Surprises InsideErin Stellato · SQLBits 2023
• 18mIntroducing Microsoft's VS Code Extension for PostgreSQLMatt McFarland · POSETTE: An Event for Postgres 2025
• 49mNew Client Tool for Developers and DBAsFrederic Descamps · Percona Live 2022
• 41mDevelop from anywhere with Visual Studio CodeBrigit Murtaugh, Christof Marti, Chris Dias, Nannette Sperling, Daniel Imms, Rob Lourens, Josh Spicer · Microsoft Build 2023
• 59mUnleash the Power of Visual Studio CodeAaron Powell · NDC Melbourne 2022
• 50mA Practical Starter Guide to SQL NotebooksDeborah Melkin · SQLBits 2022
• 02h 00mEffective Visual StudioSteve Dower · PyData Seattle 2017