Get 1 Year of unlimited Apress for $199
Instant access to all available titles and new releases Apress Access Subscription

Expert SQL Server 2008 Encryption

By Michael Coles , Rodney Landrum

  • eBook Price: $34.99
  • Print Book Price: $49.99
Buy eBook Buy Print Book

Expert SQL Server 2008 Encryption Cover Image

Expert SQL Server 2008 Encryption will show you how to efficiently implement SQL Server 2008 encryption functionality and features to secure your organizational data.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-2464-8
  • User Level: Intermediate to Advanced
  • Publication Date: October 14, 2009
  • Available eBook Formats: PDF

Related Titles

  • Pro Salesforce Analytics Cloud
  • Next Generation Databases
  • Pro Power BI Desktop
  • User Group Leadership
  • SQL Server AlwaysOn Revealed
  • Expert Performance Indexing in SQL Server
  • Beginning SOLID Principles and Design Patterns for ASP.NET Developers
  • Real World Windows 10 Development
Full Description

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

Table of Contents

  1. Introduction to Encryption
  2. Encryption Key Management
  3. Symmetric Encryption
  4. Asymmetric Encryption
  5. Extensible Key Management
  6. Transparent Data Encryption
  7. Hashing
  8. SQL CLR Cryptography
  9. Indexing Encrypted Data
  10. Encrypting Connections to SQL Server 2008
  11. Regulatory Requirements
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. PHP Objects, Patterns, and Practice


      View Book

    2. Beginning Android 3D Game Development


      View Book

    3. Troubleshooting Oracle Performance


      View Book

    4. Beginning Amazon Web Services with Node.js


      View Book