SELECT CompanyB.Value SourceValue, CompanyA.Value PartialMatch
FROM CompanyB
Left join CompanyA
on CompanyA.Value like '%'+CompanyB.Value+'%'

Deploy it at a test instance?

You can decompress a dacpac and view it's xml contents https://learn.microsoft.com/en-us/sql/relational-databases/data-tier-applications/unpack-a-dac-package?view=sql-server-ver16

I don't have experience with sql on linux

What have you tried?

Found an extensive troubleshooting list on stackoverflow https://stackoverflow.com/questions/64876580/sql-server-odbc-tcp-provider-error-code-0x274c

or https://stackoverflow.com/questions/57265913/error-tcp-provider-error-code-0x2746-during-the-sql-setup-in-linux-through-te

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