A Practical Starter Guide to SQL Notebooks
summary
A practical how-to shows Azure Data Studio with the Jupyter extension enabling SQL notebooks, demonstrates export as notebook from a query window, and runs SQL and PowerShell kernels to create backups, publish a DACPAC and spin up a Docker container; cell scope matches batches so variables and transactions persist per session, and results saved with cells (notebooks are JSON so watch sensitive data). Polyglot (.NET interactive) polyglot notebooks can share query results but is flaky in ADS; there are no execution plans.
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
01h 12mNext-gen SQL Projects with Microsoft.Build.Sql
47mGitHub Copilot for SQL Development: Integrating the Power of AI into Database Development
50mA Deep Dive into DevOps Practices with Azure SQL
43mIncrease developer velocity with Azure SQL Database from data to API