Term Completion & Search–Another Great use for Full Text Search in SQL Server

As is every hospital in the US, we are working to move to ICD-10 for our coding and billing.  Our EMR system has been challenged with the conversion and we’ve found a number of anomalies in our validation. Our vocabularies include: ICD-9, ICD-10, SNOMED, and great commercial vocabulary from IMO.  …

Encrypting Personal Health Data – Part 4: Bulk Import with SSIS

This post will attempt to tie everything together that we have discussed pertaining to how to de-identify Personal Health Information (“PHI”) for reporting purposes. For this final post, we will walk through a step-by-step example using SQL Server and a SQL Server Integration (“SSIS”) package that will allow us to …