This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Data observability explained: one dashboard complaint hiding three different problems

Data Quality, Data Reliability, and Data Observability: Telling the Three Apart

July 10, 2026
Pinal Dave
SQL Tips and Tricks
Data Observability

“The dashboard is wrong” hides three problems. Learn how data quality, data reliability, and data observability differ, and which one you are actually facing.

Read More
Gouache painting of a tidy archive room with rows of plain wooden drawers, a brass key ring hanging on a hook and a magnifying glass resting on an open ledger with blank pages, one drawer handle painted vermilion.

Data Governance: Catalog, Lineage and Data Quality

January 14, 2014
Pinal Dave
SQL Tips and Tricks
Data Observability, Database, Duplicate Records, SQL NULL, SQL Server Security

Data Governance is how you know what data you have, where it came from, who can see it and whether it is right. This post covers the catalog, lineage, access and data quality, with T-SQL checks you can run.

Read More
Gouache painting of five objects in a row on a long wooden table: a huge barrel, a small fast water wheel splashing, a basket of mixed fruits and vegetables, a magnifying glass resting on a balance scale, and one ripe pear tinted vermilion glowing in soft light.

The 5 Vs of Big Data: Volume, Velocity, Variety, Veracity and Value

October 2, 2013
Pinal Dave
SQL Tips and Tricks
Data Observability, Data Warehousing, Database

The 5 Vs of Big Data are volume, velocity, variety, veracity and value. This post walks a grocery chain through each one, so you can ask the same five questions about your own data before you choose a tool.

Read More
Muddy carrots scrubbed in a farmhouse sink, a colander of clean carrots on the drainboard and peelings in a bowl.

Cleaning Messy Data With T-SQL

April 8, 2012
Pinal Dave
SQL Tips and Tricks
Data Observability, ETL, SQL DateTime, SQL Server, SQL String

Cleaning messy data With T-SQL means trimming text, parsing dates safely, and preserving rejected source rows for correction and replay.

Read More
A metal sieve over a mixing bowl, flour passing through while a few lumps and a small pebble stay in the mesh.

Data Quality Rules in T-SQL

January 11, 2012
Pinal Dave
SQL Tips and Tricks
Data Observability, ETL, SQL Constraint and Keys, SQL Server

Data quality rules in T-SQL turn nulls, duplicates, invalid dates, and broken references into visible failures before rows reach reports.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com