Overview
- Promotes compliance with regulatory requirements such as GDPR
- Teaches counter-measures against common forms of attack
- Demonstrates how to implement SQL Server’s rich security model
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (14 chapters)
-
Front Matter
-
Threats and Countermeasures
-
Front Matter
-
-
Back Matter
Keywords
- Encryption
- Auditing
- Security auditing
- Hardening the Database
- Threat analysis
- Countermeasures
- Server Roles
- Credentials
- Database Audit
- Row-Level Security
- Dynamic Data Masking
- Impersonation
- Ownership Chaining
- Securing SQL Server
- Transparent Data Encryption
- Public Key Certificates
- GDPR
- Always Encrypted
- SQL Injection
- Backup Theft
About this book
Database professionals in today’s world deal increasingly 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 developers, administrators and architects can all play their part in the protection of their company’s SQL Server enterprise.
This book not only provides a comprehensive guide to implementing the security model in SQLServer, including coverage of technologies such as Always Encrypted, Dynamic Data Masking, and Row Level Security, but also looks at common forms of attack against databases, such as SQL Injection and backup theft, with clear, concise examples of how to implement countermeasures against these specific scenarios. Most importantly, this book gives practical advice and engaging examples of how to defend your data, and ultimately your job, against attack and compromise.
What You'll 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
- Mitigate the risk of credentials being stolen
- Put countermeasures in place against common forms of attack
Who This Book Is For
Database administrators who need to understand and counteract the threat of attacks against their company’s data, and useful for SQL developers and architects
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-4161-5
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Peter A. Carter 2018
Softcover ISBN: 978-1-4842-4160-8Published: 15 November 2018
eBook ISBN: 978-1-4842-4161-5Published: 14 November 2018
Edition Number: 2
Number of Pages: XVII, 349
Number of Illustrations: 91 b/w illustrations
Topics: Database Management, Microsoft and .NET, Systems and Data Security