At first it would overheat because the connection between the watercooler and its controller got loose. Long live the internet for instructions.

Also had some fun misreading the windows license a...

The joy of assembling a new pc and it boots

Good luck, thanks for posting the createMSDB

Pretty pre-pandemic in Belgium.  Work from home is more tolerated than pre-pandemic (up to 3 days in a week).

Lives returned to normal with only the healthsector wearing masks. The flu...

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