- 408 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
About this book
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
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
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