Recent Posts

A long journey starts with a single step...

I was curious about applying the concepts and ideas behind GTD to try to manage my time (both at home and at work) more efficiently so I read up a little about GTD over the weekend and actually ordered a copy of Dave Allen's book (having read snippets in a bookshop who were nice enough to give me a nice leather armchair for my comfort).

I found a lot of good information and interesting ideas at 43 Folders and Lifehacker.

I then heeded the very advice I was slightly disparaging about in a previous article and moved absolutely everything (over 6,000 messages) from my fat, bloated Inbox into a new DMZ folder.

I even spent some time trawling through the dusty, old, antique messages. As I suspected, the vast majority were well past their sell-by date and could be safely deleted immediately. Then I started to detect patterns; if I didn't recognise the author/subject, then it was pretty likely that the complete thread was no longer relevant and could be deleted. Similarly, some authors simply have nothing of interest to say ever; mostly automatons but sometimes human. The DMZ folder was trimmed to less than 400 messages and the whole exercise must have taken less than two hours (and not four days).

Some authors send me valuable technical content (mixed with some dross) so their messages had to be selectively pruned or all messages left intact and a action created to conduct a second pass.

So, today, Monday 9 January 2006, saw the dawn of my new email handling strategy.

If the message contains technical content of interest, it gets immediately filed as 'Reference'. Some messages contain interesting technical content that merits further investigation. This is normally some bold assertions that are unproven or not understood by me (not hard). These lead to an action 'To do sometime'.

If I replied to an email asking for more information, I would delete the incoming message and create a corresponding task in 'Waiting'. The original email thread is accessible from the 'Sent' folder.

I treated any email with an attachment quite specifically. If the attachment was relevant, I separated the attachment which was then filed on the file system. In most cases, the email could be deleted as the information was contained in the accompanying document.

If an email purely provides contact details (name, address, email, phone) etc, I immediately add the contact to my address book. Sometimes, if I am travelling in the near future, I will also print a hard copy so I know where I am going, who I am seeing and where I am sleeping as this always helps.

A couple of messages to lesser used email aliases just needed an new filter rule defining so that this content is automatically routed to a dedicated folder and only spends a few fleeting seconds in the 'Inbox' and my consciousness.

Similarly, I chose to unsubscribe from marketing messages from companies or if I really do want the information automatically filter those messages to a dedicated folder.

The net result is that I now get far fewer messages in my Inbox so it is easier and quicker to process them and the messages that do arrive in my Inbox are far more relevant to me.

So now I look at each email message on arrival. Well that's not quite true. I have started to turn email off if I am working on something that needs concentration to avoid the continual interruption and context switching as I am easily distracted.

Close of play. Inbox - 3. All messages that need to be acted on tomorrow.

Have a look at this blog. Lots of interesting, varied material, frequently updated, nicely presented, excellent use of images, easy to navigate, searchable, well structured and very professional looking. All in all, an excellent blog.

This blog is by Paul Stamatiou, a 19 year old student. A few months ago, I happened across this article on Paul's blog when I first started blogging but stupidly forgot to bookmark it.

This is undoubtedly one of the best personal blogs I have seen. In fact, I was so impressed I did as he suggested and nominated Paul's blog for the 'Best Teen Blog' award.

Paul is looking for a job this summer. Somehow, I don't think he will have any trouble getting fixed up.

Those busy people at WordPress have opened up a couple of forums for support issues and feedback for users of WordPress.com

This is a brilliant idea as I currently have to use the 'Feedback' form for all my brilliant suggestions and reporting minor glitches which was a little lonely and uni-directional.

Dear Cathy and Clare

