Chapter 14. Encrypting SQL Server Data and Communications

The data stored in Microsoft SQL Server 2005 can be both valuable and confidential. The information stored in databases in SQL Server could be medical histories, incomes, or company trade secrets. This information needs to be protected against unauthorized access.

Many of the controls presented in this book have been access controls—that is, controls that determine who has authorization to access what. A determined hacker can circumvent these controls through various means, such as sniffing network traffic, going dumpster diving for backup tapes, or making inference attacks.

A more sophisticated approach to control is to use an in-depth defense strategy, wherein there are multiple layers ...

Get Microsoft now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.