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

I keep everything on my desktop, laptop, and mobile, but that's because I'm often on the go. However, I've turned off most notifications because I don't want to interrupted if...

This is a strange time, and I agree, Jeff, the pulse of the people is what's often lost. I get some of that from randomly flipping through Slack when I...

Have you read this? https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-ver15

It answers most of your questions. This can be automatic or manual. Clients move and are configured according to: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/connect-clients-to-a-database-mirroring-session-sql-server?view=sql-server-ver15

You don't change SSMS to use a version. They choose the ones required. That's the advantage of .NET. The developer targets a version, and multiple versions of .NET can coexist.