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
Vertical technical decision flow for validating an AI-generated SQL Server index recommendation through evidence, design review, workload testing, deployment, monitoring, and rollback.

Validating AI-Generated Index Recommendations

August 12, 2026
Pinal Dave
SQL Tips and Tricks
Idera

Validating AI-generated index recommendations is the step between a persuasive script and a change you can defend in production.

Read More
A male database consultant stands between a green falling cost graph and a red service failure indicator

Cost Optimization That Never Reaches the Invoice

August 11, 2026
Pinal Dave
SQL Tips and Tricks
SQL Performance

SQL Server cost optimization has a problem nobody puts on the slide. The savings are real, and none of it reaches the invoice.

Read More
Data Quality and Observability: A Field Guide in Six Parts.

Data Quality and Observability: A Field Guide in Six Parts

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

Master data quality and observability in six parts: name the problem, rank the risk, define rules, place controls, monitor for drift, and respond calmly.

Read More
Data incident response: a calm operator working the problem in a mission control room

You Just Found Bad Data in Production. Now What?

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

Found bad data in production? Use this data incident response playbook: triage, contain, trace the source, fix, verify, tell people, and review calmly.

Read More
Data pipeline monitoring: every cockpit gauge green while the world outside is upside down

It Passed Every Test and Still Broke: Four Signals Validation Never Catches

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

Every test passed and the dashboard still broke. Here are four signals validation never catches: freshness, volume, schema drift, and distribution shift.

Read More
Where data quality checks live: an inspector pulling defective items off a conveyor belt

Where Should a Data Quality Check Live? Gates, Controls, and Quarantine

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

A check in the wrong place catches bad data too late. See where each data quality check belongs: ingestion, transformation, release gates, and quarantine.

Read More
Data quality rules illustrated: hammering a nail into fog versus building a wall from a blueprint

“Clean Data” Is Not a Requirement: Writing Rules People Can Act On

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

Clean is a feeling, not a spec. Write data quality rules people can act on, with a testable check, a threshold, and a named owner, so every failure is owned.

Read More
Previous 1 2 3 4 5 6 … 571 Next
  • Books
  • Testimonials
  • Privacy Policy

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