7.4. Encrypt Data with Keys
Although not directly related to user security, it is also important at times that you obfuscate your data. If you are storing very sensitive information such as credit card numbers or security-related data, you have to be concerned about not only who can get access to the data through data database but also the security of the data in transport and in storage.
Microsoft SQL Server 2008 supports a variety of encryption options to further protect your data. These include explicit encryption of data through symmetric and asymmetric keys and certificates, and implicit encryption through the new Transparent Data Encryption (TDE) feature.
7.4.1. Understand SQL Server Keys
SQL Server uses keys to manage its encryption ...
Get SQL Server® 2008 Administration: Instant Reference 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.