While I am a general Linux admin, I have never administered or used PostgreSQL, although I do admin a few MySQL instances. I have just been told that a system currently hosted on SQL Server 2008 R2 is ...

SQL stands for Structured Query Language. It’s a standard language for accessing and manipulating databases. MySQL is a database management system, like SQL Server, Oracle, Informix, Postgres, etc.

Let’s start by reviewing some of the leading knocks against MySQL: MySQL 4 and any version of MySQL over the MyISAM storage engine are missing some basic SQL standard transactional capability. They ...