Run a profiling pass on a messy table for the first time and the report reads like a doctor listing…
Browsing: SQL
I wrote about learning today for the editorial: I Can’t Make You Learn. I sure hope you want to learn.…
A number on the dashboard gets questioned in a meeting. Nobody can prove who is right, and within ten minutes…
A customer was trying to compare two tables and capture a state as a performance metric. In this case, they…
By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause.The reason…
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but I’d like to apply the Goldilocks…
I type fairly well. Well, I type fast, but I do wear out a backspace key relatively quickly on most…
Many years ago, before I joined Oracle, I was working on a major modernisation project. We were replacing an existing…
One of the things I’ve been requesting for a number of years is cost information. I could see this coming…
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but you have no idea what it…