This course teaches how to use SQL Notebooks in Azure Data Studio for Database Administrators (DBAs). The learning outcomes include installing SQL Notebooks, running queries, saving results, troubleshooting, and creating notebooks for various DBA tasks. The course covers connecting to instances, using PowerShell, creating new notebooks, and utilizing DBA tools. The teaching method involves practical demonstrations and examples. The course is intended for DBAs looking to simplify their work using SQL Notebooks in Azure Data Studio.
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
