News for hackers. Stuff that matters.
Re:Microsoft's “Love” of Linux by ripley12 on Thursday November 21, 2019 @01:01PM (#21597198)
> What makes SQL Server so much better than, say, PostgreSQL or MariaDB?

Tooling and speed. I can vouch for the quality of SQL Server's tooling – SSMS is very nicely integrated with SQL Server.

If you watch the CMU DB Group's lectures on YouTube, they mention that the commercial RDBMSs have put a lot more time+research into query optimization than the open source ones (and apparently SQL Server has the best optimizer).

Re:Microsoft's “Love” of Linux by excursionist on Thursday November 21, 2019 @01:18PM (#21597402)
> Tooling and speed.

That's too vague to be of any use. What tooling? What benchmarks?

> I can vouch for the quality of SQL Server's tooling – SSMS is very nicely integrated with SQL Server.

The fact that you like SSMS doesn't really say anything about tooling for PostgreSQL. I find the quality of PostgreSQL tooling great.

There is certainly plenty of reason to believe PostgreSQL is superior to MS SQL [1]. I don't agree with everything in the referenced article, but your claim of MS SQL being far superior is, so far, completely unsubstantiated.

[1] https://www.pg-versus-ms.com/

Re:Microsoft's “Love” of Linux by ripley12 on Thursday November 21, 2019 @05:00PM (#21600169)
You’re a little combative, huh?

As I’m sure you’re aware, publishing benchmarks of commercial RDBMSs is usually prohibited - I’m just passing on what I’ve heard from an expert about query optimizers.

Re:Microsoft's “Love” of Linux by excursionist on Friday November 22, 2019 @11:32AM (#21607110)
> You’re a little combative, huh?

Interpreting the questioning of your grand claims as combative should tell you something about your own attitude.

> As I’m sure you’re aware, publishing benchmarks of commercial RDBMSs is usually prohibited

I only know that MS and Oracle prohibit publishing such benchmarks - and that's yet another reason not to use them.