Db2 Experts on a Data Science Quest
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.
Relational databases require queries to specify what data they want returned with no specification of where that data is on disk.… Read the rest
Continue reading »
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 similarities and differences.… Read the rest
Continue reading »Moving from being a DBA on a proprietary RDBMS for 20 years to working on an open source RDBMS is teaching me a lot of lessons. Many of them are lessons I expected – remembering how and when to ask for help, getting used to not being expected to be the expert on everything, and technical details around how MySQL does things differently.… Read the rest
Continue reading »
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 covers things like transitioning from Db2 to MySQL or technical writing about database concepts.… Read the rest
Continue reading »
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 obnoxiously large workload hit my production database and the database still performed like a champ.… Read the rest
Continue reading »
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 barely mentioned a database at all in about a month of content, so it’s closer to a month in.… Read the rest
Continue reading »
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.
An index is generally a way of organizing data in a way that it will be quicker to access than scanning through all of a table.… Read the rest
Continue reading »
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, I’ve continued to read job postings, even while reasonably satisfied with my current job.… Read the rest
Continue reading »
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 later this year on Amazon EKS and Azure EKS, but meanwhile, I’ve got the technical preview up and running on my MacBook Pro!… Read the rest
Continue reading »
Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 4. It’s posting on February 1.… Read the rest
Continue reading »
Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 3. It’s posting on December 21.… Read the rest
Continue reading »
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 get to listen to me (seriously, I could hear eyes rolling when I asked for the umpteenth time) has finally worked!… Read the rest
Continue reading »