When trying to use hashed passwords, you don't unhash what you have stored.  As others said, hashing is basically a one-way-trip and that's a good thing.

When the user creates their...

Just to refer to the orginal problem: The root problem of the big log file could be fixed / prevented, if you would partition your tables. Ola's script would...

The best question of them all also comes from "Star Trek"...

"How do you feel"?

Never mind... I tried to write it for 2012 and above.  If you have 2017 or above, we can do a little optimization.  If you have less than 2012, then...

Ok.  Totally understood on not being about to provide the full monty in an original file.  Just to make really sure, the file located at...

https://www.sqlservercentral.com/wp-content/uploads/2022/04/sample.txt

... is a correct representation of...

How could original script posted by zzartin, be modified to just pickup these tags during extraction? Currently it's finding ALL which do some testing with the file might be...

I've downloaded SQL Server Standard 2019 to upgrade our database because we have a Microsoft Campus Agreement, but I'm being asked for a license for SQL Server 2019 Reporting...

Is there more than 1 such occurrence per row in the table and what is the datatype of the column that this type of data is in?

If you have SSAS also installed with Database services on the server, do you need to apply cumulative updates separately or it will give you the option to select...

Just to ask the question, you DO have the "sa" login disabled, correct?  And, yes, jobs can still run with sysadmin privs...

How did you know the answer to your latter question for SPs?  If it isn't included in the documentation for the CU, then you have to assume that you need...

Without some form of enforcement, standards don't matter at all except, possibly, when it comes to needing a reason to fire someone.  Urgencies are not justification not to follow a...

When we have a new server (aws so we create and delete them fairly often) and I am a local admin, but have not been granted sql access, I...

Shot in the dark but, possibly an easy way to find out how he has access is to create a user using his windows login name and then use xp_logininfo...

To be honest, CTEs can suck real bad.  They're not so bad at Hierarchies but, still, a well written While loop will be a little bit faster than a CTE...