Moving those frequent v rarely queried columns can make a huge difference. It's almost like a covering index for a variety of queries using those columns.

You should see something like this. My 2019 Express container (comment is the @@version data) shows JSON works

September 14, 2020 at 4:43 pm

#3788372

If they want rows for insurance, getting the rough size from the metadata tables and then the table size might give you a guess of rows.

A Jupyter book is a collection of notebooks.

If you just want a notebook (page), then just create the notebook and add the text or cells as needed.

Also, they're revving this...

I did watch some Thur night, but then I forgot football was going until I took a break from chores yesterday and realized games were on. Yahoo did my right, as...

Glad you got it to work and thanks for the update.

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