OPENROWSET will work: https://learn.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-ver16

OleDB driver: https://www.microsoft.com/en-US/download/details.aspx?id=100917

First question: Upgrade.

Doesn't matter, unless you are trying to get an encryption level/algorithm that requires 2016. This is independent of the version outside of that. FWIW, SQL Server 2016 is...

As Morpheus said, "welcome to the real world."

I get that. However, I often find the next person that writes code struggles to easily join here. Joining with all days is really simple.

I like to keep things as simple as possible.  I also want to use the tools that exist.

I would set the schedule like this for the proc in Agent and...

Good to hear.

No idea, I haven't read it, but you can contact the author, or get a sample from Amazon, which should have the TOC

The repeated failures are a denial-of-service attack. That's how those work, as they overload network cards that have to ack or nack each thing. Or they hold open a handle...

Is this causing an issue? Have you traced back who owns the file open requests?

There is some logging stuff as well, if you haven't seen this: https://learn.microsoft.com/en-us/windows-server/failover-clustering/troubleshooting-using-wer-reports

It is. I asked for a bump. Last isue was blocked by a software upgrade

Thanks for the update. Good to know this worked for you.

No idea here, and no time to test, but I found a few resources:

one with PoSh: https://www.sqlshack.com/increasing-or-decreasing-scale-for-azure-cosmos-db/

This one seems to indicate what you list will work: https://microsoftlearning.github.io/dp-420-cosmos-db-dev/instructions/30-adjust-throughput-cli-script.html#adjust-the-throughput-of-an-existing-container-using-the-azure-cli

Similar to Brian, I like to stage and sanitize things like this. Without DDL or more details, I don't want to guess, but my general process is something like:

• truncate...

That's what I thought as well. Maybe it will be useful...

No, not a valid guess. There are always potential issues with concurrency, but for understanding the point, which is what is reflected in system tables and what happens, you ought...