Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (May 16 to May 22). Here they are, in order of popularity:
You're probably not using all the datatypes available to you in PostgreSQL - there are actually quite a few. And that's not to say you should be using all of them, but it's always interesting to know what's out there, and to that end, Craig Kerstiens has made a list with descriptions and warnings.
The author previously written about the new replication protocol that comes with GTIDs in MySQL 5.6. Because of this new replication protocol, you can inadvertently create errant transactions that may turn any failover to a nightmare. Let’s see the problems and the potential solutions.
SQL Server is known to have a very strict interpretation of the SQL standard. In this article, the author discusses a number of ways to handle ORDER BY clauses in SQL Server.
Today, the author will review MySQL Fabric’s HA concepts, and then walk you through the setup of a 3-node cluster with one Primary and two Secondaries, doing a few basic tests with it.