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

While I do like a space, and do have an office that is mostly mine, I miss interactions as well. My hope is that we get to go back to...

Ask.ssc.com is hosted, and we've had a ticket in for awhile to upgrade. They are working on this, but going slow as they support a number of different SO/SE style...

That is an allowed use.

Most of my clients/customers use dev edition in dev/test/qa/uat and standard/enterprise in production.

When you say offload or testing, not sure what you mean. You can perform development and test code. If you're moving production data and doing something like validation of data...

Not supported from MS: https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/non-sql-server-subscribers?view=sql-server-ver15

This is deprecated in current versions, but it can run.

Golden Gate had a product to do this, not sure if it is still available:

2FA definitely makes things hard. My wife has my passcode to the phone, and I've given her my password safe. Need to include some details in there for my kids...