Author Archives

I work with Oracle databases doing DBA, Design and Development. I publish articles on my website and recently started writing books. My hobbies include Yoga, Karate and swimming.

Website Updates: Cleanup Complete…

I wrote last month about some issues with my website as a result of an issue with my hosting provider. It’s been a very long and arduous process, but I think I’ve finally finished the last of the cleanup. It’s certainly not something I would like to repeat again. Having said that, there are lots [...]

Funny Cloud Computing Video…

If you loved this, iPhone4 vs HTC EVO And you loved this, Mongo DB Is Web Scale Then you will probably love this, Oracle Cloud Computing Cheers Tim…

Underworld: Awakening…

I went to watch the 3D version of Underworld: Awakening yesterday. I’ve made my feeling know about 3D several times and this film changes nothing. The 3D element is an expensive gimmick I can live without. What’s more, the 3D in this film is pretty crappy. It looks like a post-production thing, rather than being [...]

Windows: The easy option for Oracle…

I mentioned this when I blogged about my 11gR2 Virtual RAC install on Windows 2008. It came up in a conversation with Niall Litchfield at UKOUG 2011 and I’m reminded of it again today, after doing an 11gR2 install on Windows XP to double-check my answer to a question. Oracle database installs on Windows are [...]

Free Book Offer…

Just a quick heads-up for anyone who is interested in getting hold of a free copy of OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide. There are two free e-books to be won. The two people that contact Sunil Chakravarthy (sunilc@packtpub.com) giving the best reason why they want a free copy of this [...]

(Orthodox) New Years Resolutions…

I’ve not become all religious. I’m just using this variant on new year to start my new year in earnest. The start of this year has been a little shaky for me. The first couple of days I was a little under the weather and I kinda decided to break all my planned new years resolutions [...]

Dbvisit Standby…

Several years ago I met Arjen Visser and Bertie Plaatsman from Dbvisit and they told me about their standby database product, which is a replacement for Data Guard. Now I don’t spend much time on non-Oracle products, but this one was interesting to me as it works on Standard Edition, unlike Data Guard which is [...]

Amazon Kindle…

One of my justifications for buying the iPad was I would use the Kindle App on it and save lots of money on buying paper books. That didn’t happen because the iPad is a really crappy reading device for novels. It’s way to big and heavy and has a nasty glossy screen that it totally [...]

phpBB 3.0.10 Released…

I somehow managed to miss the release of phpBB 3.0.10 at the start of the year. The changelog is here. All upgraded now. Cheers Tim…

Should SQL have a compulsory ORDER BY clause?

How many times have you heard someone say, “The rows always came back in the correct order, but since the *event* it’s now wrong. The *event* may be an upgrade or some maintenance task on the table etc. Oracle clearly say, “Use the ORDER BY clause to order rows returned by the statement. Without an ORDER BY clause, [...]