Review lookup data load behavior for cache freshness, comparison rules, duplicate reference keys, and unmatched rows before trusting the output.
Converting XML Documents to JSON With FOR JSON PATH
A partner asks for JSON from your XML export. Build the nested shape, decide what an empty order looks like, and avoid the escaped-array surprise.
What a Preview Build Is For, and What It Is Not
Use a SQL Server preview to test specific features and report reproducible issues while keeping production data and recovery paths separate.
What Is a Data Warehouse?
A data warehouse is built for questions, not transactions. Facts and dimensions in plain words, why the star schema reads the way people talk, what a date dimension is for, and when you do not need one.
Incremental Loads: Moving Only What Changed
Design an incremental load with reliable boundaries, retained change information, delete handling, and a watermark that advances only after success.
Data Quality Checks Worth Running After Every Load
Run data quality checks for missing values, duplicate keys, invalid ranges, and count reconciliation before promoting a loaded batch to production.
SQLAuthority News – Most Valuable Photographer – Vijay Raj
Vijay Raj, a Technology Evangelist and Microsoft MVP, recently took photos of my daughter that became wallpapers on many desktops. Visit his photo page.