Gal...can you direct me to the PASS article you speak of, and yes, it would be fabulous to have some semblance of code I could reference to...I think you may...

let me double check on exactly how we are encrypting...but do you know if there is a way to pin a table into RAM? I have researched for days...

Encryption/Decryption By Certificate...

Will that work? I suggested encrypting the search variable, then searching for it, but was told by our DBA that the encryption is time based, and I would never...

The client is willing to accept unencrypted data only in a "data in use" or "data in transit" state. I am being told that t here is a way...