Securing SQL Server

Protecting Your Database from Attackers

Denny Cherry

• Publisher: Syngress
• Year: 2012
• Print ISBN:
  9781597499477
• Edition: 2
• eBook ISBN:
  9781597499521
• Topic: Computer Science
• Subtopic: Cyber Security
• Index: Computer Science

SQL server is the most widely used database platform in the world, and a large percentage of these databases are not properly secured, exposing sensitive customer and business data to attack. In Securing SQL Server, 2e, readers learn about the potential attack vectors that can be used to break into SQL server databases as well as how to protect databases from these attacks. In this book written by Denny Cherry, a Microsoft SQL MVP and one of the biggest names in SQL server today, readers learn how to properly secure a SQL server database from internal and external threats using best practices as well as specific tricks the authors employ in their roles as database administrators for some of the largest SQL server deployments in the world. "Denny Cherry is what would happen if Bill Gates and AC/DC got together to create a sibling. He's a bare-knuckles, no holds-barred technologist, and you can bet that if he tells you that something does or doesn't work, he's speaking from experience. Active in the community, his passion is sharing. You'll enjoy this book."--Buck Woody, Senior Technology Specialist, Microsoft - Presents hands-on techniques for protecting your SQL Server database from intrusion and attack - Provides the most in-depth coverage of all aspects of SQL Server database security, including a wealth of new material on Microsoft SQL Server 2012 (Denali) - Explains how to set up your database securely, how to determine when someone tries to break in, what the intruder has accessed or damaged, and how to respond and mitigate damage if an intrusion occurs

Table of contents

• Cover image
• Title page
• Table of Contents
• Copyright
• Acknowledgements
• Dedication
• Author Biography
• About the Technical Editor
• Introduction
• Chapter 1. Securing the Network
• Chapter 2. Database Encryption
• Chapter 3. SQL Password Security
• Chapter 4. Securing the Instance
• Chapter 5. Additional Security for an Internet Facing SQL Server and Application
• Chapter 6. Analysis Services
• Chapter 7. Reporting Services
• Chapter 8. SQL Injection Attacks
• Chapter 9. Database Backup Security
• Chapter 10. Storage Area Network Security
• Chapter 11. Auditing for Security
• Chapter 12. Server Rights
• Chapter 13. Securing Data
• Appendix A. External Audit Checklists
• Index