Counts representing Items and the impact on Data Compression and Encryption

All things in computers are identified in counts of digits (called bits) which are either on or off.  In this post, we’ll discuss how counts (discussed in the previous post) are used for identification. It’s easier to understand this if we think of a continuous line of bits that are …

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 …