I've tried different things. Mostly I struggle to keep up. Right now I use Google to offload some stuff. I have a desktop where I put a lot of pictures,...

That's...

I have whacked tables and I've seen  DBAs restore over or drop the wrong db and kill production. No one got fired, but there were tense moments.

This usually...

Seems to be better. No prettifying yet, but I pasted this from SSMS.

Plenty of people may never have encountered this. Remember that learning is a journey for many. Few of us are in the same place as others.

htey certianly do

The incorrect answer is "set defaultdatadir /prod/data".

The correct answer is "set filelocation.defaultdatadir /prod/data"

This is specified in  https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017#datadir

You are referencing an article that has a mistake. This might have...

If you think restricting technology means banning all new technology, I'm not sure you read this clearly. At Redgate, we limit technology, especially in projects that often see staff turnover...

restore with standby.

Again, I don't think you can add SQL2016 nodes. You'd add SQL 2012 nodes and upgrade them to SQL 2016 in place.

Ah, ok.

Then I believe the same  principle applies. You can't add a new SQL node at 2016 because the database version is different. What you do is...

Use SESSIONS_CONTEXT() instead. Still some dangers. What you can better used is actual SUSER_SNAME() results. Note that if you use this with groups, like ISMEMBER(), there is a load in...

Not that I know of either. There used to be a note at MS Support, but the article looks pulled.

I did find these:
https://dba.stackexchange.com/questions/66513/sql-server-cross-domain-transcational-replication

Remember that your system generates xx log per unit of time. You might see something like:

8am-5pm 5GB log space
5pm-7pm - 10MB log space
7pm-8pm - 10GB log...