Securing SQL Server: DBAs Defending the Database, 2nd Edition

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and countermeasures, and provides an introduction to compliance that is useful for meeting regulatory requirements such as the GDPR. The multi-layered approach in this book helps ensure that a single breach does not lead to loss or compromise of confidential, or business sensitive data.

div>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 SQL Server, 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

Table of Contents

Part I: Database Security
Chapter 1: Threat Analysis and Compliance
Chapter 2: SQL Server Security Model
Chapter 3: SQL Server Audit
Chapter 4: Data-Level Security
Chapter 5: Encryption in SQL Server
Chapter 6: Security Metadata
Chapter 7: Implementing Service Accounts for Security
Chapter 8: Protecting Credentials
Chapter 9: Reducing the Attack Surface

Part II: Threats and Countermeasures
Chapter 10: SQL Injection
Chapter 11: Hijacking an Instance
Chapter 12: Database Backup Theft
Chapter 13: Code Injection
Chapter 14: Whole Value Substitution Attacks