An adventure on SQL Server performance and features

Tagnotebook

You can now script your database objects as a Notebook using SQL Server Management Studio 18.5+

Y

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

T

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

T

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.

An adventure on SQL Server performance and features

Emanuele Meazzo

My Social Profiles

If you're interested in following me around in the social world, here are some URLs for you