Invoke-SqlCmd will do this for you. If you really want a RunPS, alias it, but there's no reason to have some other cmdlet.

If you want to capture the output in...

Standards are hard here. More, I think discussing whether a particular comment is helpful or not helps the team decide what is important and how to structure them

Here you go:

$who = Invoke-Sqlcmd -ServerInstance "Aristotle\SQL2017" -Database "master" -Query "EXEC sp_Who"

foreach ($row in $who)
{
    Write-Host ("SPID: " + $row.spid + " Status: "...

If you take notes of what you use, what you learned, how the test goes (don't break NDA), it would make a great article.

Thanks and glad you like them. I am trying to keep this very simple, and assuming these are new concepts for people.

Any suggestions/requests are welcome.

Part of the game, plus you can try to use knowledge to make it an educated guess.

Most of the question I write are because I didn't know something and learned...

Thinking more, I think colorizing based on login is likely not really what is useful. However, by role is interesting. It's usually the permission set we are about, so allowing...

Prompt does not colorize based on the login used for the instance. That's an interesting idea. I'll submit it.

No, I mean execute the query(ies) that the package runs from SSMS from the instance where the data will be stored.

My guess too, which is why I'd like to break something out to check.

If it hangs in SSIS, can you get it to hang in SSMS?

Thanks. Posted in the MVP list. Hopefully someone responds.

I wouldn't think column order matters. At least, it shouldn't. Not sure dynamic SQL is better than just the loop shown above. I might actually store the 30 cols in...

Separate physical drives is mostly what you want. You want separate IO paths. Depending on your architecture, it may or may not help. The other place that diff files helps...

It's by the instant/db, but the scope is per SSMS install. So I can color my dbs/instances separate from how you do it.

That's deprecated. I think you want master.sys.master_files

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-master-files-transact-sql?view=sql-server-ver15