Posts from 2010

float in isolation

uk

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 cant 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 dont like to hear it but Ill 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

milkman of human kindness

uk

Sometimes your faith in humanity is restored.

The DEC Haiti appeal has raised over £25 million just from the news coverage alone. This exceeds the £20 million raised by last year's Children in Need campaign which (while still a worthy cause) is mercilessly peddled and trailed by the BBC for two long weeks.

Don't forget to mark your donation as 'Gift Aid' which allows DEC to reclaim 28p for every pound given.

Steve Jobs on design

‘Make it look good! Thats not what we think design is. Its not just what it looks like and feels like. Design is how it works.” — Steve Jobs

So very true. Via a comment on an interesting blog post comparing Tumblr to Posterous.

Ironically, this short post would have been better suited to a one liner, throwaway post correctly labelled and nicely formatted as a quotation on a service like, well Posterous or err, Tumblr but I am trying to consolidate all my efforts into this blog.

Arthur Smith nails it

uk

This country is shit. The food is shit, the government is shit, the weather is shit, the transport system is shit, education is shit, life is shit, death is shit, I am shit.

As this country grinds to a halt yet again after a light dusting of snow, a timely and apt quote from Arthur Smith whose autobiography 'My Name is Daphne Fairfax' I can highly recommend.

the mechanics of IT

IT

Last year, I visited a customer in Swindon. When I arrived at the office, I noticed some water dripping from the underside at the front of my car. I didnt have time to investigate or get my hands dirty so I subconsciously hoped it was just condensation from the air conditioning unit and tried to forget all about it.

After work, I managed to navigate Swindon's world famous roundabout of roundabouts and finally locate my hotel. When I parked, I noticed the temperature gauge was reading high - very high. Sure enough, I got out of the car to see steam pouring out of the bonnet and was greeted by the familiar smell of anti-freeze.

I still didn't want to get my hands dirty so I opened the bonnet and just stared at the problem, hoping that would miraculously fix it. Then I checked in to my room and rang the AA. I introduced myself to the operator as 'Hi - my name is Norman and I'm an alcoholic.'

The AA man duly arrived before 'The One Show' had even finished. We both stood looking at the engine knowingly before he asked: 'Now, Sir, what seems to be the problem ?'

'Well, I think it's pretty minor and easy to fix. It's just the top hose has perished and needs replacing.'

'Oh I see, Sir. Why do you think that ?'

'Well, when the engine was running, steam was pouring out of the top corner of the radiator - right there where the water hose joins.'

'OK, Sir. Thanks for that. Please could you just turn the engine over for me so I can take a look myself ?'

Engine on. Water and steam billowing out. Smell of anti-freeze. Temperature gauge rising.

'Whoa ! That's fine, Sir. Engine off now, please. Well it's not your hose, Sir. The problem is over here. It's your bleed screw, Sir. Look (flips the screw from the middle of the radiator). This bleed screw has sheared off in half. Quite a common problem on this model. Seen it a couple of times now.'

I felt a little sheepish (but very relieved that a solution was in sight) and the man from the AA, James, filled the radiator with 13 pints of cold water and I followed him to a local garage where we parked and he kindly drove me back to the hotel so I could wash my hands.

The next morning, I walked into the customer's offices to be excitedly greeted with 'Oh good - glad you're here. We have got problems. Serious problems. Performance problems. On production.'

'Ah OK - what seems to be the problem ?' 'Well it's the database, you see. It's the hard disk - 99% busy. Partition 27b on logical volume 7 is overheating. Oh and another thing that might be relevant - the hit ratio is right down at 72.7%'

'OK - thanks for that. Do you think you could just start the system up for me and I'll take a look myself ?'