SQL Server is really Sybase tho, which was always capable of running on UNIX.
Can't say much more, but I worked on a huge (internal) Sybase ASE on Linux based app (you've _all_ bought products administered on this app ;) ) way back (yes, pre-SSD, multi path fiber I/O to get things fast, failover etc.) and T-SQL is really nice, as is/was ASE and the replication server. Been about 20 years tho, so who knows.
I worked with SQL Server a bit, writing a Rust client for it back in the days. The manual is really good, explaining the protocol clearly. That made it really easy to write a client for it.
SQL Server uses NT and Win32 APIs, so the SQL team built a platform independent layer. Meaning NT and Win32 is still used by SQL on Linux. It’s pretty cool tech.
I guess wording wise for my comment, the "Hah, they didn't actually write that themselves, they just bought the Sybase rights to everything license" got the better of me :)
To be fair again, from what I hear, SQL server at Microsoft did some nice things on top of Sybase but the base, T-SQL, is just nice overall and by itself. I really want to like Postgres (and I do) but some of the awesome things I had with actual Sybase ASE 20+ years ago, Postgres still does not have. And that was a piece of software that had those features I loved for 10+ years prior to when I started working with it. The app we're talking of here was 15 years old when I worked on it 20+ years ago and it's probably still around and very probably still uses Sybase ASE (tho the actual app was converted from Smalltalk to Java ;)
I also later on had to use Oracle and had the same "WTF? You can't do that?" experience :shrug:
Can't say much more, but I worked on a huge (internal) Sybase ASE on Linux based app (you've _all_ bought products administered on this app ;) ) way back (yes, pre-SSD, multi path fiber I/O to get things fast, failover etc.) and T-SQL is really nice, as is/was ASE and the replication server. Been about 20 years tho, so who knows.