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 Episode #66: Top 10 tips for E-commerce Databases with guest Ember Crooks
Join us for a Webinar on January 6
Space is limited.
Read the rest Continue reading »

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. There are certainly greater experts on this topic than me, so I don’t claim to have a comprehensive view on Indexing.… Read the rest

Continue reading »

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.

Most tables have generated primary keys

Commerce tends to use sequential numbers for most primary keys, or as a component of a composite primary key.… Read the rest

Continue reading »

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 to focus on what you can do manually with no pay-for-use or even tools that require additional installation tasks.
Read the rest Continue reading »

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 Developers

So the optimum situation is that your developers give you the SQL they’re planning to use in custom code (or better yet, they have a dba write it in the first place).… Read the rest

Continue reading »

Holiday Preparation

What do you do to prepare for the holidays? We’re starting to think about Black Friday for our retail clients in September or maybe even August. Each business has its Black Friday equivalent – the few days each year that account for 5%(or more) of your online revenue for the year – even if they aren’t anywhere near November.… Read the rest

Continue reading »