Posts from March 2007

Just 10 weeks after closing, Performancing Metrics has risen again, phoenix-like, from the ashes.

I didn't use the previous incarnation of this statistics package as I had a hosted WordPress blog which didn't support Javascript. When I migrated to my own WordPress blog, I used Google Analytics which is perfect for my purposes (and free) but I couldn't resist installing the new version of the new statistics package from Performancing Metrics.

The software was really easy to install (two lines of Javascript) in the footer template. I really liked the real-time updates (better than Google Analytics which has a 3 hour lag) which are pretty addictive.

The reporting interface is really smooth and polished (the icons look similar to Netvibes but I presume these are in the public domain).

I was expecting high demand as people rushed to download the new software on day one and sluggish performance. All the reports were very quick and the system was responsive although with my data volumes maybe that isn't so surprising.

In addition to the standard tracking metrics (country, browser, platform, referrer, search terms), Performancing Metrics also allows you to analyse the page views, outbound links and path of an individual visitor which is a nice feature.

The geographic distribution report is integrated with Google Maps which is a nice feature.

Google Analytics is a completely free service (loss leader) but as Performancing Metrics only charges for over 1,000 page views per day, this equates to the same thing for my humble blog.

The WordPress plugin for Google Analytics automatically filters all accesses from WordPress Administration screens. This is better than IP filtering as I might use 3 different computers to manage my blog. This would be a neat feature for a future release of Performancing Metrics.

I was staggered to read on TechCrunch that Yahoo! Mail has 250 million users while the much younger and rapidly growing Google Mail (beta) service currently has a paltry 51 million users in comparison.

I wonder what proportion of these users, in these impressive headline (marketing) numbers, actively use the respective services on a daily basis.

However, I was not surprised at Yahoo's offer of 'unlimited' email storage which gets a cheap headline and was pretty inevitable. A tiny minority will gleefully claim they really need infinite storage and think of inventive ways to upload the entire contents of their PC to a server. Yahoo! will then ban them for uploading copyrighted material.

While I have a longstanding but rarely used Yahoo! Mail account (which I was scanning tonight funnily enough searching for my Flickr credentials), this announcement won't be tempting me back to Yahoo! just yet. I await with interest Google's response though.

I think the Yahoo! Mail screen is incredibly cluttered and the adverts on the right hand side are incredibly intrusive and consume valuable screen estate. As you scroll through Yahoo! emails, the banner ads actually change which is slow and very distracting !

I know this type of thing is very subjective and, in many cases, ones preference simply reflects what you are used to and familiar with but I honestly don't know how Doug tolerates it. Also, Google's spam filter is far more effective which is important.

Also, Yahoo! have a irritating tendency to overuse the exclamation mark as part of the corporate branding. Look at any personalised Yahoo! page and shriek as you count the shrieks. I suspect you will be unpleasantly surprised.

Unfortunately, I appear to have mislaid (or Yahoo have inactivated) my Yahoo! credentials for my world famous Flickr stream so let's try some inline thumbnails. Apologies for the quality.

