Overview
Provides real-world examples and discussion on the implementation of security
Helps in implementing an encryption strategy that best suits your needs
Promotes a proactive approach to security, including threat analysis and defence-in-depth
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (9 chapters)
Keywords
About this book
Database professionals in today's world deal increasingly often with repeated data attacks against high-profile organizations and sensitive data. It is more important than ever to keep your company’s data secure. Securing SQL Server demonstrates how administrators and developers can both play their part in the protection of a SQL Server environment.
This book provides a comprehensive technical guide to the security model, and to encryption within SQL Server, including coverage of the latest security technologies such as Always Encrypted, Dynamic Data Masking, and Row Level Security. Most importantly, the book gives practical advice and engaging examples on how to defend your data -- and ultimately your job! -- against attack and compromise.
- Covers the latest security technologies, including Always Encrypted, Dynamic Data Masking, and Row Level Security
- Promotes security best-practice and strategies for defense-in-depth of business-critical database assets
- Gives advice on performing threat analysis and reducing the attack surface that your database presents to the outside world
What You Will Learn
- Perform threat analysis
- Implement access level control and data encryption
- Avoid non-reputability by implementing comprehensive auditing
- Use security metadata to ensure your security policies are enforced
- Apply the latest SQL Server technologies to increase data security
- Mitigate the risk of credentials being stolen
Who This Book Is For
SQL Server database administrators who need to understand and counteract the threat of attacks against their company’s data. The book is also of interest to database administrators of other platforms, as several of the attack techniques are easily generalized beyond SQL Server and to other database brands.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Securing SQL Server
Book Subtitle: DBAs Defending the Database
Authors: Peter A. Carter
DOI: https://doi.org/10.1007/978-1-4842-2265-2
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Peter A. Carter 2016
eBook ISBN: 978-1-4842-2265-2Published: 21 October 2016
Edition Number: 1
Number of Pages: XIX, 165
Number of Illustrations: 1 b/w illustrations, 37 illustrations in colour