Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Microsoft announces the next version SQL Server for Windows and Linux

techcrunch.com

Post reply on HN
Print view View original

31–40 of 92 posts

Re: Microsoft announces the next version SQL Server for Windows and Linux

#31

Post by dhd415 »

jamra wrote: post #30
rch wrote: post #15

> 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. This aspect is interesting. What I haven't 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 sur…

I'm not sure what it means. Do you have no restrictions on developer tools only or do they remove the 10GB database size restriction for SQL Server Express, the free version.

Lots of previously Enterprise Edition-only features such as table partitioning and data compression are now available in Standard, Web, and local editions. This is a pretty big deal. More detail here: https://sqlperformance.com/2016/11/sql-server-2016/big-deal-...

Re: Microsoft announces the next version SQL Server for Windows and Linux

#32

Post by emcrazyone »

I've not looked at MS-SQL in a long time. My business ships software using PostgreSQL.

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?

Consider too, PostgreSQL runs under Windows as a service too.

What does MS-SQL have that PostgreSQL does not?

Re: Microsoft announces the next version SQL Server for Windows and Linux

#33

Post by wila »

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.

The one thing in the article that puzzled me is:

  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
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.

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)

Re: Microsoft announces the next version SQL Server for Windows and Linux

#36

Post by bsg75 »

wila wrote: post #33

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. The one thing in the article that puzzled me is: 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 Wasn't there a golden…

I would assume that the Mac version is not intended to be a production server, but a convenience for developers.

I would also not assume MS will be supporting Mac servers in production because of the small market share for things like RDBMS hosts.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#37

Post by samch »

emcrazyone wrote: post #32

I've not looked at MS-SQL in a long time. My business ships software using PostgreSQL. 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? Consider too, PostgreSQL runs under Windows as a service too. What does MS-SQL have that PostgreSQL does not?

There will undoubtably be a number of good responses here to your question, but I'd like to share my opinion. For me, the answer comes down to tooling. I make frequent use of Integration Services, Reporting Services, the Server Agent, Profiler, and other services I'm not remembering at the moment. In my mind, SQL Server represents an ecosystem of tools and services that are simply part of the package (no additional cost) and are fully supported and integrated as part of a comprehensive suite.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#39

Post by bsg75 »

emcrazyone wrote: post #32

I've not looked at MS-SQL in a long time. My business ships software using PostgreSQL. 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? Consider too, PostgreSQL runs under Windows as a service too. What does MS-SQL have that PostgreSQL does not?

If they ported query parallelism across CPU cores as base MSSQL on Windows has, that would be a significant differentiator for those in the DWH / analytics space.

Its also likely this is a attempt to keep customers on the MSSQL platform who otherwise don't have a need for a commercial OS, and may be willing to keep paying for MSSQL while cutting their OS expenses.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#40

Post by dhd415 »

emcrazyone wrote: post #32

I've not looked at MS-SQL in a long time. My business ships software using PostgreSQL. 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? Consider too, PostgreSQL runs under Windows as a service too. What does MS-SQL have that PostgreSQL does not?

I love pgsql and it has some features that SQL Server does not, but SQL Server also has a range of features that pgsql does not including index-organized tables, automatically-updated materialized views, much more mature support for query parallelization, etc. Lots of the discussion in this older thread is still relevant: https://news.ycombinator.com/item?id=9464505

Edit: fixed link.

Post reply on HN