I'll admit I was struggling a bit to wrap a question around ANY. Suggestions welcome.

Apologies for the duplicate answer. That doesn't affect the question, but I'll award back points and change it to something else (wrong).

AGs are amazing. Wasn't sure you could, so didn't suggest, but that's essentially log shipping things.

Glad you have a solution

Tight coupling is great job security, at least until your org can't compete anymore.

Hard to know what you're doing here, as we can't see config. In general, I wouldn't use replication here.

I'd backup and restore. Once you have a full starting to restore,...

Do you mean that you have 2 nodes and workloads running against both (different dbs on each)? Is this a WSFC?

First, you should copy the db(s) to another system running...

Need to know the results, but the lag/lead approach is what I'd do, as @DesNorton has shown

It's not clear what install you're doing. I suspect your install is somehow broken and not correct in the registry somehow. I would re-download the MSI and use it.

https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

No just typos. A happy accident.

I somewhat live by this. The world is very chaotic...

Same, I'd love a lightning fast, small, query editor only.

No debugger. That isn't planned to come back AFAIK

Yeah, I suspected something since Software Assurance is a big revenue item and they can't let those customers get nothing. I'm not sure I think there was a lot here,...

Microsoft has created and supports the Az powershell module. If you r company doesn't approve of this, that's strange. A lot of what works well with Azure is PoSh or...

hard to keep up. I laughed at the session, but it makes sense. Lots of people just don't have time (or make time) to check out new things. I should...