RowStore tables and B-Tree indexes are not part of the SQL standard. SQL is a high level abstraction and integration layer than can be stacked on top of a wide...

I see the database platform debate as being similar to the construction industry's wood, brick, concrete, steel, glass debate. Most modern buildings incorporate all the mentioned construction materials, leveraging the...

All this talk about NULL makes me hungry for a burger and fries. 🙂

I believe it's way past time that digital companies were held to the same standards as other corporate entities and public institutions. The way it works now, information like medical...

The thing about NULL is that it's meaning is contextual, and even different SQL dialects treat NULL differently by default, which can be a problem for those who work in...

.. There's always a schema, and the rules have to be implemented up front, or later on. Whether you use a RDBMS or a NoSQL store, you are going...

When we're talking about DevOps in this context, it's sounds like we're talking about a change tracking process that integrates database development and administration; something like JIRA / BitBucket /...

It would be very helpful if the data truncation error message were more like the duplicate key message, having the actual column name and offending value are included.

If...