You Can’t Marry Your Database, But You Can Have Relations

There’s something you should know about relational databases. They were designed to store data efficiently, protecting the quality of the data written and stored to disk. I’ve written before about relational engines favoring data quality and integrity, and how relational databases were not designed for the reading of data. Of course, if you are going through the trouble … Read more

Designing a Database: 7 Things You Don’t Want To Do

Your database design is awful. The reason nobody has told you this yet is for one of two reasons: ignorance or apathy. They either don’t know it’s bad, or they don’t care. Well *I* care about bad designs, as I typically bear the burden of having to make queries run fast and overcome the limits … Read more

Azure Cosmos DB Rising in Latest DB-Engines Monthly Rankings

  The latest DB-Engines Database Rankings are available, and it shows that Microsoft continues to gain ground on Oracle/MySQL: I’ve been following the DB-Engines ranking for a few years and would encourage you to do the same. The rankings are not an exact science. You can read for yourself how they are calculated. One thing … Read more