A Practical Starter Guide to SQL Notebooks
summary
Shows how to use Azure Data Studio with the Jupyter extension to make runnable SQL notebooks, demonstrating that cells are either text or code, that variables and batches are scoped per cell so transactions and temp tables persist in the same session, and that results export to CSV/Excel/JSON and are results saved with notebook (not hidden). Demonstrates PowerShell kernels (require Python, PowerShell version matters), creating a Docker container and deploying a DACPAC via DBAtools, warns notebooks are JSON and one kernel per notebook so 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
20mIntro to Azure Data Studio
01h 03mVisual Studio Code and SQL Operations Studio
07mJupyter Notebooks in Visual Studio Code
25mOvercoming 5 Hurdles to Using Jupyter Notebooks for Data Science, by the JetBrai...
01h 23mGetting Geeky With PowerShell Notebooks
51mAzure Data Studio and the Surprises Inside
45mDrive Rapid PowerShell Adoption Using Jupyter Notebooks
01h 23mImproving Your Data Modeling Work Through Open-Source Software