You use the SQL server enterprise which allows you to use High Availability groups.  You may use a separate SQL installation and allow them to communicate with each other for...

Please use : SQL server configuration manager to adjust your TCP/IP port.  Always disable shared memory due to security reasons.

To change the port assignment right-click on the TCP/IP protocol and...

Very simple example:

sqlcmd -S <ComputerName>\<InstanceName> -i <MyScript.sql> -o <MyOutput.rpt>

Just use a sqlcmd SQL script with the function below using a windows scheduled task in a batch file:

If  datepart(dw,getdate()) = 7

...

You may be looking at : Memory pressure / CPU pressure / tempdb contention / missing indexes.

Jonathon K.  could have good suggestions for you on performance issues.

Here are few things...

I think you do not need the "Group by":

SELECT TOP (1) DateTime,

MAX(CASE WHEN TagName = 'WFI_LP01_Cond.PV' THEN value END) AS Cond,

MAX(CASE WHEN TagName = 'WFI_LP01_Temp.PV' THEN value END) AS TempAtMaxConductivity

FROM...

From Brent Ozar,

Rebuild: An index ‘rebuild’ creates a fresh, sparkling new structure for the index. If the index is disabled, rebuilding brings it back to life. You can apply a new fillfactor...

It looks like you got what you needed.  I would suggest to have an error table / file to capture the error records with a time stamp.  Then you can...

I am not familiar with the ZERTO product.  I would agree "ALWAYS-ON" is a proven/effective replication technique.  There is also transactional replication w/o log shipping.  If you have small/medium size...

The limit of 1gb is for a singe SQL instance. You can create extra instance and that will use 1gb also.

The restriction of memory is for buffer cache. SQL Server...

From other sources:

The current master key cannot be decrypted. If this is a database master key, you should attempt to open it in the session before performing this operation. The...

The following must be in your select statement:

(CASE WHEN displayorder IS NULL THEN 1 ELSE 0 END)

You will require an additional T-SQL variable.

Cheers

The following site has some useful information:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/reporting-services-with-always-on-availability-groups-sql-server#bkmk_requirements

Regards,

Greetings,

Please review the following Web site:  (setting up the SSIS package should be done as explained in this site.)

https://www.mssqltips.com/sqlservertip/3119/import-utf8-unicode-special-characters-with-sql-server-integration-services/

Please test your solution in a...

Greetings,
You could partition the huge SQL server table to partitions to alleviate the heavy burden.  Then you can apply indexes much easier to different file groups.   Please see additional comments...