Microsoft announces SQL Server for Linux

Posted Mar 8, 2016 3:06 UTC (Tue) by Cyberax (✭ supporter ✭, #52523)
In reply to: Microsoft announces SQL Server for Linux by bronson
Parent article: Microsoft announces SQL Server for Linux

SQL Server is still better than Postgres - it has more features and is faster on many workloads.

Also, the development and ops tools for MSSQL are the best in industry. There are also solutions for MSSQL for stuff like auditing and logging for compliance purposes.

It's really one of the few products that MS does very well, the other ones being ActiveDirectory and Exchange.

Microsoft announces SQL Server for Linux

Posted Mar 8, 2016 4:22 UTC (Tue) by ringerc (subscriber, #3071) [Link]

Yep, MS SQL has significant advantages in a number of areas.

I don't know if it's "better" or "worse" than PostgreSQL, but it certainly does very much better for things like individual big queries, where its ability to parallelise queries makes a big difference. Its management and monitoring tools are also worlds ahead. OTOH I think PostgreSQL is more extensible and it's certainly a lot more customisable, even allowing for MS SQL's rather nice .NET integration.

I work on PostgreSQL and I'm hoping that this will help motivate others involved in Pg to stop dismissing MS-SQL and start learning from it.

Microsoft announces SQL Server for Linux

Posted Mar 8, 2016 12:34 UTC (Tue) by oldtomas (guest, #72579) [Link] (3 responses)

I was giving you the benefit of the doubt until...

> Exchange

...this. Now I don't know what to believe.

Microsoft announces SQL Server for Linux

Posted Mar 8, 2016 12:56 UTC (Tue) by ewan (guest, #5533) [Link]

Exchange is very good at what it does. However, what it does is provide a nicely integrated 'groupware' setup for organisations that actually use it to organise meetings, have calendars and correspondence delegated to secretaries and PAs and things like that. On the side it also happens to have a terrible email server built in.

Microsoft announces SQL Server for Linux

Posted Mar 8, 2016 14:13 UTC (Tue) by drag (guest, #31333) [Link] (1 responses)

As a user forced to interact with Exchange daily I despise it. As a IT administrator (if I was one) for mid-sized corporation then Exchange would be the obvious choice.

It's worth taking the time to understand why people like this software. If you have the attitude of 'well they are ignorant of better things' then it's easy to miss a learning opportunity.

Microsoft announces SQL Server for Linux

Posted Mar 9, 2016 0:23 UTC (Wed) by rahvin (guest, #16953) [Link]

Whether people like exchange or not, it's functionality has more than 15 years of business cooperation behind it's features. Microsoft did one thing very well for a very long time and that was to work with enterprise customers to satisfy feature requests. People complain about all the things office can do that most people don't use but those features come from extensive feedback and customization requests by enterprise customers. Exchange is the same game, it may do a lot of stuff badly but it's combined features are often significantly ahead of anyone else. And there are a lot of those features that are killer features for a lot of businesses.

Microsoft announces SQL Server for Linux

Posted Mar 8, 2016 15:37 UTC (Tue) by epa (subscriber, #39769) [Link]

It's really one of the few products that MS does very well, the other ones being ActiveDirectory and Exchange.

What these have in common is that they were all developed outside Microsoft.