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

Thanks, I was actually surprised this worked, as I'd have assumed DNR isn't in effect here for tables, but it is.

Good catch on case, sorry about that. It's been corrected