Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (June 20 to June 26). Here they are, in order of popularity:
For some years now, one of the first things the author has dropped into any new project has been ELMAH. It’s neat stuff, but also an absolute firehose of exceptions. But this isn’t intended to be an ELMAH-bashing session; rather, it’s to look at the next evolution of error logging, and that’s what brings us to Raygun.io.
In a previous post, the author showed a simple HA setup managed with MySQL Fabric, including some basic failure scenarios. Today, he’ll present a similar scenario from an application developer’s point of view, using the Python Connector for the examples.
In this article, the author discusses the importance of primary keys in relational databases and the types of primary keys and strategies for generating them, including natural keys and surrogate keys.
If you're a fan of PostgreSQL, you'll certainly be interested in Postgres-XL. It's a scalable database cluster based on PostgreSQL, open source and fully ACID. The home page points to a few different use cases, including large-scale data capabilities with MPP and ease of database scaling.
Hadoop is a standard when it comes to Big Data, and SQL is a standard when it comes data storage, so it makes sense that SQL and Hadoop would sometimes overlap. In those cases, you end up with SQL-on-Hadoop solutions.