Expert SQL Server 2008 Encryption

Front Cover
Apress, Oct 15, 2009 - Computers - 320 pages
0 Reviews

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 What you’ll learn Take advantage of hardware security modules via extensible key management Implement targeted encryption of individual columns Secure an entire database at once with Transparent Data Encryption Encrypt disk volumes using BitLocker encryption Effectively design and manage encryption as part of your total security solution Digitally sign documents stored in your database Who this book is for

The audience for this book includes SQL Server DBAs, SQL developers, and .NET developers who want to take advantage of the powerful encryption functionality available in SQL Server 2008. The features of SQL Server 2008 provide a powerful set of tools to secure your most sensitive data, helping protect it from theft.

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
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Selected pages

Contents

Coles001pdf
1
Coles002pdf
21
Coles003pdf
47
Coles004pdf
73
Coles005pdf
111
Coles006pdf
127
Coles007pdf
151
Coles008pdf
167
Coles009pdf
185
Coles010pdf
203
Coles011pdf
231
ColesAppApdf
243
ColesAppBpdf
259
ColesAppCpdf
271
ColesIndexpdf
289
Copyright

Other editions - View all

Common terms and phrases

About the author (2009)

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.

Rodney Landrum is a MCSE working as a systems engineer, database administrator, and data analyst for a software development company in Pensacola, Florida, that specializes in applications for the healthcare industry. He writes software reviews and feature articles for numerous magazines, including Windows and .NET, SQL Server, Connected Home, T-SQL Solutions, Microsoft Certified Professional, and Electronic House.

Bibliographic information