Excellent post by the Digg development team explaining why they have to move away from SQL, and the results they accomplished when migrating one of their features to Cassandra.

Very impressive.