This doesn't seem to be a bona fide port to Linux. The sqlservr binary seems to load some .sfp files in the lib directory of the installation, and those files seem to include a good chunk of a Windows installation. There's registry hives, batch commands, and what look like PE64 executables in there.
Microsoft announces the next version SQL Server for Windows and Linux
61–70 of 92 posts
Re: Microsoft announces the next version SQL Server for Windows and Linux
#62The bigger news and unfortunatly hidden behind an innocent blog title about SP1 for SQL Server 2016 is that now all the features of Enterprise Edition are available on all editions of SQL Server!
See my commit here: https://news.ycombinator.com/item?id=12969059
Re: Microsoft announces the next version SQL Server for Windows and Linux
#63The bigger news and unfortunatly hidden behind an innocent blog title about SP1 for SQL Server 2016 is that now all the features of Enterprise Edition are available on all editions of SQL Server! See my commit here: https://news.ycombinator.com/item?id=12969059
Not quite all features. AlwaysOn Availability Groups is still limited to two hosts in Standard, and Standard still doesn't have Transparent Database Encryption.
Even so, this is an exciting change!
https://www.microsoft.com/en-us/sql-server/sql-server-editio...
Re: Microsoft announces the next version SQL Server for Windows and Linux
#64Earlier quoted context omitted.
So I can install with apt-get in WSL on Windows instead of using the normal Windows installer? Full circle.
Funny, but I'm not sure it would actually work. Sockets are not fully supported on WSL - for example, you can't run an SSH server.
That's odd given how easy it is to shim the Linux/POSIX socket API - most of it anyway - on Windows. I made good money back in the day by writing server software that had to compile and run on both Windows and Linux (actually it was never deployed on Windows, but on an embedded Win32 compatible OS, but they were planning to move to Linux, so I did all development on Windows, tested on whatever embedded platform they used and Linux) - the "compatibility" layer was a few dozens of lines in a header file.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#65Microsoft has really adopted an if-you-can't-beat-em-join-em attitude these days. There were times when Microsoft and Linux were at such odds that an announcement like this seemed impossible. The next smart move I'd love to see from Microsoft is similar to Apple's adoption of BSD as their base OS with the introduction of OSX, an adoption of Linux as the base Microsoft OS. They could stop wasting money on systems prog…
NT is decent. It's a lot of the stuff that runs atop of it which is garbage and WINE is nowhere near stable enough to be a viable replacement.
Like I said, with Microsoft's help Wine could be awesome.
NT might be decent but it's not great. Why waste resources on it when they could be put to more lucrative use?
Re: Microsoft announces the next version SQL Server for Windows and Linux
#66As someone who has been working with them on pushing this live for the last 6 months I can tell you, we're all very excited to finally push this public preview
I signed up early on as I have an old OSS project that supports MySQL/PostgreSQL and MSSQL. I had originally tried to set up a full CI environment using Vagrant, but automating the Windows/SQL part became so much of a pain I gave up on it.
I'm really thankful that they released Docker containers!! I was planning on moving the entire CI system to Docker anyway and this totally fits in, plus it's super easy to accept the EULA and run the evaluation container.
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...
Re: Microsoft announces the next version SQL Server for Windows and Linux
#67Microsoft has really adopted an if-you-can't-beat-em-join-em attitude these days. There were times when Microsoft and Linux were at such odds that an announcement like this seemed impossible. The next smart move I'd love to see from Microsoft is similar to Apple's adoption of BSD as their base OS with the introduction of OSX, an adoption of Linux as the base Microsoft OS. They could stop wasting money on systems prog…
I doubt that will happen. There are innumerable man-hours of engineering sunk into Windows, and it has made them lots of money. Unless there were compelling proof that continuing to develop and support Windows was costing them money, and endangering other profitable revenue streams, Microsoft will likely keep Windows alive.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#68The bigger news and unfortunatly hidden behind an innocent blog title about SP1 for SQL Server 2016 is that now all the features of Enterprise Edition are available on all editions of SQL Server! See my commit here: https://news.ycombinator.com/item?id=12969059
[deleted]
Re: Microsoft announces the next version SQL Server for Windows and Linux
#69The bigger news and unfortunatly hidden behind an innocent blog title about SP1 for SQL Server 2016 is that now all the features of Enterprise Edition are available on all editions of SQL Server! See my commit here: https://news.ycombinator.com/item?id=12969059
They haven't made all of the Enterprise Edition features available on all lower editions, but they have made many big ones such as table partitioning, Always Encrypted, in-memory OLTP, etc. available in most lower editions. There are a number of operational features such as piecemeal restores, Resource Governor, online index rebuilds, etc. that are still exclusive to Enterprise Edition.
There's a more complete discussion of these here: https://sqlperformance.com/2016/11/sql-server-2016/big-deal-...
Re: Microsoft announces the next version SQL Server for Windows and Linux
#70Microsoft should have his own Linux version, supported by the company. It will be inevitable.
Instead of that, I can see them partnering up with Red Hat (and/or Canonical) to handle it. All of Microsoft's "-on-Linux" offering (i.e. SQL Server, .NET, etc.) will be officially supported on RHEL (and/or Ubuntu), just like many other enterprise-type products today are officially supported only on RHEL.