Encryption Support in SQL Server

Let’s face it: data that is stored in databases is interesting not only to us as users but to many others in the world whom we might not know or trust. With the increased leverage of the power of relational databases by businesses and consumers, database vendors are under greater pressure to provide more security-related features.

Other than locking down access to SQL Server databases, administrators and developers can provide another layer of protection against the bad guys, and that is encryption. At a high level, encryption takes interesting information, such as your credit card number, and translates it into a binary representation that can be understood only by authorized parties. Data can be encrypted for ...

Get Programming Microsoft® SQL Server™ 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.