I hired on with a regional bank as a developer 21 years ago, and I'll retire in a month. Sixteen years ago, after using SQL Server heavily in my development,...

A "useful" answer would include steps to clear such a file, or at least a link to a more complete set of steps to do so. I would appreciate such...

I've been working for a number of years as a DBA for a regional bank.
A new developer in my IT department was surprised when browsing through our customers to discover...

'There's a joke that a DBA's favorite word is "no". '

Actually, it's often said that DBA stands for "Don't Bother Asking."

The actual order...

+1 "Stored Procedures Only".
I am told, but have not done it yet, that parameterized queries may be an acceptable substitute for "Stored Procedures Only".

Really nice solution, Lynn!

I've let myself go a bit wild this year.

I added an SSD to my home desktop, and doubled the RAM to 32 GB.

I bought a decent, used but loaded, laptop...

Usually I find out about these on SQL Server Release Services. The KB was published on 6/28, but no notification has yet appeared on the Release Services page. Thanks Steve,...

Thanks, Steve 🙂

Very concise, does the job efficiently.

Thanks for sharing!