SQL Server 2005's new encryption functions enable the database engine ... OPEN SYMMETRIC KEY dboSymKey DECRYPTION BY CERTIFICATE dboCert; UPDATE Encrypted SET Encrypted.CardNumber = ...

(Microsoft did add backup encryption to all editions of SQL Server in 2014.) The other security feature added to the Standard Edition was key management for managing encryption keys. Additionally ...

I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2 ... There are two registry keys that must be set (if they don't already ...