Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.

Optimizing the performance of operational databases and the applications that access them is a constant battle for DBAs. Of course, writing efficient SQL is the most important aspect of ensuring ...

Schema design, indexes, queries, configs, I/O... what could go wrong? Follow these 10 essential tips to keep your MySQL servers humming. MySQL is the world’s most widely used open source database, and ...

A new generation of graph databases has taken hold, and a generation of query languages has arrived alongside them. The assorted graph database query languages include the likes of Gremlin, Cypher, ...

When I started writing SQL, I was never worried about security; I was worried that I would write a bad query that would crash the database. And it was really easy to write SQL that would consume 100 ...