O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Encryption

Data that needs to remain confidential within the database should be encrypted. Examples of confidential information are credit card numbers and employee salaries.

Data that is encrypted within columns can’t be read without having the proper credentials. Once data in a column is encrypted, the column can no longer be utilized in search arguments.

Columns can be encrypted using a passphrase, symmetric key, asymmetric key, or a certificate. Symmetric keys provide reasonably secure encryption while also providing the best possible performance.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required