148 reputation
17
bio website
location
age
visits member for 4 years, 8 months
seen Nov 4 at 22:29

Jun
24
comment How to Protect Sensitive (HIPAA) SQL Server Standard Data and Log Files
decrypt the entire column. yikes! That is what you meant by "expensive".
Jun
23
comment How to Protect Sensitive (HIPAA) SQL Server Standard Data and Log Files
Is it even possible to search on encrypted fields using a "like" query?
Jun
23
comment How to Protect Sensitive (HIPAA) SQL Server Standard Data and Log Files
While I prefer the comment on my question to use BitLocker as the answer, he didn't post it as an anwer so I am marking yours because you have pointed me to a great document with more information on the topic. While column-level encryption would be a good idea though, it just isn't practical in all cases such as when you need to search on it.
Jun
23
comment How to Protect Sensitive (HIPAA) SQL Server Standard Data and Log Files
@Chris s, Thanks much. I had heard of BitLocker, but didn't know what it was. I now do and it is what I was looking for.