I am not sure if this will help you.   I had a similar situation with a table with large number of fields.   I concatenated all the fields together to one...

I saw this article on connectivity ring buffer error.   Please see below

https://www.sqlskills.com/blogs/erin/the-security_error_ring_buffer_recorded-event-and-why-you-dont-need-it/

Here is a possible way to record the SQL logins into a custom table that may be...

You may use SQL server profiler to see where your job is failing.  Sometimes, the windows event viewer - application can help.  You may use a debugging SQL server table...

This would be difficult to do how much time it will take for the subscriber database to receive the replicated commands and process them  from the distributor.  Network performance, disk I/O,...

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