From performance to programmability, the right database makes all the difference. Here are 13 key questions to guide your selection. Picking the “right” database can often be critical to the success ...

I am starting this new year the same way I ended the last: taking antibiotics because my biological daughter brought home a nasty sinus bug from Carnegie Mellon’s preschool. This was after my first ...

A year ago support for nested data types in Excel was announced on the Excel blog, but the announcement didn’t have much detail about what nested data types are and the docs are quite vague too. I was ...

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...

pre-commit is a nice development tool to automatize the binding of pre-commit hooks. After installation and configuration pre-commit will run your hooks before you commit any change. CREATE OR REPLACE ...

For regular readers of this blog, you may recall a blog post by Carlos Figueira on working with SQL server time values. In it, Carlos used the Mid, Find, Substitute, and other functions to parse an ...