Apress-Expert-SQL-Server-2008-Encryption-Oct-2009.pdf

cyan yeLLOW
  MAGENTA   BLACK
  PANTONE 123 C
Books for professionals by professionals® The EXPERT’s VOIce® in SQL Server
Expert SQL Server 2008 Encryption
Dear Reader, Expert
The barbarians are at the gate, and it's your job to keep them at bay. Encryption 2008 Encryption SQL Server
is truly the last line of defense in your total security strategy. Customers are
demanding data security, governments are legislating it, and CIOs are order-
ing it. Fortunately SQL Server 2008 provides major improvements in database
encryption to help you fulfill your obligations to protect critical data.
Michael Coles Author of Database encryption is a topic that seems to be misunderstood by many
Pro T-SQL 2008 professionals. I wrote this book to explain encryption in simple terms, help
Programmer’s Guide clear away misconceptions about the role of encryption, and to help SQL Server
developers and DBAs implement encryption in the database as part of their
Pro SQL Server 2008 XML
total security strategy. Encryption is a powerful defense, and not so difficult to
Expert
implement as you might think. I believe in encryption, apply it in my job, and
want you to have it as part of your “toolkit” too.
In this book you'll learn how to create and manage encryption keys, includ-
ing symmetric keys, asymmetric keys, and certificates. You'll learn how to take
full advantage of SQL Server's built-in encryption functionality, including cell-
level encryption, Extensible Key Management (EKM), and Transparent Data
Encryption (TDE). You'll learn how to set up and configure muni- SQL Server
cations between your SQL Server and your client applications. You’ll explore
advanced SQL Server encryption functionality, like extending the core func-
tionality through use of the SQL CLR.
Along the way, you'll gain a better understanding of your obligations to pro-
tect sensitive data under your control and the basics of assessing threats to your