Hacker News new | ask | show | jobs
by draebek 1473 days ago
I know of Azure SQL Edge, which has significant limitations, but I don't know how to run MS SQL Server on an M1 at anything more than glacial speeds (i.e. full system emulation in Qemu). Is there something I don't know about? Please share!
1 comments
my123 1473 days ago
the Drawbridge environment has some peculiar needs that most JITted envs don't provide. So unlikely to work but will test that out soon...
link
draebek 1473 days ago
If you're speaking about the existing technique MS has developed to run MS SQL on Linux, it doesn't work on M1s in Docker under Qemu user emulation: https://github.com/microsoft/mssql-docker/issues/668

That's 2019. I haven't tested 2017 or 2022, but I assume they don't work either. AFAIK the official advice is to use Azure SQL Edge instead.

link
my123 1473 days ago
qemu-user is indeed hopelessly unsuitable for any kind of heavy use. Use anything else. :)

But that doesn't answer the question of "does Rosetta deal with it properly?".

link
my123 1473 days ago
SQL Server doesn't work under Rosetta.
link
draebek 1473 days ago
Oh! Sorry, I didn't realize you were going to try it under Rosetta. That is very disappointing that Rosetta doesn't do any better. Thanks for testing.
link