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...
You can now script your database objects as a Notebook using SQL Server Management Studio 18.5+
Great News Everyone! Microsoft just dropped SSMS 18.5 after almost 5 long months without any updates; this new release fixes a lot of bugs and introduces a few new features, above them all I’m now showing you the following. I’m sure that you used the the “Generate Scripts” feature in SSMS quite a few times, you could generate the code for schema and/or data for any (or...
The SQL Diagnostic Notebook: Update 2
Just a quick note, the SQL Diagnostic Book has been updated, here is the changelog: Updated FirstResponder’s Kit and Glen Berry’s ScriptsAdded SQL Assessment API NotebooksAdded sp_whoisactive installation and basic documentation notebooksAdded sp_pressure_detector as a Notebook That’s it! As always, to use it just download the folder of the Book from my GitHub (here is...
The SQL Diagnostic (jupyter) Book
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 talked about diagnostic notebooks in the past, and now, since Azure Data Studio has implemented the feature, I wanted to group them into a Diagnostic Book.