Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

Database administrator with 14+ years of hands-on experience in database management and database design. After 15 years of managing Oracle databases across various enterprise environments, I can ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

If you’ve always been in awe of folks using the Google Search Console API to do cool things, this article is a good read for you. You can use BigQuery with the GSC bulk data export to get some of the ...

Databases are often assumed to have definite content. The reality, though, is that the database at hand may be deficient due to missing, invalid, or uncertain information. As a simple illustration, ...

This library can be used to configure triggers on a SQLite database such that any inserts, updates or deletes against a table will have their changes recorded in a ...