Tip: Avoid using reserved words as object names. The other day, I chose a name for a schema in SQL Server that had some unintended consequences. I had created some audit tables to track historical changes and named the schema "audit". It didn't occur to me that "audit" is a SQL Server reserved word. I... Continue Reading →
A Bird’s Eye View of Data Migration
Data migration can be incredibly daunting. Finding a home for every field, pixel, and document in a new system is like moving between libraries that have completely different classification systems. Or like helping an elderly relative move out of their decades-long home and downsize into a new apartment. Often it feels like being caught up... Continue Reading →