Take the http-url

replace http with https

leave out the :80 portnotation

https://myserver/Reports should respond

or in your case a named instance https://myserver/RPT01/Reports

The logfile is used to keep a record of done / pending tranasctions till the logfile has been backed up. This in order to make it possible to redo all...

Does it trigger when you start the service and terminate it using taskmanager?

Could it be it doesn't get triggered because it never started (due logon mismatch)? Can you test the actions without bat-file? Do they trigger?

What's the security on the bat-file

https://blog.stephencleary.com/2020/06/servicebase-gotcha-recovery-actions.html

Welcome back Jasona

MySQL <> MS SQL Server

Is the query source MySQL ( as per driver mysql.data)

or MSSQL Server?

As Ed B mentioned, there are some differences in syntax

Can't reproduce it

DECLARE @source varbinary(4000)=0x0200000022695FA76ADC377F399412C032EFA78DA0E0DA5F2A7E20D880D6465AC72AD152;
SELECT CONVERT(NVARCHAR(100), DECRYPTBYPASSPHRASE('Key',@source)) AS SSN

Results in ABC on different collations

Not familiar with partitions, but partitioned views seem interesting to minimize downtime.

https://www.sqlshack.com/sql-server-partitioned-views/

Moving to a new partition with split range https://medium.com/@MadhavanR51/add-new-partition-range-to-the-sql-server-partitioned-table-split-partition-range-60e197c2f73d

Rowlock: avoid escalation to page/tablelock

More detail: https://learn.microsoft.com/en-us/answers/questions/150070/sql-server-when-to-use-rowlock-updlock-etc

Why do you COALESCE (os_user_name, '')<>'anon'? If os_user_name is null it is different than anon

Why do you make @_batchSize dynamic?

You might want to use a temporary table to store your...

You can also investigate https://github.com/spaghettidba/XESmartTarget

You can capture blocking session with extended events https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/understand-resolve-blocking

Have you enabled query store? Whilst 2ms probably won't show up, the 16 sec and 25 sec durations would

Single user for clustered instances: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-in-single-user-mode?view=sql-server-ver16

1. I am not aware of such setting. On shutdown
2. Using the kill command ?
3. Query sys.dm_exec_connections ? Not sure if you can measure idle time
4. Setup an extended event...

Celko, why did you choose CHAR(10) whilst an int works perfectly? Certainly in the age of anomized data

I didn't get the course "Since an identifier has to be on a...