Rob Farley riffs on another T-SQL Tuesday topic:
But the checks that we do are more about things that the database can allow, but are business scenarios that should never happen.
Plenty of businesses seem to recognise these scenarios all too well, and can point them out when they come across them. You hear phrases like “Oh, we know that’s not right, it should be XYZ instead”. And they become reasons why they don’t really trust their data. It’s a data quality issue, and every time someone comes across a data quality issue, they trust the data a little less.
Click through for Rob’s thoughts.