SQL Notebooks in Azure Data Studio for the DBA
summary
Demonstrates using SQL Notebooks in Azure Data Studio to make on-call work reproducible by storing query results inline as JSON so a midnight investigation can be re-opened with exact SQL, output and the code that produced it. Shows concrete tools and builds: PowerShell notebooks that generate color‑coded Excel reports, a web timeline of Agent job runtimes, exporting Agent jobs into Git, and a performance microbenchmark (10,000 files) comparing PowerShell Core vs C# where timings flip but the notebooks run and record the results.
AI-written summary · about
chapters (19)
- 0:00Introduction
- 1:52What is a Notebook
- 2:42What is a Jupiter Notebook
- 3:18Running queries
- 3:57The big cross
- 7:02No way to reproduce results
- 8:34What is a Jupyter Notebook
- 8:55What is Azure Data Studio
- 9:06Only for Azure
- 9:36Visual Studio Code
- 10:15Demos
- 10:33Themes
- 12:21Azure Data Studio
- 13:15Creating a new notebook
- 21:23Powershell Notebooks
- 26:38SQL Notebooks for the DBA
- 30:02How to get SQL Notebooks
- 32:42SQL Notebooks in Source Control
- 39:38Net Interactive Notebooks
related talks
50mA Practical Starter Guide to SQL Notebooks- 50mA Practical Starter Guide to SQL Notebooks
45mSQL Projects for Database Development
49mFrom the Classroom to the Boardroom – Azure SQL DB through Demos
01h 09mAzure SQL Database Development Inner and Outer Loops
51mAzure SQL Database - Where is my SQL Agent?
52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solution
43mIncrease developer velocity with Azure SQL Database from data to API