Re:Microsoft announces the next version SQL Server for Windo...
by samch on Wednesday November 16, 2016 @01:14PM
(#12969695)
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 Windo...
by dhd415 on Wednesday November 16, 2016 @01:16PM
(#12969716)
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.
Re:Microsoft announces the next version SQL Server for Windo...
by edpichler on Wednesday November 16, 2016 @01:20PM
(#12969746)
I think this product in targeted to companies who already have a MS-SQL database, and now can consider use Linux.
Re:Microsoft announces the next version SQL Server for Windo...
by wavefunction on Wednesday November 16, 2016 @01:27PM
(#12969836)
^^^Or even move their on-premise or NOC'd IIS servers into Azure's Linux environment.
Re:Microsoft announces the next version SQL Server for Windo...
by ickler8 on Wednesday November 16, 2016 @02:04PM
(#12970237)
ding ding ding
Re:Microsoft announces the next version SQL Server for Windo...
by bsg75 on Wednesday November 16, 2016 @01:15PM
(#12969701)
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 Windo...
by JimmyAustin on Wednesday November 16, 2016 @06:08PM
(#12972478)
Postgres added query parallelism in 9.6!
Re:Microsoft announces the next version SQL Server for Windo...
by bsg75 on Thursday November 17, 2016 @01:15AM
(#12974833)
Correct, but for a limited set of query plans. It does mean progress is being made however.
Re:Microsoft announces the next version SQL Server for Windo...
by mr_overalls on Thursday November 17, 2016 @09:22AM
(#12977634)
Licensing fees.
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?