SQL Server Security

by Litchfield, David

• ISBN13: 9780072225150
• ISBN10: 0072225157
• Edition: 1st
• Format: Paperback
• Copyright: 2003-09-12
• Publisher: McGraw-Hill Education

Summary

Addresses SQL Server vulnerabilities and provides security solutions. Covers installation, administration, and programming--plus security issues such as authentication, encryption, intrusion detection, and more. Written for IT professionals administering or programming any SQL Server-based application--includes coverage of SQL Server 7, SQL Server 2000, and SQL Server (Yukon).

Author Biography

Chip Andrews, MCDBA, MCSE+I, is a Software Security Architect for Claris Corporation as well as an independent security consultant. Chip has more than 16 years of software development experience in the C++, Visual Basic, Java, C#, and T-SQL languages. He is a contributing author to several periodicals including Microsoft Certified Professional Magazine, SQL Server Magazine, and Dr. Dobbs Journal. Chip also has contributed a chapter on SQL Server Security to the book Hacking Exposed Windows 2000 by Osborne. He has given presentations at Black Hat computer security conferences concerning SQL Server security and its role in the secure enterprise.

Table of Contents

1: SQL Server Security: The Basics

2: Under Siege: How SQL Server Is Hacked

3: SQL Server Installation Tips

4: The Network-Libraries and Secure Connectivity

5: Authentication and Authorization

6: SQL Server in the Enterprise

7: Auditing and Intrusion Detection

8: Data Encryption

9: SQL Injection: When Firewalls Offer No Protection

10: Secure Architectures

Appendix A: System and Extended Stored Procedure Reference

Appendix B: Additional Technologies that Impact SQL Server Security

Appendix C: Connection Strings

Appendix D: Security Checklists