I don't think the offline usb backup is paranoia at all, I would call that prudence - if you don't have something better available to store offline backups. Even before...

Hi guys, With respect to both replies, I had a question I needed a straight answer.

To clarify, I have a Windows 2019 Server with two 2.20 GHz processors and...

Yikes.

I have had problems with packages migrating from 2008 to 2016. (development problems)

Definitely go through a stepped migration as suggested. I ran into lots of problems with the way SSIS...

That is a kerberos problem, most likely a delgation problem.

The SQL service account both needs to be configured to enable delegation and the account using the linked server needs to...

There is no direct connection between DB size and amount of memory required. It depends only on the workload. If it mainly writes, reads very little, the reads are small,...

Johan already said it, but you need to avoid auto growth, not embrace it. It is a problem that auto growth is taking too long, but the bigger problem is...

I am curious if the task prioritization and quantum in Windows 11 that are different in Windows Server.

Desktop operating systems typically implement shorter quanta to make interactive applications seem more...

CTFE of 5 is generally EXTREMELY low. Even 15 is pretty low. Is this in production or are you still testing it?

Hopefully you are still testing - if you are...

Would not run SQL server in docker. Containers are good for stateless applications, and SQL server is very much stateful. You won't get automatic scaling, auto recovery, load balancing etc,...

Is this a production workload?

SharePoint requires maxdop to...

Brian and Michael said a lot already, so random thoughts...

2.2 Ghz is incredibly slow for a database server in general, but for a max dop = 1 application like SharePoint...

I can't say anything about kingsoft, but can comment that ADF is absolutely horrible. If you are doing the transforms in something else like DBT, ADF is fine for orchestration...

Page fullness is more a problem than fragmentation, but where you are at, at 70% is generally still pretty good.

I would not even consider going to single column indexes only....

How do you know the error is benign? Do you know for sure that it is associated with something legitimate?

This could be something attacking your SQL server. Or it could...