A customer was trying to compare two tables and capture a state as a performance metric. In this case, they…
Browsing: SQL
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…
The SQL analytics endpoint is a separate layer that maintains its own catalog and cache over the Delta tables in…
If you’ve been watching AI roll through the data community and thinking, “this seems useful, but I have no idea…
Annabel retired from Redgate Software this week. Across most of my career at Redgate, I’ve participated in many events, some…