I know it’s only a formatter, but honestly, I’m far more excited than I probably should be. After years of untangling messy SQL across countless systems, this feels like SSMS has given me a little gift. One right click, and suddenly the chaos becomes readable. Simple, practical, brilliant.

Recent Civica Cx 25.x schema changes replacing ContactAssociate.AssociationTypeId with AssociationTypeIds are causing reports and ETL processes to fail unexpectedly. This article explains what changed, why your contact reports may have stopped working, and how to update your SQL using string_split() to handle the new CSV-based structure. It also explores the wider issue of schema stability, undocumented changes, and the downstream impact on integrations and reporting.

Databases have a habit of growing quietly in the background until, one day, they’re suddenly everyone’s problem. Storage might feel cheap, but the ripple effects of an oversized database are anything but. Longer nightly ETL runs, sluggish reporting, bloated backups, and clogged networks all trace back to unchecked growth. The result? Your business loses precious time and flexibility, especially when jobs that should finish in an hour creep into the early morning. This post i