capture mode and cleanup mode should both be set to auto. That is the default now, but previously it wasn't and relatively idle databases would fill it up quickly.

I mocked this up in 2017 with AG publisher and subscribers a few years ago. I am very glad to not have needed to do that again or implement it...

I am only familiar with transational replication in detail, but in transactional, the updates are tracked in the distribution database, not in the published database. You would still have to...

This isn't a client problem it is a server side problem. It sounds like something is holding a long running schema lock.

Big SELECT INTO statements are a common cause of...

I've had a few in the last couple of years.

One environment was a remote (very remote) with a high latency and unreliable connection supporting infrastructure that could not go down...

I firmly disagree with the statement that AGs are only for implementing read only secondaries. AGs are more flexible and have fewer fragile components compared to an FCI while storage...

Not sure why it isn't working, but you don't need to splat it, that is a single string variable for -query. Just use [string]$addListner = "..." to start with.

Does the...

I was going to suggest using a hash for the document then insert the computer hash into the table with the document. including document metadata should uniqueify each document even...

Does the document identity need to be an integer or guid?

Stop messing with it and call a consultant or microsoft, you may have database corruption. Be sure to disable any jobs that age off backups as well

There are lots of opportunities to get in the weeds with this but will try to avoid it.

STOP index maintenance for at least a few days. There is guidance around...

commenting on this to follow it, dealing with a similar problem I want to understand better.

I didn't think you could even have an index on a partitioned table unless it...

Does SQL on linux do a JIT compilation of the binaries?

The model database has roles

Why plan on only jumping all the way to 2022? It seems that 2019 is pretty stable now and they may be done implementing breaking updates - there have been...