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

Often when you are building a slides for a presentation you need to animate something on screen to show its

As many readers will be aware, we introduced a cool new JSON datatype in 21c which offers more features and

For the many cases, simply having an EXPLAIN PLAN function will do the job when it comes to tuning SQL.

Just a little bit of Friday fun with PL/SQL data types for this post. Let’s explore the performance differences when

Rather than bore you with a lengthy tome about the event, I’d thought I would summarise the week with pictures

Ask an Oracle practitioner what DBMS_METADATA is used for, and they’ll (correctly) tell you it used to retrieve the DDL

The recyclebin is a very cool feature in the Oracle Database, and a great “Get of our jail free” card

In 12c, we introduced a feature call Row Archival, which is a means of integrating typical archival models that we