As 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
Microsoft has created an apt repository for Ubuntu. That's really nice.<p><a href="https://docs.microsoft.com/en-gb/sql/linux/sql-server-linux-setup-ubuntu" rel="nofollow">https://docs.microsoft.com/en-gb/sql/linux/sql-server-linux-...</a>
The bigger news and unfortunatly <i>hidden</i> 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!<p>See my commit here: <a href="https://news.ycombinator.com/item?id=12969059" rel="nofollow">https://news.ycombinator.com/item?id=12969059</a>
I've not looked at MS-SQL in a long time. My business ships software using PostgreSQL.<p>Does anyone have, in their opinion, compelling reasons why one should consider MS-SQL on Linux for either a new project or potential migrating too?<p>Consider too, PostgreSQL runs under Windows as a service too.<p>What does MS-SQL have that PostgreSQL does not?
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.
Since <a href="https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-vnext-ctp" rel="nofollow">https://www.microsoft.com/en-us/evalcenter/evaluate-sql-serv...</a> is still focused on downloading ISO and cab files for Windows:<p>- Direct link to RHEL instructions: <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-red-hat" rel="nofollow">https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...</a><p>- Ubuntu: <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu" rel="nofollow">https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...</a><p>- Docker: <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker" rel="nofollow">https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...</a>
> all SQL Server users — including those using free edition — will now get access to the developer features that were previously restricted to the Enterprise edition.<p>This aspect is interesting. What I <i>haven't</i> done since all of these open source and cross-platform moves by Microsoft is go back and figure out how tech costs scale with user growth (starting from 0). It used to be no contest (initially), but I'm not sure anymore.
I can still remember an old conference when Microsoft bragged that running windows-only allowed them to remove 20-30% of the Sybase code base as they didn't need the cross-platform cruft.<p>It would be interesting to see how they code for cross platform portability now.
Looks like there are some (most?) unsupported features external to core DB engine ATM (replication, mirroring, agent, SSIS etc. ), but documentation says "The support of these features will be increasingly enabled during the monthly updates cadence of the preview program". Nice.<p><a href="https://docs.microsoft.com/en-gb/sql/linux/sql-server-linux-release-notes" rel="nofollow">https://docs.microsoft.com/en-gb/sql/linux/sql-server-linux-...</a>
This is great news and I am looking forward to be able to use MSSQL from within linux and macOS. Hopefully the client support is going to be cross platform too.<p>The one thing in the article that puzzled me is:<p><pre><code> Thanks to its support for Docker containers, even macOS users will be able to run it.
Indeed, Microsoft is betting on containers as one of the main distribution mechanisms for the preview
</code></pre>
Wasn't there a golden rule to not store persistent data in a container? I can see it being useful for testing, but am wondering if this is going to be suggested for deployment as well.<p>Of course one can locate the database on external block storage, but that makes it less easy to support due to having multiple parts. (not that that is a very big issue)
Is there a ELIF type link for licensing that explains what we are allowed to do with this on Linux? Can I use it for development work on a company owned workstation?
Microsoft 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.<p>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 programming and focus on the UI and apps which is where they make their money anyway. Wine has come a long way with Microsoft's direct help it could support all of the existing Microsoft apps.
Apart from reducing OS bingo (no need to deploy Windows to run SQL Server alongside whatever non-Windows OS you use to run your apps on), what is the selling point?<p>I assume it runs on x86 processors. If I do everything wrong and end up needing a ridiculously powerful machine I can check IBM's POWER-based boxes or Oracle's SPARC machines that run MySQL or PostgreSQL (or Mongo or anything else) and scale vertically well beyond the largest Xeon boxes. But those won't run SQL Server. Being that the case, why not Windows?
So how do I add a sql server instance in a container with an average of 300 million rows per table and a db of average size of maybe 3 tb and not have io issues? Containers do not seem to scale to enterprise besides nosql type operations of let's commit later.
A basic Vagrantfile that will get this going in Ubuntu<p><a href="https://github.com/mbharadwaj/sqlserver-linux-vagrant" rel="nofollow">https://github.com/mbharadwaj/sqlserver-linux-vagrant</a>
Thanks! As of yesterday I was looking to find a way to install it on Ubuntu. I finally chose to use TeamViewer on my home PC but my database didn't connect. I'll try this instead.
Hopefully Microsoft will also provide a proper multi platform node.js client as well as ODBC support.<p>I may aware of tedious, but it's missing a lot of features and I prefer officially supported code.
no announcement of support for mssqlstudio on other platforms yet though right? still, this is excellent - I love my postgres but having mssql on linux is a great option.
> These include advanced features like always-encrypted and row-level security<p>Am I the only one who reads this in their mind as "low-level security" but with an asian accent? Forgive me, please ignore me.