Overloaded Indexes (for ODC Appreciation Day)

ODC Appreciation Day is an idea that Tim Hall (aka Oracle-Base) came up with, to show out appreciation for the Oracle Technology Program (OTN)/Oracle Developer Community.

Fig 1 This is an efficient range scan

I want to show my support but rather than mention an Oracle “feature” I particularly like I’d like to mention a “trick” that I (and many others) often employ to help performance. That trick is Overloaded Indexes.

We can all (more...)

Free Webinar – How Oracle Works!

Next Tuesday (19th September) I am doing a free webinar for ProHuddle. It lasts under an hour and is an introduction to how some of the core parts of the Oracle RDBMS work, I call it “The Heart of Oracle: How the Core RDBMS Works”. Yes, I try and explain all of the core Oracle RDBMS in under an hour! I’m told I just about manage it. You can see details of the event and (more...)

Friday Philosophy – Are Leaving Presentations A Quaint British Tradition?

A few days ago a friend, Robert Lockard, started a discussion on Facebook about bad bosses and the strange things they did. I mentioned how one of my first bosses had refused to do my leaving presentation, arguing with his boss (very loudly so all could hear, despite it being in “an office” – a plastic box in the corner) that he did not want to be nice to me and do the presentation. (more...)

Friday Philosophy – Sometime The Solution Has To Not Only Match The Problem But Also…

…The People!

When you design a system for end users, a good designer/developer considers the “UX” – User eXperience. The system has to be acceptable to the end user. This is often expressed as “easy to use” or “fun” or “Quick”. But in reality, the system can fail in all sort of ways but still be a success if the end user gets something out of using it. I’ve said it before and I’ll say (more...)

Friday Philosophy – Improving Your Working Life

If I got you all to write down the top 5 things that make working bearable, and then got you to make a list of the top 5 things that make working enjoyable, I have a suspicion there will be one thing high on the “Enjoyable” list that may not even be on the “Bearable” list:

Being in a good team.

This one thing can make a real difference to your working life. I know (more...)

Friday Philosophy – Robots Rising & Tech Taking Over?

Today I saw some cracking photographs of a lighthouse. How many of us have at some point wondered if it might be nice to be a lighthouse keeper? The solitude, the scenery, the stoic fortitude in the face of the storm – quite literally. (Thank you Brendan Tierney for the photo I’ve stolen from him).

No one lives here anymore

It’s an odd job lighthouse keeper, it holds a special place in Western culture and (more...)

Friday Philosophy – “Technical Debt” is a Poor Term. Try “Technical Burden”?

Recently my friend Sabine Heimsath asked a few of us native English speakers what the opposite of “technical debt” was. My immediate reaction was to say:

I’d say (sarcastically) “proper development” or “decent designer” or even “what we did 25 bloody years ago when we were allowed to take pride in the software we created!”

But my next comment was less reactive and more considered. And that was to say that I did not (more...)

Friday Philosophy – New Conference, Same Sad Old Faces Up Front

I’ve been on the Oracle conference presenting circuit for well over a decade now and I must confess I enjoy it. Part of this is that I see lots of friends at nearly every conference – even in countries I have never been to before. This is because many of those friends are fellow presenters, who have been presenting for well over a decade now…

There he goes again, banging on and on and on…

(more...)

Friday Philosophy – How I Took The Step Up from Thought Leader to Paradigm Architect.

I’m sure you have come across the term “Thought Leader” before. You probably first came across it recently, in the last couple of years, and it is growing in occurrence. I’m always impressed by someone who describes themselves as a Thought Leader, I think it tells you a lot about the qualities of the person (*). At times I feel that I am also a Thought Leader – However, I recently decided to set myself (more...)

Friday Philosophy – Genial Greetings & Festive Fun

For many of us, today will be the last working day before the Christmas Break (unless you live in one of the many places that don’t celebrate Christmas, in which case ignore this post). So Merry Christmas everyone and Happy New Year!

My brother's "Christmas Card" to us this year

My brother’s “Christmas Card” to us this year

These good wishes are especially directed at those who have to be on call or actually working over the holiday period. It’s one of those (more...)