A Practical Starter Guide to SQL Notebooks
summary
Shows how to set up and use Azure Data Studio SQL notebooks: install the Jupyter extension, choose a SQL or PowerShell kernel, and run cells where each cell is a separate batch (variables, temp tables and open transactions persist per session). Demonstrates creating a Docker container, restoring a database, publishing a DACPAC with PowerShell and DBAtools, and exporting scripts to a notebook; notes missing execution plans and that polyglot notebook demos can be temperamental. Results are saved with notebook (JSON) — be wary of sensitive data.
AI-written summary · about
chapters (10)
- 0:00Introduction to speaker
- 1:35SQL notebook interface
- 3:04Text cell features
- 7:23Working with code cells
- 12:38Notebook workflow
- 16:02Connection management
- 18:23Practical ETL use case
- 26:41Powershell in notebooks
- 36:05Polyglot notebooks
- 47:45Conclusion and resources
related talks
50mA Practical Starter Guide to SQL Notebooks
46mSQL Notebooks in Azure Data Studio for the DBA
45mSQL Projects for Database Development
01h 09mAzure SQL Database Development Inner and Outer Loops
50mA Deep Dive into DevOps Practices with Azure SQL
49mFrom the Classroom to the Boardroom – Azure SQL DB through Demos
01h 12mNext-gen SQL Projects with Microsoft.Build.Sql
49mNew Client Tool for Developers and DBAs