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...

Overview of Real-Time Monitoring Options For Db2

I thought I’d share an overview of the real-time monitoring options for Db2 (LUW). This article focuses on comparing the options, with links to deeper information on each tool. Types of Monitoring First a quick overview of the types of monitoring that every DBA...

My Journey through Beginner Data Science Content

When I first started learning about data science, the amount of material out there was daunting. It is hard to find your way in what you should learn and how you should learn. I thought I’d share what has been working for me and what didn’t.… Read...

The DevOps DBA – an Overview

The IT industry is a change machine. It is full of change. It always has been. As I get older, I wonder if it really is changing more, or if I’m just becoming set in my ways. DevOps The first time I heard the term “DevOps” many years ago, I thought...