Encrypting Personal Health Data – Part 2

In my previous entry, I summarized the rationale for our design decisions.  In this entry, I’ll dive into the technical implementations and share some code. Create a Test Certificate The first step is to install a new server certificate on the SQL Server.  In order to support things such as …

Encrypting Personal Health Data – Part 1

I work at a local children’s hospital with Microsoft’s Amalga platform as well as other clinical intelligence tools – mostly Microsoft based.  Just as most hospitals, we are concerned with how we can protect digital Personal Health Information (“PHI”) from disclosure to those without a “need to know”; while at …