Expert SQL Server 2008 Encryption

by Michael Coles, Rodney Landrum

Overview

Every day, organizations large and small fall victim to attacks on their data. Encryption provides a shield to help defend against intruders. Because of increasing pressure from government regulators, consumers, and the business community at large, the job descriptions of SQL DBAs and developers are expanding to include encryption. Expert SQL Server 2008 Encryption will show you how to efficiently implement SQL Server 2008 encryption functionality and features to secure your organizational data.

• Introduces encryption, guiding readers through its implementation in SQL Server
• Demonstrates advanced techniques such as the use of hardware security modules
• Covers all that a SQL Server database administrator needs to know about encryption

Product Details

ISBN-13:	9781430224648
Publisher:	Apress
Publication date:	04/06/2011
Edition description:	1st ed.
Pages:	320
Product dimensions:	7.30(w) x 9.20(h) x 0.90(d)

About the Author

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

Table of Contents

• Introduction to Encryption
• Encryption Key Management
• Symmetric Encryption
• Asymmetric Encryption
• Extensible Key Management
• Transparent Data Encryption
• Hashing
• SQL CLR Cryptography
• Indexing Encrypted Data
• Encrypting Connections to SQL Server 2008
• Regulatory Requirements