Play all

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

Description:

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.

SQL Notebooks in Azure Data Studio for the DBA

PASS Data Community Summit

Add to list

#Conference Talks #PASS Data Community Summit #Programming #Software Development #Version Control #GitHub #Computer Science #Information Technology #PowerShell #Data Science #Jupyter Notebooks #Databases #Database Administration #Data Management #Data Backup #Cloud Computing #Microsoft Azure #Azure Data Studio