I did always want a Jeep, ever since I spent a summer with a few friends that had CJ-7s.

However, I rented a Wrangler with my son and we drove from...

Never been a big Corvette person, at least not since the late 50s, but I did see a new one recently that looked slick.

My wife is more interested in Toyota...

I think they will be cool. Now, there's a lot of overhead, but in 5 years I think these will be amazing.

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...