design – Learning is not a spectator sport

Natural Keys versus Surrogate Keys….Here we are again!

Well….that blew up! 😀 Last week I published a video (which you can watch below if you haven’t seen it)

At my physical design talk at this year’s Yatra tour in India, one of the demos I do is multiple

INITRANS defines how many concurrent transactions you can have within a single datablock for a segment (table, materialized view, etc).

When you hear the word “blockchain” we typically think of the properties associated with tamper-proof information, with terminology such as

I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key

Some years ago I wrote an article for the UKOUG magazine called “Want a faster database – Take a drive