Securing SQL Server

DBAs Defending the Database

Peter A. Carter

$116.95 $93.60

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

APress
15 November 2018

SQL Server & MS SQL; Computer security; Network security

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

By: Peter A. Carter
Imprint: APress
Country of Publication: United States
Edition: 2nd ed.
Dimensions: Height: 254mm, Width: 178mm,
Weight: 699g
ISBN: 9781484241608
ISBN 10: 1484241606
Pages: 349
Publication Date: 15 November 2018
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

Part I. Database Security.- 1. Threat Analysis and Compliance.- 2. SQL Server Security Model.- 3. SQL Server Audit.- 4. Data-Level Security.- 5. Encryption in SQL Server .- 6. Security Metadata.- 7. Implementing Service Accounts for Security.- 8. Protecting Credentials.- 9. Reducing the Attack Surface.-.-Part II. Threats and Countermeasures.- 10. SQL Injection.- 11. Hijacking an Instance.- 12. Database Backup Theft.-13. Code Injection.- 14. Whole Value Substitution Attacks.

Peter Carter is a SQL Server expert with over 15 years of experience in database development, administration, and platform engineering. He is currently a consultant, based in London, England, UK. Peter has written several books across a variety of SQL Server topics, including security, high availability, automation, administration, and working with complex data types.