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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.