DataGeek.blog

SQL Anti-Pattern: Indexing Every Column Individually

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 an Optimizer Does

Relational databases require queries to specify what data they want returned with no specification of where that data is on disk.… Read the rest

DBA Perspective: Open Source vs. Proprietary RDBMS

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

Cross-RDBMS Content?

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

Rollback Statements and the IBM Sterling Order Management System

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

My Early Experience Learning MySQL as a Db2 DBA

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

When an Index is More Than an Index: Clustered Indexes

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 rest

A New Turn in Ember’s Career

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

June 16, 2010 Uncategorized

Stagingprop – SQL0803 “oops, you inserted data directly on production”

So I plan to go through some of the stagingprop problems I've seen - especially the more common ones. This is probably the most common of all, especially if the java developers you're working with have not used Commerce and particularly stagingprop before. Continue reading »

June 15, 2010 Uncategorized

Stagingprop – the high-level explanation

So every client I support has issues with stagingprop at some point. The vast majority of them are due to mistakes made in the development process. Many developers do not fully understand what stagingprop does, so here's a general description that might help. Continue reading »

June 7, 2010 Uncategorized

Registry Variables and DB2_WORKLOAD=WC

I was happy to see the new workload registry variable in Commerce 7/DB2 9. Mostly out of laziness – it requires fewer variables to be set manually, but it also ensures that nothing major is missed (I imagine they may come up with more that won’t be added to the workload registry variable in real time).… Read the rest

June 4, 2010 Uncategorized

DataGeek.blog

SQL Anti-Pattern: Indexing Every Column Individually

What an Optimizer Does

RDBMS Concept: Buffer Pool

DBA Perspective: Open Source vs. Proprietary RDBMS

Cross-RDBMS Content?

Rollback Statements and the IBM Sterling Order Management System

My Early Experience Learning MySQL as a Db2 DBA

When an Index is More Than an Index: Clustered Indexes

Index vs. Clustered Index

A New Turn in Ember’s Career

Stagingprop – SQL0803 “oops, you inserted data directly on production”

Stagingprop – the high-level explanation

Registry Variables and DB2_WORKLOAD=WC

I’m just this guy, you know?

Sticky, gluey, GUIs

Fun with IN-lists and GENROW

5 things that made me a better DBA

Hello world!

Instance Creation in WebSphere Commerce 7 (DB2 9.5)