I would re-download as well, and double check the instance level.

I haven't seen this, but I guess something could happen outside of SQL to do this. I'd set the service account in config manager to another account, save, then reset...

Can you give a short example of what's in the file and what you want? Maybe a 2-3 line file?

It would help if you showed some work. The general flow would be something like:

SELECT
 CASE WHEN Q141 = 'EndofDay' AND AD141 = 'EndofDay' AND V141 =...

OK, I was unable to get the original database back as the subscription expired.

I have created a new one and updated the credentials in the article.

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