Sorry about your Lab. We lost 3 dogs a couple years ago, which was a hard year.

One of the bright spots for this time for us is a new filly....

Can I ask what tools you're using? I assume you're getting timing from third party tools. What I'd love is a way to check execution plan regressions.

Is it viable to check for application performance regressions by running a workload on SQL Server 2019, recording metrics, and then running the same workload on the same app...

Thanks, glad you liked it

I feel the compatibility level facility is a technical fix for a human problem.

In the ideal world we would be able to install the latest SQL Server edition an...

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