Chapter 9. Encrypting SQL Server 2012 Data and Communications

The data stored in Microsoft SQL Server 2012 can be both valuable and confidential. The sensitive information stored in databases in SQL Server could be medical records, Social Security numbers, salaries, income data, or company trade secrets. This information needs to be protected against unauthorized access. In many cases, government and industry regulations require that this sensitive data be stored in an encrypted format.

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 ...

Get Microsoft® SQL Server 2012 Management and Administration, Second Edition 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.