Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Designing Transparent Data Encryption features


Security and User administration always highlights the importance of methods to secure and control the access to the SQL Server platform from instance level to database scope. To implement the SQL Server security feature, data encryption at the column level is the unsurpassed choice to provide security to the data platform. This will enable the first level of granularity for a specific data, whereas Transparent Data Encryption (TDE) is applicable for the entire database, most importantly for database and data encryption.

SQL Server 2008 opens up a new dimension in encryption methods by introducing Transparent Data Encryption (TDE), which allows entire database encryption without affecting client applications or code changes. This will also encrypt the corresponding database backup without having any additional step to encrypt such a backup.

In this recipe, let us go through the important aspects of designing transparent data encryption features...