There is no built in role for execute permissions.

You will need to create a custom role to do this.

Lookup the syntax for CREATE ROLE and GRANT EXECUTE and post back...

Sorry yeah I totally missed the SSIS, non proxy account cannot start SSIS jobs unless it’s a sysadmin.  So yeah what Jeffery said.  Use a proxy.

https://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

On the job step in the advanced section there should be a job output file location if it is controlled via the job.

Just needs to be the owner of the job with the right SQLAgent role and then, they can start their own jobs and not interfere with anything else.

Never give anything...

Memory configuration

Poorly written queries

Memory leaks

To much happening on the server for it to respond

1.      Which box is best for SQL Server where we can back up our data on-premises and cloud?

SAN or local storage.  NAS is fine for backups, but not for your...

Cost cheaper on prem than the cloud, maybe right, but if your a small shop you may find on-prem is more expensive than the cloud, maybe you need to go...

Max memory / min memory settings? 32GB of RAM max memory should be around 25GB to SQL, if the value from below is 2147483647 you need to go and change...

Good question and well versed given the referenced link

I said 13 as you can create indexes on persisted columns as referenced in a child document,  https://docs.microsoft.com/en-gb/sql/relational-databases/indexes/indexes-on-computed-columns?view=sql-server-ver15

Version & Edition of SQL? 2019/2017/2016? express/standard/enterprise?

tried things like sp_whoisactive to see what’s going on?

Are you hitting max worker threads.

Also language setting on the login to the server too.

each sql based login/group will have a language format that will have impacts to dmy mdy settings

If you can select from the table it wouldn't be a privileges issue, as it doesn't use anything like dynamic data masking or anything to hide data.

Unsure what is happening,...

Your missing half the document, right at the end you open a new InterfaceDefinition and then don't close it, you also done close the datasheet, that is not a full...

And can you share the query which is using the linked server?

Your missing the bracket at the end of display name.

Cloc is the character location

lng in the length of that particular segment