Top posts of the year – 2011

So it’s surely a cliché, but since many of my favorite bloggers are doing it, I thought I’d jump on board. So here’s my list of top posts this year. Given the fact that I’m nowhere near 2,000,000 views like…

The WebSphere Commerce Data Model

So I have several posts already on this topic. It’s a big topic, and I imagine I’ll write many more posts on it. But I thought something kind of general would be good. I’ve talked about 10 Commerce Tables You…

Come listen to me on the DB2Night Show

So I’ve got a spot coming up on the DB2Night Show – a popular db2 webcast. I’ll be talking about tips for e-commerce databases in general, not just for WebSphere Commerce databases. Come and listen!     The DB2Night Show…

The basics of Index Design for DB2

The keyword in the title of this post is “basics”. I spend some time training SQL Server or Oracle DBAs on DB2, and so this is the answer on the most basic level to how to identify indexes to add.…

Commerce Database Facts

So these are miscellaneous things that I sometimes note about Commerce databases. Though some of the details here may reference DB2, the basic facts are RDBMS-independent, so they would be true for Oracle Commerce databases as well as DB2 ones.…

SQL Analysis Overview

So I thought I’d do a short series on analyzing SQL. I want to focus on some of the techniques I use, so not necessarily everything you could know about it, but some basics on one way to do it. I’m going…

Identifying Problem SQL

Many DBAs have their own methods and approaches in this area,  but there are some basic sources and methods that I use. I’ll cover at least the basics of SQL  analysis in one or more future posts Get SQL from…

What are Parameter Markers?

Parameter Markers Parameter Markers show up as ? in queries when you look at them in a dynamic SQL snapshot or in the sysibmadm views. They show up when the value for a variable is not hard-coded at the time…