Explore SQL Notebooks in Azure Data Studio tailored for database administrators in this comprehensive conference talk. Learn how to install and create SQL Notebooks, including a practical example using Glenn Berry's Diagnostic queries. Discover various use cases to streamline daily DBA tasks. Delve into topics such as Jupiter Notebooks, running queries, Azure Data Studio features, troubleshooting, PowerShell integration, and cross-compatible notebooks. Gain insights on using notebooks for backups, database management, and leveraging extensions like dbatools. Understand the benefits of SQL Notebooks for simplifying DBA work and enhancing productivity.
Overview
Syllabus
Introduction
Presentation Start
Jupiter Notebooks
Running Queries
Why use SQL Notebooks
Azure Data Studio
Visual Studio Code
Data Studio
Download Azure Data Studio
GitHub Azure Data Studio
Dark Mode
Connect to Instance
Notebook
Connection
Notebooks
Are the results saved
Saving the result set
Troubleshooting
Powershell
New Notebook Job
Notebook Results
Job Results
Notebooks on GitHub
Crosscompatible Notebooks
Onenote Notebooks
Creating a New Notebook
DBA Tools
The Problem
Viewing the Notebooks
Powershell Notebooks
Backups
Get DBA File
Create Database Folder
Use Notebooks
Extensions
dbatoolslabnet
Jupyter book
Can you mix languages
Taught by
PASS Data Community Summit
