where are they now ?

People often write in and ask ‘Is Oracle blogging dead ?’ Well, I thought it might be interesting to revisit the list of Oracle blogs I posted way back in 2007 and see what they’re up to. Life After Coffee - dead (last post May 2011). The pressure of the No. 1 slot proved too much. The Tom Kyte Blog - frequency much reduced but Tom’s a busy man. Rittman Mead - now a multi-user, shiny, corporate blog....

October 25, 2013

Sherlock Burns and Dr. Hall investigate

‘Burns - I guess this means I can book the hotel for four nights and cancel the flights to OpenWorld then ?' It was 10:30 am on a dull, grey overcast Monday morning in Manchester. Sherlock Burns and Doctor Timothy Hall had just emerged from a fractious, tense kick-off meeting at Tiger Telecom. Sherlock Burns and Dr. Timothy Hall had been called by the IT director at short notice to investigate a sudden and marked degradation in the performance of the production database...

September 7, 2010

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....

January 29, 2010

in praise of Doug Burns

My longest standing and all-time favourite Oracle blogger is Doug Burns of Edinburgh, near Scotland. In addition to his sharp, analytical Oracle skills, helpful attitude and easy going manner, Doug does a great deal of unsung, unpaid work for charity (although, obviously he doesn’t like to talk about it) and is a fully paid up member of Amnesty International. Doug is also passionate about the the causes of data privacy, security issues, the freedom of information and continues to fight an unceasing battle for the rights of the individual against the evil spectre of Google Corporation....

March 24, 2009

onwards and upwards

After over five varied and enjoyable years working for Siebel (and then Oracle) in Expert Services, I am changing jobs. However, I will continue to work for Oracle as part of the group responsible for ‘Social CRM’. Although this was a internal transfer, my interview process was quite unusual. Instead of being forced to massage my CV into Microsoft Word format and send an email attachment to a faceless recruitment agency, I was able to publish my CV using Google Docs and the whole interview process was conducted by telephone....

September 21, 2008