2021 – Large Data Structure Changes

Previous posts comparing JSON and RDBMS structure changes used a simple example adding RDBMS date columns or JSON keys. Now its time for something more challenging: Enterprise Master Patient Index (EMPI) All Patients must be given a new master identifier encompassing one or more patient records and their associated Medical Record Numbers (MRN’s) If the … Read more

2021 – JSON Path Expressions And Dynamic SQL

You say passing, I say using…let’s call the whole thing off I use colons, you use dollar signs, let’s call the whole thing off The previous post presented some pretty complex code including: JSON Path Expressions (dollar signs, ampersands, etc) Dynamic SQL (colons and the USING clause) JSON_EXISTS (PASSING clause) I promised an explanation of … Read more