You can now access the SQL Server Diagnostic Book remotely!

■

UPDATE: This is now somewhat deprecated, because you can install the Book as an extension, without having to type anything, as detailed here.

Good news everyone, thanks to the Azure Data Studio August 2020 update you can now access the SQL Server Diagnostic Book without having to download the book from my Github.

Remote Jupyter Books have been added to ADS, now you just need to click “Add Remote Jupyter Book” in the Notebooks blade and insert my GitHub repository URL, like so:

Launch of books picker

Azure Data Studio Add Remote Book dialog: GitHub, repos/EmanueleMeazzo/tsql.tech-Code-snippets, DiagnosticBook 1.0, EN

Be sure to click the “Search” button after inserting the Repository URL

Here the URL for your Copy/Paste convenience: repos/EmanueleMeazzo/tsql.tech-Code-snippets

I’ve updated the book’s notebooks with the latest versions, of course, here’s the list of included Notebooks:

Notebooks pane with the remote SQL Server Diagnostic Book: Glenn Berry’s scripts, First Responders Kit, sp_whoisactive

As always, if you want to see anything else in the Book, just hit me up with your request :)

Related Articles

Welcome to 2020! I wanted to start this year by giving to all my fellow consultants another way to troubleshoot our beloved SQL Servers; I’ve already …

Just a quick note, the SQL Diagnostic Book has been updated, here is the changelog: Updated FirstResponder’s Kit and Glen Berry’s Scripts Added SQL …