This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.
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.
Resources:
You can clone Kevin’s Notebook from GitHub here
Download and install Azure Data Studio
Anna Hoffman and Warwick Rudd of Microsoft discuss
This is a good article and a getting started video by Vicki Harp of Microsoft
Build SQL Database Projects Easily in Azure Data Studio with Drew Skwiers-Koballa
Azure Data Studio - The New Frontier with Warwick Rudd