Chapter 13
SQL Server Data Security
Encrypting data can provide an extra layer of security against unauthorized disclosure of confidential data. In this chapter we will discuss several enhancements to data security features found in SQL Server. Encryption of an entire database is now possible without requiring applications using the database to be modified by using Transparent Data Encryption. Data and log files are automatically encrypted when written to disk and decrypted when read from disk. SQL Server also offers management of encryption keys and functions for encrypting and decrypting data. In this chapter, we will discuss these features, and we will also look at the use of encryption keys to sign code modules, such as stored procedures. ...
Get Mastering 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.
