Skip to Content
Securing SQL Server: DBAs Defending the Database
book

Securing SQL Server: DBAs Defending the Database

by Peter A. Carter
October 2016
Intermediate to advanced
184 pages
4h 6m
English
Apress
Content preview from Securing SQL Server: DBAs Defending the Database

© Peter A. Carter 2016

Peter A. Carter, Securing SQL Server, 10.1007/978-1-4842-2265-2_5

5. Encryption in SQL Server

Peter A. Carter

(1)Botley, UK

Encryption is a process of obfuscating data with the use of an algorithm that uses keys and certificates. This means that if security is bypassed and data is accessed or stolen by attackers, then it is useless, unless the keys that were used to encrypt it are also acquired. This adds an additional layer of security over and above access control, but it does not replace the requirement for an access control strategy. Encrypting data also has the potential to degrade performance and increase the size of data, so you should use it on the basis of need, as opposed to implementing it on all data as a matter ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Securing SQL Server: DBAs Defending the Database

Securing SQL Server: DBAs Defending the Database

Peter A. Carter

Publisher Resources

ISBN: 9781484222652Purchase book