This isn't out of the box. SQL Prompt does this, as does SSMS Tools Pack, but you pay for both.

Disclosure: I work for Redgate, developer of SQL Prompt.

I'd agree with you, but how do you prevent someone that admins a database from making a change? Our platforms don't do a great job of preventing this. Something like...

That's a good system, Chris Wooding. Not perfect, but likely it works well unless you have a rogue admin. I still like the idea of using a pipeline of sorts...

I'll post a note to Microsoft and see if I can get a response.

I didn't 😉

Nope, that was all I wanted to say. I'll add in the a few more words.

To add to what Grant said, create the role in your database and then add the group (I assume this is an AD group) to the role with ALTER ROLE...

Is that the only output? Isn't there something from DBCC besides what you are returning?

You are running EE, so no memory limits. 64GB might be small these days. I think I'd go to 128GB at a minimum or 256 if I think this workload...

No difference, but fixed now.

I haven't worried about this too much. Typically this is limited in Windows, unless you are having crash dumps, in which case it can grow large. This pages notes that...

I don't think there are any issues with re-enabling a trace flag that is enabled in the Configuration Manager/Services applet. This certainly gives you a second place where things are...

Not by adding them to a startup proc. The trace flags themselves can alter behavior, so they should be tested in your environment.

I miss Byte, but more I miss Jerry Pournelle - https://www.jerrypournelle.com/chaosmanor/

Rod,  good point, and I should have emphasized this. Working away in an isolated space isn't for everyone, and it's worth experimenting with, or building a space that you'd be...