Recent Posts

open door policy

Whos there ?

Its me - Jamie.

Thinks to myself - I don't know anyone called Jamie. My son isn't called Jamie. My daughter isn't called 'Janie'. Even though the wife is visiting her parents and I have the house to myself, I don't suppose it's that bizarre, twisted fantasy featuring Jamie Lee Curtis.

I reached for a 3 iron to defend myself and finally get myself in the Daily Mail as a selfless vigilante, wrongly imprisoned for 7 years for simply defending his own property. An Englishman's home is his castle and all that.

'Oh - wait. Hang on Mister Brightside. Please put the golf club down, please. I've just come round for an Xbox controller and Norman Junior said you might be out so he gave me the keys to get in.'

And with that, I put the golf club down (Wilson Graphite Di9 Steel 4-SW) and said 'Oh that's all right then.'

press the eject and give me the tape

Those 2010 Brit Awards in full:

  • British male solo artist - Dizzee Rascal
  • British female solo artist - Lilly Allen
  • British breakthrough act - JLS
  • British group - Kasabian
  • British Album - Florence & the Machine - Lungs
  • British Single - Beat Again (JLS)
  • International male solo artist - Jay-Z
  • International female solo artist - Lady GaGa
  • International album - Lady GaGa - The Fame
  • Outstanding contribution to music - Robbie Williams

...and Liam Gallagher swearing and throwing a microphone into the audience. Who said rock'n'roll is dead ? I bet Joe Strummer is turning in his grave.

untold riches with next generation Adsense

One of the reasons for the reduced blogging frequency, Kenneth, is that I spend every waking hour devoting time to the thorny problem of monetizing this humble blog. Previously, I experimented with Adsense but sadly the revenue stream was insufficient to enable me to retire.

I am now pleased to announce the results of my research and contemplations.

Do nothing. Absolutely nothing. Be patient. Wait. Don't get frustrated. Just wait.

Sooner or later, you will receive an email promising you riches and wealth beyond your wildest dreams.

In return for posting a link to a Web site, I am going to receive a goodie bag containing the following:

  • 2 Packs of Love Hearts
  • 1 Pack of Chewits
  • 1 Pack of Black Jacks
  • 1 Pack of Refreshers
  • 1 Millions Tube
  • 1 Pack of Giant Parma Violets
  • 1 Chunky Drumstick Lolly
  • 3 Packets of Fizz Wiz
  • 1 Marshmallow Flump
  • 1 Pack of White Mice or 1 Pack of White Chocolate Buttons
  • 2 Snap Crackle Chewbars
  • 2 Fruity Pops
  • 1 Piece of Bubbaloo cola gum
  • 2 Fruit Fizzers

'The Retro Sweets Pile comes to you packaged in a clear bag.'

...which is very important as if the goods were packaged in a brown bag, people might think your were receiving sex aids through the post.

Prepare yourselves for a bunch of unobtrusive links to mindless, desperate UK based SEO agencies appearing shortly. Prepare yourself for a bunch of anecdotes about tooth decay and late onset diabetes.

taking a back seat

Rich Manalang is taking a back seat and suspending some but not all of his online activities which is an interesting exercise I will follow as it unfolds. Or, rather I won't, because he won't be blogging about it. I suppose I could always email him at work.

I suspect Google Buzz was the final nail in his Web coffin. It certainly was for me. The privacy issues, the multiple, loud and prolonged orgasms from the Technorati, the same old avatars gradually showing up in my 'Friends' list quickly followed by the immediate same sense of 'Emperors New Clothes' and the inevitable post coital cigarette: 'How was it for you, darling ?'

Rich's decision to take a step back interests me as in the past, on at least two occasions, I have gone slightly further and committed Web 2.0 suicide. This entailed spontaneously and maliciously terminating a bunch of accounts on FriendFeed, Tumblr, LinkedIn and elsewhere. Of course, it didn't last and in due course I miraculously resurrected myself - but after slightly longer than three days.

What I find slightly odd about Rich's decision is that he will preserve 'IM and email' - I presume he means in order to work but maybe he includes personal use too - but he then goes on to include Google Reader as he finds 'GR adds order to the chaos'. I agree completely although I think the experiment would be much more interesting if he ditched GR and idle Web browsing for that matter too.

