They're roughly all the same. I find RHEL a bit more a pain since they ask for some registration stuff. I prefer Ubuntu for desktop level stuff.

From what I've seen, this feature doesn't exist. The comparison is to move data and sync it, but not report on it.

SQL Data Compare from Redgate has some export options,...

A few things that might help:

• https://www.sqlservercentral.com/forums/topic/run-a-sql-server-agent-job-under-another-account
• https://www.sqlservercentral.com/blogs/credentials-and-proxies-getting-started
• https://www.sqlservercentral.com/forums/topic/what-account-to-use-for-identity-when-creating-a-credential-and-to-use-as-the-job-owner
• https://www.sqlservercentral.com/forums/topic/what-account-to-use-for-identity-when-creating-a-credential-and-to-use-as-the-job-owner

There are numerous ways to send make changes on another server from a different server. Linked servers, openrowset, etc.

However, if you are making changes in UAT, save those scripts. Someone...

Here's the thing. Your tempdb is sized to the peak amount that is needed for your workload. This means that if you size it at 100GB, and on Friday there's...

What doesn't work? There is a different security context, perhaps different SET options, etc. You'd have to explain a bit about "what doesn't work".

Have you tried running this under a...

When my wife was treated for cancer, all of her doctors were associated with the same hospital. With the electronic medical records, each of her doctors, surgeon, radiation oncologist,...

Except I worked in a doctor's office in high school. The info wasn't private. Doctors were difficult in copying records, and they shared them easily. I saw people giving out...

I agree in  some sense that things with data haven't really changed, but the reality is that there is a lot of data that has never been private. It's been...

Now that's an interesting idea, Roger. Imagine we could easily store every address in an area, or maybe a whole host of fake addresses that we don't even link or...

Thanks, and that's a place you need to understand them. I was quite confused about times when working with the rest of the world on my trip down under.

I'd completely disagree. I think their quality in many areas has gone up. Windows is better at patches than it used to be. Quality going up doesn't mean there aren't...

Love seeing these posts. That's the point.

A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him....

Glad you liked it. I enjoy the Python questions, though they can be hard to structure.