Episode
SQL 911: A DBA's Guidebook using Notebooks in Azure Data Studio | Data Exposed
with Anna Hoffman, Marisa Brasile, Kevin Warren
Did you know that Jupyter Notebooks can help you manage your SQL Server enterprise no matter how large or small? In this episode of Data Exposed, Kevin Warren demo's a Jupyter Notebook in Azure Data Studio that was created to be a DBA's handbook of resources, knowledge, code, troubleshooting tips, and step-by-step examples on how to Administer, Monitor, Troubleshoot, Fix and Repair issues you may encounter in your day-to-day life as a DBA. This notebook brings you content developed over a career of consulting at some of the world's largest SQL customers.
COVID19 was the Inspiration for this Notebook. Most Microsoft Consultants were prevented from traveling on-site to our customers during the first year of the pandemic. Kevin needed to create some sort of remote-delivery mechanism that will be as close as possible to actually being on-site, to help customers continue to deploy, manage, and provide for the day to day “care and feeding” of their SQL Server and data platforms, even when we could not be on-site and the DBA's had to work from home or operate with limited staff in the data center.
Chapters
- 00:00 - Introductions
- 01:20 - Project overview
- 02:48 - Demo: Jupyter Notebook in Azure Data Studio
- 07:56 - Where you can run this notebook
Recommended resources
Did you know that Jupyter Notebooks can help you manage your SQL Server enterprise no matter how large or small? In this episode of Data Exposed, Kevin Warren demo's a Jupyter Notebook in Azure Data Studio that was created to be a DBA's handbook of resources, knowledge, code, troubleshooting tips, and step-by-step examples on how to Administer, Monitor, Troubleshoot, Fix and Repair issues you may encounter in your day-to-day life as a DBA. This notebook brings you content developed over a career of consulting at some of the world's largest SQL customers.
COVID19 was the Inspiration for this Notebook. Most Microsoft Consultants were prevented from traveling on-site to our customers during the first year of the pandemic. Kevin needed to create some sort of remote-delivery mechanism that will be as close as possible to actually being on-site, to help customers continue to deploy, manage, and provide for the day to day “care and feeding” of their SQL Server and data platforms, even when we could not be on-site and the DBA's had to work from home or operate with limited staff in the data center.
Chapters
- 00:00 - Introductions
- 01:20 - Project overview
- 02:48 - Demo: Jupyter Notebook in Azure Data Studio
- 07:56 - Where you can run this notebook
Recommended resources
Have feedback? Submit an issue here.