April 27, 2020
Score 10 out of 10
Read Javier Blanque's full review
SQL Server is an excellent product from Microsoft, it is a derivative from Sybase which originally developed the SQL Server form Unix and Linux, and Microsoft purchased it to migrate the DBMS to Windows Server. But the cycle comes full circle, and now Microsoft recommends its use in Linux. The problem with SQL Server is its pricing scheme. Before 2012 it was sold by CPU, but after that, it was priced with licenses for 2 cores each, and its cost is in around USD 4K for the standard version and USD 15K for the Enterprise version. A sound recommendation for Microsoft, go back to your previous licensing scheme if you do not want your user base eroded by open source products like MariaDB or PostgreSQL.
SQL Server has better performance per core than PostgreSQL, when all other variables are equal (sometimes). But if you use all the available resources of your server for PostgreSQL and limit the cores you use for SQL Server (i.e.: to 1/4 of the cores), PostgreSQL runs circles around SQL Server.
In comparison to MariaDB, PostgreSQL adheres better to the standards and has a richer set of primary data types, among other advantages.
MariaDB is a derivative of MySQL, which gives you more freedom (given its license) that could give you Oracle, the actual owner and maintainer of MySQL.