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

One of the reasons we started SQL Saturday was to reduce the cost for most people to just time. Now it's the time+lunch cost at many places, but that's it....

About this line:

If you can choose Paul Randal, Denny Cherry, Andy Leonard, and Brent Ozar to present at your event, would you pick me?

I thought about this a lot...

I was thinking a WHERE clause as well.