"Using SQL Server Management Stupid"?!? :w00t:
Nice post, I'll use this feature to update tools like Adam Machanic sp_WhoIsActive, Ola Hallengren's Maintenance Solution and Brent Ozar's First Responder Kit.
Thanks!

Nice job, Theo, it seems a timesaving activity, so I'm trying it out on a development machine.

For the moment I'd only suggest to modify the CreateServerInfoDbAndTables.sql file, inserting...

Very nice post!

Just a consideration: there's no need to use "sudo" when you are connected as root. If logged as a non-root user, though, the redirections like

sudo curl

Nice script!

I just added another option to the VersionName CASE statement to make the script aware of SQL Server 2016:

when convert(varchar(100),SERVERPROPERTY(N'ProductVersion')) like '13.0%' then 'SQL Server 2016'

and removed a duplicate...

Very nice script, thank you!

I only added a new column name, just to be aware of the schema (I make a heavy use of the schema separation for security purposes)

SELECT

...

Thanks for pointing out, Aleksey, and thanks for the whole idea of getting the dependencies right from the DB metadata.

Thanks for the tip, Aleksey.

As suggested above, I took a look at sys.dm_sql_referencing_entities and I got to this:

SELECT

SCHEMA_NAME(T.schema_id) + '.' + T.name AS full_table_name,

RE.referencing_schema_name + '.' + RE.referencing_entity_name AS full_proc_name

FROM...

I happen to have tables with the same name in different schemas (mainly staging.<tablename> and dw.<tablename>), so I tweaked the query a little to display (and use) full table names.

WITH...

It seems the links (from the daily newsletter and from the site itself) do not work.

Order #123 ships with N deliveries #ABC on Dec. 2, #DEF on Dec. 3, ..., #XYZ on Dec. 5.

The table Orders contains a record with

{

orderid: #123,

...

}

and...