I've moved!

I know how annoying it is to get these notices in your feed reader, so I'm sorry! But I've moved this blog to a new address - jeffkemponoracle.com. Please update your links and readers, thanks!

Demise of the Perth AUSOUG Conference?

Got an email this morning from the Australian Oracle User Group...

[Full Article]

SQL Injection License Plate

Bobby Table's got himself a car :)

[Full Article]

A good entry-level interview question

I think this would make a reasonable question for would-be database developers:

[Full Article]

Lesson learned today

Comment out all "DROP TABLE" commands in my scripts.

[Full Article]

Please, hard-code your literals

As Feuerstein says,

We all know that hard-coding is a bad thing in software. But most developers think of hard-coding simply as typing a literal value into your program whenever you need it.
...
So what's wrong with doing this? Nothing - as long as the value is never going to change. But what's the chance of that happening? In fact, what's the chance of anything staying the same (never changing) in our application requirements and resulting code?

Almost nil.

[Full Article]

Why EAV is bad, mostly; and why it is used so often

Tom Kyte offers some astute observations regarding EAV data models in general.

[Full Article]