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.

Use Audit or XE. XE is more friendly for data storage and loading into a table.

tempdb isn't large or small. It is what it is. You might just need that much space for your workload. This isn't necessarily an indication of bad code, but it...

I've unspammed it. While it did look funny, I didn't take it that way. Mainly because I've seen quite a few posts from SCDecade.

I liken mentorship to having adult children. It's more advising at times, in specific places, and not guiding or telling them often, but just helping them when asked, or just...

The goal is to release completed work quicker. Every feature you've completed is inventory. It's work in progress while you wait for QA, packaging, scheduling, and deployment. The absolutely goal...

DevOps is a culture, but the culture isn't to write sloppy code faster. It's to release the changes, backwards compatible, quicker. From code commit to release is quick, not from...