I suspect if I embarked on a similar exercise I would revert to scanning my small set of favoured Web sites. I also suspect, and it sounds slightly counter intuitive, that I would find lots more to blog about. Of course, Rich can't blog more because blogging is also suspended during this hiatus period. I also find this odd as he states outputs (5%) are much more valuable, but greatly outnumbered by, endless, mindless consumption (95%) so it would be interesting to see whether his outputs increase as a result of his self-imposed exile.

float in isolation

Many years ago, in a parallel universe not far from here, I worked for a small dot com Internet company.

One day, the boss walked in and proudly announced: Right - Ive bought everyone three sessions at the London Float Centre'. I thanked him but told him I wasn't interested and he could give my three sessions away to a more needy case but he was insistent and he was the boss.

So, on a Thursday lunchtime, I found myself nervously walking down to the mysteriously named 'London Float Centre' located not in sunny San Francisco but in grey, cold, dreary Clapham Common. As I nervously walked into reception, my preconceptions and prejudices were instantly reinforced when a young lady wearing a colourful, long dress with braids in her hair greeted me.

I looked around at the arty artwork on the walls and nervously mumbled: 'Err, this is, err, my first time. How does this all work ?' She replied: 'You just go to your cubicle, get undressed and enter the flotation chamber for 40 minutes. A quiet bell sounds to indicate the end of your session.'

'Undressed' - did she just say 'undressed' ? My reluctance and lack of commitment to this ludicrous idea was being severely tested already. I had packed my Hawaiian swimming trunks specially for the occasion. No-one back at the office ever mentioned getting 'undressed'. The young lady must have sensed my unease or maybe she saw my brightly coloured swim wear in my carrier bag I was holding (like Mark. E. Smith but without the broken hip). 'Of course, you don't have to get undressed. You can wear swimming trunks. It's entirely up to you.'

I was about to depart for cubicle 3, wondering what the hell I was doing here and cursing my boss when the young girl bamboozled me with a surprise, trick question: 'Do you want the music on or off ?' If I hadn't been so nervous, I would have answered 'Yes please. I'll have 'Bend Sinister' followed by 'The Sky's Gone Out' but instead I hesitated, looked blankly and replied: 'Music - how do you mean - exactly ?'

'Well - some people find the sensory experience is heightened by music playing during the session. If you don't like it, just press the button to your left to turn it off.'

'Ah OK then - yeah I'll have music. That will be nice. Thanks.' while thinking inwardly to myself '...nice to ease the boredom of being immersed in a salt water solution in a darkened room for 40 minutes.'

I made my way to cubicle 3 and assured myself that the dimensions of the flotation tanks meant they were single user only and the cubicle could be locked to ensure stray people could not wander in and mistakenly stake a claim for immersion chamber No. 3. Finally, reluctantly, I decided to embrace the full hippy, flower power, free love experience by casting aside my shorts. Plus the wife would be pleased - they wouldn't need washing.

Feeling like an idiot, I laid down in a small-ish, rectangular tank of warm water. Gradually, the concentrated salt solution managed to float my enormous bulk and I just laid there floating - in silence - with the light on - staring at the cream roof. Now what ?

I remembered the girl had told me to press another button to turn the lights off which I did.

Now I was lying bollock naked, floating around in a tank of luke warm water, staring up at nothing - in pitch black. It was dark, completely dark. I waited 40 seconds for my eyes to adjust so I could make out the reassuring lines of the walls and the ceiling but my eyes didn't readjust. It was still pitch black.

I was floating around aimlessly. I nearly had a heart attack when my shoulder bumped the side wall. I thought someone, possibly the not unattractive hippie girl with dreadlocks, had somehow unlocked the door to cubicle 3 and silently crept in unnoticed to lie alongside me.

I tried to calm myself down, to be open minded and lighten up - for 30 seconds at least - and to actually try enjoy the whole experience. I managed to master floating while remaining perfectly still. I gradually felt calmer and actually started to enjoy the silence. No longer was I looking for the solace of the walls or the ceiling or worrying whether my wallet was safe.

