I bumped my post. I had one response where someone was using this with AGs and hadn't had this error.

I'll also add that a lot of the "patches" by MS actually take years to fix, if they even bother to fix them at all.

For example, there's been a...

No, we've seen them do that. We've seen millions of software projects that go slow. Bugs still appear.

Delivering every week doesn't mean you start writing code today and release it...

And consider how quickly broken systems get patched.

A far cry from patches that were delayed months, sometimes closing in on double digit months, in the 90s and early 2000s.

That's one of the tenets of DevOps. Don't leave software in inventory.  Get it to the customer.

We do make mistakes moving faster. We also make mistakes moving slower. The thing...

this is a merge process. you are merging data in two tables.

As I wrote. Update first, then insert. If you want to INSERT only, you need a WHERE condition that...

Gonna be a close matchup for me this week. See if Kyler or Watson wins the duel at QB.

If I understand this, you are inserting data into a staging table in Azure SQL from an on-premises table. Then, you want to essentially upsert or merge this data into...

Dr. Low wrote about this recently: https://blog.greglow.com/2017/11/06/linked-servers-dont-hard-code-server-names/

Is this the next date, meaning today is <= to the date in the table?

What I'd do is set up a number of scenarios to query, so you can test...

You are welcome, and thank you for the kind words. Hope you're well and have a great holiday.

the page thing is a bug, but as with many in software, it's a tiny fairly small bug. It's obscure, and doesn't reproduce with small threads. It's some weird combination...

Sounds weird. I don't think this is likely just SQL Server. I would start checking to be sure nothing else in infrastructure changed. If you are backing up 200GB now...

Voting forces a choice. Do I want A, B, or C. consensus allows me to say A, but not B, C is OK. We can come to a choice around...

We certainly shouldn't from tech companies. The problem is that scientists and government often don't have good expertise, especially around security. Really, it's a mess all around.