I have a MacBook with an M1 chip, so (about) the only option for me to run SQL Server is to run it as a Docker container. This works fine for standard SQL, but our application uses some CLR features like
COMPRESS; when I try to use that, it tells me
Msg 50000, Level 16, State 1, Line 45 Common Language Runtime(CLR) is not enabled on this instance.
Enabling it does not work:
EXEC sp_configure 'clr enabled', 1; RECONFIGURE; GO
Msg 15392, Level 16, State 1, Procedure sp_configure, Line 166
The specified option 'clr enabled' is not supported by this edition of SQL Server and cannot be changed using sp_configure.
I found this Stack Overflow post but that is about someone using a custom .NET library; I'm looking for the 'standard' functionality available in SQL Server for Windows.