Entries on system architecture, intent-driven development, and the evolving role of the engineer.
Moving from raw PHI to a HIPAA-compliant dataset requires more than just dropping columns. In this guide, we explore the SQL implementation of Safe Harbor de-identification, the nuances of salted SHA-256 hashing, and the critical architectural differences between De-identified and Limited Data Sets.
The BETWEEN operator is one of the most common tools in a SQL developer’s kit, yet it is often the source of subtle, production-breaking bugs. From the "inclusive" trap of DATETIME stamps to handling messy strings with TRIM and LEFT, this article explores how to use BETWEEN effectively without sacrificing performance or accuracy.
Calculating Mean and Median in SQL? Easy. But try finding the Mode (the most frequent value) and the database goes silent. Here's why MODE() never made it into standard SQL, and how to work around it.