I am increasingly worried about the size of my Inbox. I am almost embarrassed to admit this but it currently has 6,207 items dating from way back September 2003 (and that doesn't even include 'Archived Folders'). Tom Kyte (who I admire and respect greatly) likes to keep everything in its place, spic and spotlessly span and currently has a single item sitting in his Inbox. And his finger is poised over the 'Delete' button to expunge that one too !

A very organised chap, who knows all about GTD, recommends creating a brand new shiny, empty folder called 'DMZ' and moving all the 6,207 messages into there. Apparently, this single action will produce the illusion of an empty Inbox, produce an enormous sense of well being and contentment (well until the next email arrives in 12 seconds), help me feel better about myself, shed two stones overnight, make friends and influence people, lift a massive psychological burden from my shoulders, help me to get things done, focus on the key objectives for 2006 and finally get that long awaited promotion.

However, I am a little reluctant to trust someone masquerading under the name of '43 Folders'. If he is so clever, why does he even need 43 folders and, more to the point, how many messages are in each one ? Enquiring minds want to know. Also, simply dumping my beloved email archives into a demilitarised zone would fill me with guilt. I would hate to think of all those technical nuggets, match reports, humorous anecdotes, sizable attachments, funny photos, jokes, customer testimonials (I am sure there is one buried in there) and managerial approvals that would be sitting unloved in the 'DMZ' folder.

In my heart, I know that I really should put aside four days to review all of those 6,207 messages and treat them appropriately. Most could be deleted, some would merit moving into a dedicated folder, that one from last summer about ergonomics in the workplace might look nice printed out and pinned above my desk and a minuscule rump would be left to help me get focused on what is really important in my life and genuinely needs to get done.

However, if I were to set the time aside doing this administrative task, I simply wouldn't be able to get anything done.

As Joseph Heller once said: 'There was only one catch and that was catch 22'

Disorganised of London

PS. The count has now increased to 6,213

Oracle have released Raptor (a freely available GUI SQL query tool) which may be of interest to those of you who use Toad or are frustrated with the terseness of the SQL*Plus interface.

Raptor is primarily a cross platform, PL/SQL developer tool, written in Java (60 MB download). The SQL output is a scrollable grid (like Toad) and there is the standard schema browser, PL/SQL debugger, SQL pretty printer, DDL generator and a graphical interface to explain plan for query tuning.

All in all, a very promising release which fills a surprising (to me) gap in Oracle's range of database products.

WordPress made some changes to the available themes just before Christmas which I have only just noticed.

I particularly like the changes in Regulus 2.0 by Ben Gillbanks as you can now customise the theme a little. You can choose to have the calendar displayed (Howard will be pleased), change the 'Blogroll' to use link categories, change the header image and the colour scheme. Also, the irritating 'Message essage' bug is fixed.

There are new, improved blog statistics available from WordPress.com with more to come.

No additional Javascript needed. Integrated reports from the dashboard. Superb.

As Matt said in a recent interview, these guys are active bloggers themselves so they understand what users want, what is useful, what is not and they also listen to feedback.

Dear Jeff Bozos

It is 39 years and 7 months since my last confession.

Back in 2001, I opened an Amazon Associates account, placed a link to a wonderful Oracle book I wanted to buy on my personal Web site, clicked through on the link and purchased the book from Amazon (UK). This abuse of the referral program credited my newly opened Amazon Associates account with the princely sum of £1.55.

I have never claimed the money which has subsequently sat dormant for over 4 years in my Amazon Associates account. This was partly because I was wracked and tormented by feelings of guilt. Even when I tried to forget about my heinous crime, the Quarterly Associates Newsletter email from Amazon kept reminding me of my sin.

Another reason was that the paltry amount was below the minimum required by Amazon before you can actually withdraw the money.

I could have continued to abuse this system more fully to make even more money (maybe even as much as a fiver) when I consider all the purchases I have ever made from my favourite online retailer.

However, now is the time to reveal my secret and take my punishment like a man.

Shamefully yours

Norman Brightside

Doug Burns raises a surprising number of issues in a seemingly throwaway comment about music.

1. I used to say I only have three passions in life 'Music, Football and Girls. The only thing that changes is the order.' :-)

2. Stuff that is too personal to discuss in a blog. I am startled about certain stuff I have seen posted in blogs. Personal stuff that I would never dream of posting.

3. Oracle versus Music versus Football. I started this blog after lurking on the Oracle blog community for a while and initially thought I would post occasional enlightening, technical articles which were met with worldwide acclaim. After a while, I realised, those posts would be few and far between.

   The other Oracle bloggers cover that stuff far better than I ever could. Also, I would make idiotic mistakes and have people correcting me all the time. I think I can spend my time more profitably reading and learning from others. To be honest, the technical niceties of PL/SQL 'bulk collect', bind variables and 10046 trace analysis can be a little dry when that is your day job. I probably care more and have more to say about music, football (blogging, software etc).

4. Another quandry about 'blogging etiquette'. I commented on Howard Rogers' view on the importance of calendar functionality in a blog. He answered my questions fully and politely (but I still hold a contrary view). Now do I take my followup to email or continue to comment on his blog article when most people probably aren't interested ?

5. Indeed, should this lengthy post be a comment to Doug's comment, a private email to Doug or a post in its own right ?

6. Diction. When I read my own blog, I see long, rambling, interminable sentences. This concerns me. Especially as I write a lot of technical reports as part of my job for paying customers and I also play a major role in the content of my kids' homework. I - sorry, my son - recently got a B+ for a scintillating project on San Francisco. I swear it should have been an 'A++'.

Old news is like yesterdays papers. No-one is interested.

The chart of failed spammers is as good indicator of traffic to your blog as any.

Old gems may totally get ignored depending on timing.

I might have one avid reader.

Lots of people are looking for information about 'Dixons Tax Free Shopping', 'SonicStage 3.3' (are you listening, Sony ?) and, oddly enough, 'Paul Scholes + family'.

Google is a popular but sub-optimal search engine for blogs as monthly archives may contain a wide variety of unrelated content (Roy Keane, Antibes, Blog, Chameleons, DAB) which will ultimately confuse people and waste time.

Not many people will comment. Even fewer will link.