Indexes are magic, right? Add one and magically the performance of a query improves. Well, not really. Each index has a cost, and thoughtful multi-column indexes will go a lot further than individual indexes. Let’s dig into the details. What…
One of the things that learning a new RDBMS is teaching me is that there are some concepts that are common to RDBMSes. It is helping me to identify some of those concepts, and I learn a lot from the…
The database conference organization I’ve focused on for most of my career – IDUG (International Db2 Users Group) is not interested in cross-platform content. Despite being a top speaker most conferences, they are not interested in content from me that…
There have been a few times in my career where I have been stunned by something I have seen while at work. Sometimes it was the good type of stunned. Like the first time first time I observed a truly…
I’m a couple of months into working with MySQL, and thought I’d share some resources and thoughts on what I’m learning and what is working. At least half of that time was dedicated to a very in-depth onboarding process that…
Many RDBMSes have similar structures and concepts. In this post, I’m going to compare and contrast IBM Db2’s concept of a clustered index and MySQL’s concept of a clustered index. Index vs. Clustered Index An index is generally a way…
I’ve struggled to write this blog entry to appropriately convey all aspects of what I want to say. This is my third attempt, and I finally think it does things justice. As part of my publicly shared data science journey,…
Db2u is here as a technical preview! I’ll cover the basics of how to set it up for a local sandbox, and leave the details and whys to future articles. IBM has stated that db2u will be available in GA…
Earlier in 2021, I wrote an article on the big mistake I thought IBM was making by only offering their container-native version of Db2 (db2u) on RedHat OpenShift. Well, that article and tirelessly asking questions of EVERY IBMer I could…
What is a Buffer Pool? A buffer pool is one of the most critical memory areas for a Db2 database. Buffer pools are used to cache data in a way that the data can be reused by other connections. They…
Recent posts related to using Docker with Db2: An Overview of Running Db2 in Containers Where do Db2 Containers Come From and How are they Used The focus of this article is to go through a few of the basics…
I’ve spent much of the last year or two on a containerization and DevOps crash-course. I’m just recently starting to come up for air and fill in some of the gaps that being neck-deep in the how leave in in…
