BrianJarrett.com

This past Tuesday I attended a presentation by Bill Inmon concerning his new concept: DW2.0™. I already knew a little about Inmon methodologies, at a high level, and-ironically enough-have recently become familiar with his “Corporate Information Factory” (CIF) approach because of my recent Kimball training in Chicago. I’ve never really put a lot of faith into most of Inmon’s methodologies, frankly because they seem to make more sense in the world of theory than they do in application. Kimball works and it works well. I could devote and entire article to the differences between Kimball and Inmon methodologies but that’s out of scope; I’ll maybe tackle that another day.

The scope of this article, however, is the Inmon presentation. Or maybe I should call it a sales pitch. Regardless …read more »

Someone in my Data Warehouse Lifecycle class in Chicago took up a list of e-mail addresses so we could all keep in contact and utilize each other for information. To more easily allow for this I quickly threw together a forum that we could all use, particularly because I found very few, if any, DSS (Decision Support Systems) forums that were worth anything.

So I decided to go ahead …read more »

Getting Spam Assassin Working with Procmail and Postfix on a Fedora Core 5 Server

I bought brianjarrett.com in 2003, set up e-mail there, then kept it spam-free for three years. Then, it came. It was slow at first, only fifty messages a week maybe. It wasn’t long until it turned into fifty or a hundred a day; hundreds and hundreds by the end of any given week. On the client side Thunderbird did an okay job with it and Outlook 2007 did a better job with it but it was still a major pain in the ass, sitting there and waiting while Outlook churned through message after message promising pre-approved loans, penis enlargement, cheap Viagra, mini-RC cars, and messages about how some girl starting dating this guy but his “member” was too large for her mouth and she practically choked.

Now as sorry as I felt for this girl I just couldn’t stand the e-mails anymore. I thought about changing my e-mail address once again …read more »

Finally I was able to upgrade my site to Wordpress 2.3 . Initially it broke during the process and I had to restore everything then try again when I had more time. Turns out the BlogStats plugin didn’t work and I had what appears to be a deprecated category function call in my theme (wp_list_cats).

One of the more interesting things with this upgrade is tags. Tags, at least how I’ve implemented them, are sort of like micro categories. I like to think of categories as macro and tags as micro. For instance …read more »

I hate to give this any more press than it’s already received but I felt like I needed to mention it, at least to prove a point. Apparently Kathy Griffin used her right to free speech (as our founding fathers intended) and made a few off-color remarks during the acceptance of an Emmy. According to Excite news…

Griffin said that “a lot of people come up here and thank Jesus for this award. I want you to know that no one had less to do with this award than Jesus.” She went on to hold up her Emmy, make an off-color remark about Christ and proclaim, “This award is my god now!”

So apparently a Christian theater group had “had enough” and released these comments. …read more »

Richard Dawkins elegantly and effectively answering the question.

Here’s a tip I picked up from a co-worker (thanks Matt H.) a few years back during a big ETL rewrite he and I were doing for the company I worked for. First off, I don’t recommend doing ETL in Perl. Perl is interpreted, which makes it a little slower, and it also can become a maintenance nightmare. I love Perl but coding ETL in Perl is exhausting. I’d recommend using something like DataStage, Informatica, or Data Integrator instead. Those programs are expensive though, and if your company is on a tight budget they might not spring for any of those tools. Perl is free and that really is one of the cheapest ways to go about this. We’ll proceed under the premise that you’re left with no other options.

This code snippet can be used for a fact table load job. I’m presuming a working knowledge of Perl, ETL, SQL, and dimensional modeled (star schema) databases here. This also presumes you have knowledge …read more »

Perl has no built-in “trim” function so you have to write your own using search and replace and regular expression matching. Below is simple trim function that will remove spaces from the beginning and end of any string …read more »

Traci in 1978

Traci in 1978

Orson in 2007

Orson in 2007