Then, like a bolt from the blue, like a shot to the heart, from nowhere , soft music started playing. Very quietly, very gently - whale like music. This was just like having a water birth at home - except I was a middle aged man in a flotation chamber in Clapham Common. Obviously, they didn't have anything by The Fall or Bauhaus - I must put that on the feedback form.

I laid back again and listened - nothing - apart from the strangely reassuring and apt sound of dolphins talking to each other. I strained my eyes - nothing. Again, I relaxed and forgot all about my stupid, small, minuscule, trivial worries at work. I forgot about everything. I even forgot about the prospect of falling asleep, drowning in 8 inches of water and winning third place in the 2001 Darwin Awards.

I laid back, floating. My mind became strangely blank. Completely blank. It was glorious. A glorious nothing-ness. A glorious emptiness. A glorious void. I just laid there; doing nothing, thinking of nothing.

This state of mind continued for another 25 minutes. Not once did I think of the time. Not once did I think of work. Not once did I think of United's chances of lifting the title. Not once did I think of online media recovery of an Oracle database when some of the archived redo logs were in deep in secure storage offsite and we only had a daily collection from Iron Mountain. Not once did I think of the appraisals of the four people reporting to me.

After a beautiful period of more nothing-ness, a gentle noise told me the session was now over. I lay there for a little longer and finally pressed the light switch.

The lights came on. I was back in the real world. I could see the walls. I could see the ceiling. I could see how small the flotation tank was. I could see a third button next to 'Music' and 'Lights' called 'Emergency Assistance'. Good job I hadn't noticed that earlier. The whale music CD abruptly ended as if killed by a blood soaked harpoon.

I got dressed, checked the contents of my wallet and packed away my dry swimming trunks for my summer holidays in Crete.

I walked back into reception: 'Now - how was it ?' 'Yeah - it was great. Thanks.' 'Oh good - we've had a lot of people from your company. They all seem to enjoy their sessions here.'

'Would you like a cup of tea ?' I was about to reply 'No - really I've got to be getting ba-' but I caught myself just in time. 'Yeah - that would be great. Thanks.'

So I sat down with some blackcurrant, herbal tea chatting with the receptionist about the science behind flotation chambers or isolation tanks.

Then I returned to the office. Now this is where is gets really weird.

I couldn't concentrate. I felt like I was still floating up high, looking down on everyone. I felt like I'd done some drugs. I couldn't type or read my email - well that's not true - I could type letters and read words but they didn't seem to make sense. Nothing seemed important. Nothing seemed to matter. As The Chameleons sang in 'Second Skin', I felt like 'I was floating on air'.

At 4 o'clock, I capitulated, politely made my excuses and decided to go home early.

Years later, whenever I recount this story, my wife says: 'Yeah - it was weird. When he walked in, he looked like a complete zombie. I thought he'd been made redundant or someone had died at work. Either that or someone in the office had given him space cake for a laugh.'

why can't people understand date arithmetic ?

AND TO_NUMBER(TO_CHAR(appt_start_dt + 9/24, YYYYMMDDHH24MISS)) <=
    TO_NUMBER(TO_CHAR((TO_DATE(:b1, DD/MM/YYYY HH24:MI:SS)), YYYYMMDDHH24MISS))

Please can a clever Oracle person explain, in English, the precise semantics of this WHERE clause snippet in the comments below.

I realise this construct and variants thereof have probably been discussed ad infinitum on Oracle WTF but I just don't get it.

I don't know whether this SQL was written by a human being or a third party ETL tool but it doesn't matter. Currently, all ETL tools are written by humans in any case.

Why do people struggle so much with date arithmetic ?

When I was a little boy, I used to say 'Only 43 days to my birthday now, Dad'. Although I didn't know it at the time I could have written this as

sysdate + 43 = :my_birthday

I even understand that TRUNC(SYSDATE) is midnight - it just seems fairly intuitive and logical to me.

My tiny brain can even understand the concept of date subtraction - last Wednesday was two days ago and Manchester City's last trophy was almost 34 years ago.

I understand that a date is a date is a date. I realise that a date is not an orange. I realise that a date is not a string and I only see dates in SQL Developer because that was a design decision to perform an implied conversion using the default date format and a useful user friendly feature.

I understand that if I want to display the date and be assured of the date format I need to convert it to a string using TO_CHAR with the appropriate date format mask.

