My first question would be why are you running that from SSIS?  That feels like overkill when windows task scheduler can handle it perfectly well.  And failing that, SQL Server...

I am pretty sure the proper way to fix that you need to change the service account for the SQL instance to a domain account.  Once that is changed, you...

For the first question - writes refers to changing data.  a SELECT will have 0 writes, while an INSERT, UPDATE, or DELETE will have 0 or more writes.  A "write"...

I can't speak for the scale out part, but for the rest, I think it really depends.

For the ports, I recommend any that are not in use and that your...

To add to Ant-Green's comment, you may want to capture what queries are being run as sa too.  Knowing that sa logged in is one thing, but if it is...

I forgot about the advent of code as well.  They are fun (and challenging) puzzles for sure.  Would be nice if they listed some global "rules" like that the solution...

That is also a lot of NOLOCK hints... are you sure you need those?

I wonder if you'd get a performance boost by dumping the data to a temp table or...

Is this advertising your product or spam?

If you could provide more details about what the tool does and why we would want to use it, without us having to go...

As Anthony Green indicated, permissions can be granted to anything in SSRS.

What I am guessing you did is had it set up with inherited permissions, then removed permissions at the...

What error are you getting?  If you don't know, check the logs.  That will tell you why it isn't starting and give you a good starting point to resolving the...

Was just reading the error message and it sounds like the installer thinks that you are trying to install the wrong CU.

I would try re-downloading CU 22 and see if...

You missed putting a checkmark in the error.jpg.  Select "MSSQLSERVER" and it should install the update for you.

My advice - contact your license vendor.  They will be able to provide you the best bang for your buck and the best advice about what licenses you actually need.

You...

This looks like an easy one to me - Z:\ is mapped for you, not mapped for all users on the server.  So the SQL Agent service account doesn't have...

I think that is a very per-use case question.

For example, the cost to host a data warehouse is going to be different than a highly OLTP workload.

And there are a...