O'Reilly logo

Mastering SQL Server® 2008 by Gentry Bieker, Michael Lee

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

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. ...

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