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.

Are you saying that you need to move the cluster with the same name/ip/etc.?

This may help: https://www.red-gate.com/simple-talk/sql/database-administration/hosting-sql-server-in-hyper-v-replica-environment/

There is: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver15

A couple things. This phrase: "The per-service SID of the SQL Server service is provisioned as a Database Engine login. The per-service SID login is a member...

For the DW space, I do wonder what happens. I think what Snowflake does is great, and they've solved some of the dev/test/copy issues with size/space for multiple users. I...

Older apps are always an issue. That's not a shadow IT issue. I've seen many from IT departments. Heck, we see the issues with New Jersey's Cobol system. Not real...

I think it's really hard to justify replacing many shadow IT apps. They exist for a reason, some need wasn't met (fast enough, or at all) and once there, it...

Been tried for years, with various levels of success: https://www.dell.com/en-us/work/shop/scc/sc/cloud-client?gacd=9684689-1036-5761040-0-0&dgc=st&&gclid=Cj0KCQjws_r0BRCwARIsAMxfDRioGdr4YVtwoOJ9TwtokZfj0vshg9vLTcy6PaYABsmdiQ3UXLqdH30aAlWlEALw_wcB&gclsrc=aw.ds

Part of the reason is a lot of hardware in a central place. If everyone depends on the VM cluster,...