Altered the question to note the timeout. The question was phrased because if timeout is exceeded, the operation fails.

Altered the question to note the timeout. The question was phrased because if timeout is exceeded, the operation fails.

I've always viewed *nix systems as best suited for backend infrastructure support and to run services. Windows OS has always been a front end user desktop OS to run...

Honestly, we have a Stairway that will help you (https://www.sqlservercentral.com/stairways/stairway-to-database-containers), but really, you're learning a bit about...

I've seen this, but with trace/XE, you can usually tell what they're doing. In a few cases, they add a login, so they don't need dbo or sysadmin, but the...

This stairway is excellent. What would be an interesting extension to the series is the inclusion of SSIS and SSRS configuration for local machines.  It is an alternative way...

The early SSMS work with Linux was incomplete. I think most things ought to work with 17.5/18.x

In that case, I'd use what you expect. The differences are really minor, but go with RHEL. I have RHEL and Ubuntu vms with SQL Server, the real difference is...

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