By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause.The reason…
Browsing: SQL
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…
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited the community the blog about the…