Note the MASSIVE banner ad on RHS (no I didn't photoshop the red border) and the more subtle ads bottom left.

I continue to use my ISP email account for personal stuff but am starting a gradual migration to Gmail which started around a year ago. Apart from spam, I hardly ever delete a Google email. Consequently, I am barely scratching the surface of my 3GB allocation (35 MB - 1% - of the allocated 2833 MB).

I also like the security of having messages and email address stored on a server (and not my PC).

The ads on Google Mail seem much less noticeable and intrusive to me (yeah I know I'm a Google whore). I can honestly say that I barely notice them. I think this is because of the text (not banner) ads coupled with the white background although I am not sure what advertising men in new media glasses would make of this.

Many years ago, I managed a set of Oracle databases for various clients.

However, I was not an Oracle DBA. I was an Unix/C developer who happened to progress to Pro*C, PL/SQL and some ETL projects for data warehouses.

I was an mediocre development DBA because I was a mediocre developer and I had a keen interest in performance tuning i.e. I was (am remain) a 'glory hunter'.

I was not a production DBA because I didn't have the training, experience and discipline required for change controls and saying 'No'.

One day, the CEO of our 18 man Internet startup asked me to deliver a short presentation to the rest of the company what my team (me and my junior) did all day.

I put up a slide that said:

• Data Availability

I think a clever new media colleague helped me to add 'transitions' to add two more bullets.

• Data Availability
• Data Availability

Ironically, this wasn't what we did which was covered on the next 34 slides. We did absolutely everything: fixing code, reloading data, backups, analysis, ETL, extracts, PL/SQL, performance tuning, long hours, recovery, testing, code reviews, cloning, documentation, nervous breakdowns, monitoring, upgrades, configuration management, severed relationships, recruitment, management and coffee.

However, data availability is precisely the only thing we should have been doing.

Data availability is the sole responsibility of an Oracle production DBA.

It is to ensure that data is available at all times to all users.

It is not to tune queries from 37 seconds to sub-second.

It is not to experiment with parallel query and parallel DML to tune a third party application.

It is not to ensure that you can clone 'ALL_OBJECTS' in less than 17 seconds.

It is not to ensure you can load 184 million records in 72 hours.

It is to ensure that you can restore data from a catastrophic failure.

It is to ensure you can restore service following an expected failure.

It is to ensure you can restore from the backups deposited in secure off-site storage.

It is to ensure that the file system holding the archive logs never fills up.

It is to ensure that you can have a coherent plan to restore service after any unexpected event.

It is to ensure that you take responsibility and say 'Yes. That is down to me'.

Extracted the shiny new Dell PC from the tall cupboard yesterday. Pretended this PC was for homework only, would solely use Google Docs and wouldnt connect to the Interweb.

Lasted two minutes before yielding and plugged in Linksys USB wireless card. Briefly marvelled at the quality of the flat screen, then downloaded drivers for Windows Vista, followed the instructions on the Linksys technical support site and successfully connected to the burgeoning wireless network first time.

Finally, Norman Junior III has his own PC, so now I will actually be able to use my own computer whenever I please.

Expect a barrage of varied, humorous, exciting and detailed technical blog articles and, yes, the frequency will be doubled, Kenneth.

Or maybe not.

Inevitably, my new best friend, Michael, the Virgin Media engineer didnt return on Friday afternoon to complete the installation of V+ or to reinstate my original, functional set top box to provide me with a TV service over the weekend.

Instead, he hurriedly telephoned me to say he had transferred this issue to the 'networks team' who would call me later to resolve it. Surprise, surprise, the 'networks team' didn't call me to resolve it so I had to call them (on three separate occasions) to make another appointment.

I was trying to do the engineer a favour by suggesting he went off to his other jobs on Friday. I trusted him. With hindsight, I was probably naive, gullible and stupid.

A word of warning to the engineer who is scheduled to appear on Tuesday afternoon. My wife is taking time off work to accommodate your visit which she is already unhappy about. My wife doesn't know (or care) what V+ is.

She is also 'bitterly disappointed' (she actually used different words) that Virgin Media can only specify an four hour window for an afternoon visit. As she works locally, she would have preferred the engineer to call her directly with an hours notice.

My wife is not naive, gullible or stupid so don't be surprised if you don't get offered a cup of coffee. There is a possibility that she will not offer you a visitors parking permit for your van which consequently may get clamped.

If there are any further problems this time, don't just stand staring at a diagnostics screen saying 'I think the Hit will download in a few minutes' or swap one brand new functional box for another brand new functional box, do something to try to fix it.

Otherwise, there is a danger that you will be locked up in chains, thrown into the depths of the cellar and fed on a diet of crackers and water until the V+ service is actually working.

This afternoon, a Virgin Media engineer has arrived to upgrade my existing set top box to a V+ (TV drive).

This is a straightforward box swap. No additional wiring or drilling is required. However, the new box failed to initialise. We both stared expectantly at the following screen for an eternity:

Card Status: No T-Stream

IPPV Status: BLANK

He then called technical services who initiated the operation. He double checked the serial numbers of the V+ box and the card. He tried to bamboozle me with science 'Hits must be slow today'.

Eventually, he gave up and fetched a second V+ box from his van. I reciprocated with a visitor's parking permit. It now looks unlikely that this simple box upgrade will be finished within the original 5 minute period.

We made more polite smalltalk like a couple on their first date. We waited. And waited. The 'IPPV Status' stubbornly remained 'BLANK'. He showed me the User Guide - a booklet cunningly disguised in a DVD box.

We waited a little longer. We both pretended to admire the new black V+ remote control.

Suddenly, he exclaimed 'At last !'. He seemed very pleased the see the 'Credit Limit' field change to £105.00. 'Oh good - it's finally starting to come through. Shouldn't be much longer now.'

But it was. We waited. I offered him a cup of tea ('Ta. Milk, two sugars').

He called the service centre yet again to quadruple check the serial numbers had been entered correctly. He seemed a little frustrated and annoyed to discover the numbers were not 'paired off' (mismatch between STB and SmartCard) correctly.

This news seemed to disappoint him as he said quite forcefully 'I have been waiting around for 45 minutes for this TV Drive reset'. However, he now seemed supremely confident that this time, the box would be initialised properly in the next 5 minutes.

It wasn't. We talked. I showed him my holiday photos from Norway. We finished our tea. My wife asked if he 'would be stopping for tea.'

Eventually, I suggested that he went off to his other three jobs and return later this afternoon. He politely rejected this suggestion, saying 'No let's just give it another 5 minutes.'

15 minutes later, he gave up and went off to his remaining jobs, promising to call me later to confirm that the V+ box is finally ready.

However, another 45 minutes has passed and the 'Card Status' is still 'No T-Stream' so I have a feeling he will be returning but only to reinstate my original set top box.

Generally, the quality of cover versions on YouTube can vary to say the least.

However, covers that purely mime to the original soundtrack are excellent as you can simply minimise the video and listen to decent music, you were forced to remove to make way for another yet another virtual machine.

This cover version of 'Aneurysm' by Nirvana has a certain visual appeal though - the drums and cymbal, the bendy guitar and the socks.

Ladies and gentlemen. Please be upstanding and don your ear protectors for this unique version of God Save The Queen.

Im not sure Im cut out for a career in pre-sales as I have an irritating tendency to blush and my left eye twitches horribly when I tell half-truths.

However, on Sunday afternoon, in order to welcome my loved ones back from Holland, I donned a smart dark suit with a crisp white shirt and business-like grey tie. I then loitered around the lower level of Heathrow Terminal 1. I chose to invest the money I saved on the standard taxi fare in a very stylish (and not stupid looking) Bluetooth headset offering hands free operation.

As the incoming flight was inevitably delayed by two spaced out students who checked in and then spent another hour checking out every single item for sale in every single retail outlet at Schipol, I had an unexpected 75 minutes to kill so I wandered around keeping an eye out for celebrities, potential terrorists or weirdos.

A lovely, foreign lady approached me and asked how to get to 'Terminal 2 Lufthansa, please' so I consulted the information board and directed her to Bus Stop 1 for the courtesy bus. Curiously, this selfless act human kindness and my authoritative presence led to a flurry of more people approaching asking for assistance: 'Where to check-in for BMI to Copenhagen ?', 'Where to get English money ?', 'When will BA74 from Brussels arrive ?' and 'Why are the toilets so (expletive deleted) filthy ?'

I cheerfully answered the questions free of charge: 'Upstairs', 'Currency Exchange or that cashpoint might be cheaper', 'Sorry - no idea' and 'Don't know where you come from but that's spotless by British standards'.

Finally, after an overpriced medium Latte, the flight landed and the monitor changed from 'BD108 Amsterdam: Expected ~~16:17~~, ~~16:24~~, 16:37' to 'Landed 16:45' and finally to 'Baggage in hall'.

I carefully pulled out a sheet of A4 paper and inscribed 'BRIGHTSIDE' in blue marker pen. I quickly called my son at home, told him to get the roast out of the oven, hoover throughout, wash the toilets, air the washing and call me back immediately.

My glorious headset illuminated 'Blue' and I told my controller 'Yeah - I'm just picking up at T1 now. Can make Wimbledon in 55 minutes. Roger. Over and out.'

I then identified prime position on the metal barrier and squeezed in next to a young lady keenly waiting for her boyfriend who had been ski-ing (and unfaithful) in Austria. I unzipped my jacket and extracted my outsize A4 sign which I held aloft. The lady muttered 'Bloody minicab drivers.'

New arrivals from India, America and Western Europe looked enquiringly at my sign but I shook my head with disdain. Tall people riding bicycles, smoking tulips and carrying joints emerged. At last, the Amsterdam flight was here.

Finally, Norma and Norma Jean arrived. My daughter's face went bright pink, she frowned and nudged her mother who was completely oblivious. I proudly held the 'BRIGHTSIDE' sign even higher and fiddled with the volume on my Borg headset.

After hearing about Anne Frank's house, the red light area and the 'coffee shops', I helped to unload the heavy suitcase and opened the front door for the excited but exhausted European globetrotters. When I politely asked about the possibility of a tip, Norma replied:

'Yeah. I'll give you an excellent tip. Never eat yellow snow.'

Holy Father. It is almost 31 years since Citys last trophy. Since then, I have:

• Failed to install Oracle 10gR3 Grid Control to experiment with the Siebel Management Pack.
• Failed to configure bridged networking on my Siebel 8.0/Oracle 10g/RedHat VMware environment. Consequently, I have just deleted the complete 20GB environment in a fit of pique.
• Nearly exploded at the woeful response to a ticket with Bluehost asking why two functioning cron jobs were a) removed and b) failed to work when reinstated.
• Failed to resolve a trivial but incredibly annoying problem with AVG mail filter.
• To top it all, I don't even know the difference between MB and Mbps.

'My dear son. You are indeed a worthless sinner. May the Lord may mercy on your soul. To seek forgiveness and redemption, please say three Hail Marys, one Our Father and request a transfer to pre-sales.'