*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

In dev/test environments, these are not as secure as production. PII, in general, should not be used in these places. This means generate or anonymize data. Even having developers accessing...

You're misunderstanding CI and ML.

CI is designed to catch these things. Developers do not magically write better code with CI. This is < 1 bug/month per dev. Shocking? I'd say...