Skip to main content

· 2 min read

I had to export a GPG key from one Linux host to another today. While that is not something that's particularly difficult, it is one of those tasks that I do frequently enough to be worth remembering, but not enough to actually remember. So, it makes sense to document the process somewhere, and since it may help others, here it is ;)

· 8 min read
IBM DB2

I have a number of DB2 stored procedures that must use the NSE CONTAINS scalar function with optional search parameters. It turns out, that if you write such stored procedures in the most obvious way, then the performance is terrible. However, with a little insight, and some resulting tweaks, such stored procedures can be sped up immensely - eg more than 1,000 times!!

But first, let me explain what I mean by "optional search parameters". Basically, what I mean is stored procedures that return a result set based on a number of potential filter parameters, where the an NSE search string is just one of many possible filters.

· One min read

It's not everyday that you see evidence that a company is actually being innovative with their product designs... it's for that reason, I was pleasantly surprised by this BMW GINA video.

· One min read
AMD ADD3800IAA5CU

I'm very excited about having just won an ADD3800IAA5CU processor on eBay for just AUD$42. So what's so special about this processor? Well, put simply, its the only 35 watt dual-core 64-bit processor ever made (yet) for standard desktop motherboard sockets (AM2 in this case).

Sure, you can can some processors with lower power ratings, such as certain Turion and Core 2 Mobile models, but they require special (and very expensive) motherboards with specific CPU sockets (Socket S1 and Socket M/P respectively).

· 4 min read

For a number of reasons, I've finally switched from the hopeless Outlook Express to Mozilla Thunderbird... and so far, I really like the change. However, now that I've got Thunderbird, I find myself wanting to import my old Outlook PST file from a couple of years ago...

Now, it's worth pointing out that if you have Outlook installed on your PC, then PST importing is very easy - Thunderbird simply uses Outlook's MAPI interface to request all mail folders. However, if, like me, you don't have Outlook installed, and don't want to install it either, then you need to do a bit more work.

· One min read

I'm currently sitting in (and posting from) the first Adobe AIR Camp in Australia... there's not much going on yet, but the day is young! :)

Currently, Andrew Spaulding is introducing Flex Builder 3... since I've been using it for some time now, this part's a little slow ;)

Okay, now he's talking about using transparent images for application chrome... getting interesting... better go now :)

· 2 min read

In light of the estimated world population passing 6,666,666,666 a couple of days ago, and partially inspired by the inter-character linkages in the movie Love Actually, which I just happened to watch again last night, I got to thinking about the mathematical possibility of the six degrees of separation concept.

So, let's pretend for a moment, that every person on the planet has the same number of unique distinct people that they are "in contact" with. Let's define α to be that number. So if we let n be the number of degrees of separation, then the upper-bound of the total number of people within n degrees can be given by:

αn = α × α × ... × α = αn