137 reputation
16
bio website
location Seattle, WA
age 29
visits member for 4 years, 9 months
seen Dec 3 '12 at 22:34

Nov
23
awarded  Notable Question
Nov
24
awarded  Popular Question
Jun
30
accepted How to encrypt data at rest
Jun
30
awarded  Commentator
Jun
30
comment How to encrypt data at rest
Also, it strikes me as not very secure that the certificate for encrypting and decrypting would be sitting in the database together with the information?
Jun
30
comment How to encrypt data at rest
Basically, what I need is TDE, but it only works on Sql Server Enterprise Edition, and we have a remote server using Web Edition. The threat is that the data is private information and should not be seen plain text. I wonder how people encrypted their Sql Server Databases before TDE came along with 2008? I have seen EncryptByKey and DecryptByKey. Seems like it will be a usable option in my case, but I was hoping for more like an alternative to TDE. Oh well, thanks for clarifying. :)
Jun
29
asked How to encrypt data at rest
Jun
29
accepted How to see if data is encrypted
Jun
9
comment Certificates in SQL Server 2008
Wow, what a hassel. Thank you for pointing me to that.
Jun
9
awarded  Scholar
Jun
9
awarded  Editor
Jun
9
accepted Certificates in SQL Server 2008
Jun
9
revised How to see if data is encrypted
added 105 characters in body
Jun
9
comment How to see if data is encrypted
Thanks for the recommendation - I've looked at some screenshots and I don't see what part is telling me that there is encrypted data?
Jun
9
asked How to see if data is encrypted
Jun
9
awarded  Supporter
Jun
9
comment Certificates in SQL Server 2008
Thanks again, Remus - it explains a lot that the client is accepting any certificate that the server throws out. I've noticed that none of the certificates that show up in MMC for my server show up in SSMS under mydatabase->security->certificates, but making self-signed ones you can make multiple. How can you specify which certificate to use, either from the client or the server?
Jun
8
awarded  Student
Jun
8
asked Certificates in SQL Server 2008