In a previous role I found out shortly after joining that the password for the HR & Payroll database was known to all of the developers in the company, and...

I would add make sure you test this fully before going live, because long-running reports run against a readable secondary can block the redo thread of database in a "synchronous"...

So you want to take normal backups on...

Hmm, I would use indices in a financial markets context, but indexes in a database context.

I don't know anybody who works for them, but I bet their DBAs and sysadmins had been flagging issues for months before this happened. We've all been there and been...

I'm sure you've thought of this, but is one backup compressed and one not?

Shouldn't they be banned or something? (Edit: too slow.)

The OP in this thread is so rude. Somebody was trying to help him and is just getting abuse.

https://www.sqlservercentral.com/Forums/1983125/Distributed-AG-with-AutoSeed?PageIndex=1

I was curious so I tried it, and it filtered straight through on my synchronous AG. Cool. (I changed from 140 to 130 and back again). No need to remove...

In addition to the other advice, also ensure that Instant File Initialization is enabled (unless your environment prevents this) Google if you're not sure what it is. (The service account...

I think it can be helpful for triaging issues because it tells you immediately where to start looking if there are problems. So if you have a monitoring dashboard and...

Not so much as a please.