Alright, so I’m playing around with something. I’ve developed a bit of a TikTok addiction after exploring the platform to connect with my 14-year-old. One of the post types I’ve enjoyed is the “Roll for ______” type, where the content creator uses dice typical to Dungeons and Dragons to choose combinations of things that are sometimes magical, sometimes ridiculous, and occasionally disgusting.… Read the restContinue reading »
Every RDBMS has areas where the differences from other RDBMSes are noticeable, and this is one of them between Db2 and MySQL. Most RDBMSes have quirks to the way SQL is written, and this is certainly true of Db2 where some things were there before the SQL-92 standard or other standards existed.… Read the restContinue reading »
I’ve spent some time understanding how MySQL structures tables and indexes, and wanted to share what I’ve learned. This is not the structure as created in the
CREATE TABLE or
CREATE INDEX statements, but how that data is generally structured on disk, both logically and physically.… Read the rest
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 restContinue 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 restContinue 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.
Index vs. 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 restContinue 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 restContinue 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 restContinue reading »