This is information that we provide when you register an account on our favorite website, fill out a job application, or apply for a mortgage. This valuable, often sensitive, asset data stored in SQL Server database, and entrusted to the Database Administrator, who must use the weapons and strategies at his disposal in the "war" to protect sensitive data from potential hackers, phishers, rumor mongers and identity thieves. He explains how to assess and categorize the data elements in accordance with the sensitivity, regulate access to different categories of data using database roles, views and stored procedures, and then how to implement a data architecture that efficiently and securely use SQL features available encryption, such as cell-level encryption, transparent data encryption and one-way encryption. At every stage the author does not only cover how the features work, but also describes the situation when they and do not match, and each time emphasizing the steps that must be taken to ensure that the solutions are kept. Table of contents Chapter 01: Understanding Sensitive Data Chapter 02: Encryption Cell level Chapter 06:: Data Classification and the Role of Chapter 03: Schematic Architecture Strategy Chapter 04: Basics Encryption for SQL Server 2005 Transparent Data Encryption chapter Chapter 07: One-way Encryption Chapter 08 : confused Chapter 09: HoneyCombing Database Chapter 10: Solution Layering Appendix A: Look and Function Reference Appendix B: Database HomeLending