Data Quality is a big deal, and sampling can be good, but we've also seen lots of sampling bias that comes out later. Of course, we also have overwhelming data...

Your backup command needs the shared keys to access a blob. Your account just needs normal backup rights

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver15

Are you looking to use the Notifications from the job metadata?

You can always add a step to send something through Database Mail

This is an illustration, not real code. Presumably, you might have lots of other code that checks for the need to rollback.

However, I'm not sure SET and SELECT impact the...

Forgot about the draft, got a mix of decent players, I think. No idea how to judge who to start.

I wish, and we've debated this. There is some caching taking place because some of these summary pages (/forums, /active, etc.) are heavy on the db, so we have a...

I assume you have the same structure locally and are just duplicating this in S3? I haven't tested this, but it looks reasonable. I see your same code on SO...

Hope for the best, plan for the worst. I tend to follow that in most of life.

Closing as duplicate

Looks great, closing this.

Take it. Should be a short, easy one.

As Jeff noted, include TRUNCATE in here.

I'd agree with Sue

There were distributed partitioned views, but these didn't work well, created dependencies and didn't necessarily help performance - https://techcommunity.microsoft.com/t5/datacat/distributed-partitioned-views-federated-databases-lessons/ba-p/304955

Not sure they're still around. You can use a linked server...

+1 for Jeff's advice