An Overview of Running Db2 in Containers

One of my steepest learning curves in the last year and a half has been really getting into containers on K8’s and Docker and what running databases within them means. I thought I’d share a general overview, and plan to follow this post with more specific and more...

The Developer-DB Love-Hate Relationship

There’s a reason why database administration or engineering remains a separate specialty. There are a large number of rabbit holes you can go down. I’m well aware that there’s probably 40% of Db2 LUW alone that I don’t know, even though I’ve spent 20 years working...

It Matters Where Your Join Clauses Go

Explicit Join vs. Implicit Join When writing SQL there are two places you can define how tables are joined. The first is explicit, and is specified after the the keyword ON in the join clause like this: SELECT * FROM table_a as a JOIN table_b as b ON a.id=b.id The...