This is something where the question itself is kind of nonsensical, like what is better eating a steak or watching a good TV show.  There might be some overlap...

I prefer to use Powershell, and Invoke-DbaQuery from within my Powershell scripts for things that require T-SQL. The source of all scripts is then in my Powershell library, instead...

Btreieve, wow, I remember that on Novell. Not a fan.

Great advice. Similar to what I've heard from other sources

Glad you liked it. I thought it was a good post on a topic that many of us spend minimal time thinking about.

And as you can see, I replied under the test account, which I logged into with an email that is different from the user name

FWIW, I wouldn't ever install SSMS 2014 or anything below the current SSMS v18, which works with all instances of SQL Server.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Be good to post the link you got for others.

What you are looking to do here is pivot the data. As noted above, we would prefer to see DDL that helps set up the problem. Use a small set...

windy

Wow, Steve, your comments took me back.  ....

'Incident response' consisted of me getting out of bed, or interrupting a family dinner, or some such thing to handle problems on...

You can change the user name that is displayed.

It is, however, your contention this is easy...

I actually don't think this is that hard, but with all the work in Synapse (Spark pools) and DataBricks, I don't expect this to get added to SQL Server.

The hard...

Fingers crossed. I had another joke, but held it as I think MS is actually working on it.