Good article.  Thanks for taking the time to write it.

I wonder when people will really reconsider what they've done.  I was both shocked and tickled when I saw the articles...

the best, and probably correct, way is to use your visual studio (or vs code) solution (you do have one don't you!!!) and its schema compare.

while there are 2...

This does not show database sizes but rather individual database file sizes. To do what I think you want it to do - show total space used per database, change...

You will need to do the rename the column inside of every coded object, as well.  The textual content is located in sys.sql_modules by object ID.  Obviously, you're going to...

That's one of the ways we made a Partitioned View a whole lot faster.  Instead of...

See the 'tube in the following article...

https://www.scientificamerican.com/article/robots-made-from-human-cells-can-move-on-their-own-and-heal-wounds/

Then, imagine this doing like what Covid did and getting "out of the lab".  We're talking about something that can, in their words, "create...

I am curious as to why you need to call out to PS directly from SQL Server.  If I need to call a PS script from SQL Server -...

ugh... so one thing, i realized... is always check the naming... of the file... really sorry, everything you mentioned is great troubleshooting... when i found the file.. it was...

Is that E: Drive on the server where you're running this or on your...

Run the following code from SSMS on the server that you're trying to run you call from...

EXEC xp_cmdshell 'WHOAMI';

... then tell us who or what that login...

You bet and good talking with you this morning!

This should do it for you... as is typical, the documentation is a lot longer than the code.

 CREATE FUNCTION dbo.Convert_EE_FileName_TimeStamp_to_DATETIME2
/*********************************************************************************************
 Purpose:
 Convert the timestamp embedded into...

It's actually got a name for that type of process... "Relational Multiplication".  The code that Des Norton wrote above will absolutely do the trick.  It's also known as a "Cartesian...

I don't have any help to offer because I don't build CLRs on our systems and so have zero experience there.

As a bit of a sidebar, though, what does your...

I don't have the links for them but I've recently read a few articles that say the turning off page locking for the table did the trick nicely for them. ...