The missing multiplication aggregation in SQL
A few days back on Twitter, a cool little discussion arose out of the SQL Daily regular tip – the
Tag: developer
The weirdest reason to avoid SELECT *
A quick Google or Bing search and you’ll find no limit to the number of articles on databases that tell
Developer Live wrap up
The Developer Live event for database has concluded. Thank you to the (almost) 2000 people that attended my talk across
Completely free training for Oracle novices
At college/university, the learning path for a computing-related course often includes several coding languages, and occasionally some treatment of database
Why relying on default DATE formats is a bug
Today’s quick but important message is…don’t be lazy! Look….I get it If given the choice of typing: ’01-JUL-20′ or typing
GROUP BY better than DISTINCT for materialized views
One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the
New LINESIZE settings for SQLPlus
Anyone that has used SQL Plus since its inception will be familiar with this frustration: There is my window, with
Cloning a schema with a one line command
In the world of DevOps, continuous integration and repeatable test cases, the demand for being able to quickly build a
The death of UTL_FILE – part 2
I wrote a post a while back call “The Death of UTL_FILE”, and probably because of it’s click-bait title I
It’s all downhill past 30
Yes, it sounds like a lamentation of the aging process, and from my own experience, it is definitely true that
Learning is not a spectator sport 