Hi Albert,

I have not used column encryption.

Hank

>Hi Hank,
>Starting to read this. Follow up questions:
>
>- it seems that if you use "deterministic encrypting" on a column, you can use the equal operator on the column (for filtering) but no other operators, correct?
>- it looks like it can still do grouping and sorting
>- this phrase is in the notes " Using deterministic encryption allows point lookups" - I take it "point lookups" just means matching values (i.e. WHERE clause values)?
>- have you seen any performance hit when using a WHERE clause on a column of encrypted data?
>
>SQL related question: when people talk about using stored procedures on SQL, what language is this in?
>
>...I am going to leave reading about KMS for today...eyes glazing over as it is :-)
>
>Albert
>
>>Hi Albert,
>>
>>I've used a prior version of encryption in development -- that was a real pain. I haven't used this one, as we haven't had the need.
>>
>>This method is the easiest there is to use, hands down. It is also considered the safest. No matter what kind of security method you use, there will always be a need to get the encryption key to where it is being used. The rules for that are rather detailed. Search on KMS (Key Management System) and be prepared for glazed-eyes phenomenon, until the picture comes clear.
>>
>>Hank