materialized view – Learning is not a spectator sport

Silent data corruption – constraints spanning multiple rows

One of the toughest problems in database applications is validation of data that extends “across” rows. We have declarative constraints

We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL

Whilst the ever increasing speed of storage and servers, and features likes In-memory are decreasing the need for large numbers

Just a quick post today that arose from an AskTOM question a little while back. Over the years and across

Just a quick discovery that came across the AskTOM “desk” recently. We have an outstanding bug in some instances of