I understand that Unix systems (and the next generation blogging platform, Habari) stores 'dates' internally as the number of seconds that have elapsed since the Unix epoch on 01 January 1970 00:00:00.

But look again at that code snippet. The author is obviously familiar with the Oracle functions TO_CHAR and TO_NUMBER but why in the name of God does he convert a date to a string to a number and then compare the resulting outputs ?

What is the meaning of that generated 'number' - 20100129143559 ? 'Twenty billion, one hundred thousand and and one hundred and twenty nine million, one hundred and forty three thousand and five hundred and fifty nine. Or something. Why is that a useful number ?

Why did he waste time and energy doing do all that typing ? Is he working on a top secret defence project that requires him to obfuscate the code ? Maybe he is paid by lines of code ? The author is clearly aware of some elements of date arithmetic in Oracle because he used '+ 9/24' to add 9 hours to the appointment start date.

Maybe there was a useful index defined on APPT_START_DT that he wanted to suppress for performance reasons.

I'm not sure but I have an awful suspicion that the object associated with the bind variable :B1 may already be declared as a DATE data type but hey, let's convert it to a date using TO_DATE - just to be sure, to be sure.

Why didn't he simply use

AND appt_start_dt + 9/24 <= [TO_DATE] :B1

Why ?

Happy Anniversary

This years Carling Cup Final between Aston Villa and Manchester United will take place at Wembley on Sunday 28th February 2010.Curiously, this date marks the exact 34th anniversary, to the very day, of Manchester Citys last trophy.

After United defeated Millwall 3-0 in the 2004 FA Cup Final, all the United players changed into shirts numbered '36' in a tribute to the young player, Jimmy Davis, who had recently died in a car accident.

Today I have written to the club to see whether United could do something similar to mark the anniversary of Dennis Tueart's spectacular overhead kick that beat Newcastle in the 1976 League Cup Final. My proposal is for United to sport shirts sporting a MASSIVE '34' while Dennis Tueart could be the club mascot for the day, wearing a pale blue and white retro scarf.

34 years

When we go to Old Trafford, we will take that banner down. This is the last year it will be displayed because we will win.

Roberto Mancini - 6 January 2010

34 years

the wit and wisdom of Gary Cook

This football club will be without doubt the biggest and best in the world. People don't like to hear it but I'll make no excuses for saying it, and I will never stop saying it because I truly believe it with the resources and capabilities that we have - and when, not if, we're at Wembley having beaten Man United yet again !'

Gary Cook - Mad Hatter Saloon, New York, 22 January 2010.

34 years.

Rooney and Bellamy

fun with keywords

Some of the varied and bizarre keyword searches leading visitors to this site merely confirm this blog is the ramblings of a confused madman. Here is a selection from the start of the year

  • 'dyslexic blog' - curiously spelled correctly.
  • 'crucifixion blog' - listen United are in debt and suffering a dip in form but don't do anything hasty now.
  • 'why linux will never' - come on, you simply can't leave me dangling like that.
  • 'breasts chessington' - hoping your mates didn't publish that photo of you, on the log flume, flashing your assets.
  • 'brightside software enterprises friendorfoe' - stealth marketing finally starts to pay off.
  • 'famous captive animals' - Skippy (the bush kangaroo) and Lassie.
  • 'handsworth exoctic escort' - there's absolutely nothing exotic about Handsworth, trust me.
  • 'hoax messages on friends reunited' - the ghost of the cruel, heartless Janet Oldsgate strikes again.
  • 'how can i get back my lost virginity' - please send an international money order for £250 to PO Box 729.
  • 'life has dealt me with a cruel card' - don't tell me, hang on. Was it the '8 of Diamonds' ?
  • 'my car keeps cutting out and the bonnet is steaming' - stop blogging immediately and call The AA.
  • 'pubsubhubbub is a lot easier than it sounds' - easy for you to say.
  • 'the balls of allah explosive underpants' - priceless. What a superlative name for a blog/album/house/dog !
  • 'what do you think is the most important decision in our life' - Will these underpants last another day ?
  • 'fucking overlapping partitions when im installing linux' - language, Timothy. Nice assumption that the swear word would be included in relevant posts