Mine is in an infant stage, so you're way ahead, Stewart.

As I jump between R, Python, PoSh, C#, I have to keep checking myself.

*head in hands*

You can, but this requires code changes. You need to open keys, encrypt/decrypt data, and then run your code.

Glad you enjoyed it

I agree, but I personally don't like multi character aliases.  For me, they clutter the code and make it less readable.  I like to name them a,b,c,d... and that...

The more articles the better. I wasn't sure ADF was better, but I'm coming around to this view. We've got one coming tomorrow on basics, but it would be good...

Absolutely. The more specific examples, the more people learn to avoid the pattern

And keep 2 full backups.

My recommendation is that you don't do this yourself and use Ola's script: https://www.sqlservercentral.com/scripts/sql-server-backup-integrity-check-index-and-statistics-maintenance

The user can get their QDS properties in SSMS and there is a "script" button at the top.

Grant has a couple books. I think one is on Kindle Unlimited if...

Good thoughts from Anthony.

If you are not rewriting the app at all, use a VM. You can get more predictable performance, reserve capacity over time for less $$, and do...

The cursor won't help. This will spread the update over time, at the expense of slower commit times for the client, which just moves the problem. Might cause an unresponsive...

GROUP BY is your friend here, and John has a great solution. If you need something else, please give us the table DDL, some INSERT statements for this data, and...

Write me a question. George 🙂

Hadn't heard of it, but I'm not surprised. This is a time criminals will take advantage of the stressful situation