SQL Server security distilled, second edition

An introduction to security for the SQL Server explains how to develop an effective security plan that considers every part of a system, covering how to secure data in SQL Server, authentication and authorization, how to customize SQL Server security to different applications, the pros and cons of various transport protocols, and other key topics. Original. (Intermediate)

SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Securing SQL Server is one of the most important responsibilities of the SQL Server professional.

SQL Server Distilled, Second Edition is a very carefully researched, clearly explained book on securing SQL Server, by an author who knows SQL Server inside and out. If you follow the practical guidelines that are clearly set out in this book, then you stand a very good chance of making sure that the data stored in your database is secure and that the conversation between your applications and the database is secure (preventing SQL injection attacks, etc.). For example, any database administrator who implemented the security precautions detailed in the book would not have been affected by the infamous Slammer virus.

This second edition offers practical advice on how to implement good practices that will ward off future viruses before they are even created, and it contains new content that reflects all updates to SQL Server's security mechanisms.

Table of Contents

1. A Security Roadmap
2. Authenticating Logins
3. Database Security in SQL Server 6.5
4. Database Security in SQL Server 7.0 and 2000
5. Securing Data on the Network
6. Designing Security for Applications
7. Securing Data Transformation Services
8. Replication Security
9. Managing Security for SQL Server CE

SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Securing SQL Server is one of the most important responsibilities of the SQL Server professional. "SQL Server Distilled, Second Edition" is a very carefully researched, clearly explained book on securing SQL Server, by an author who knows SQL Server inside and out. If you follow the practical guidelines that are clearly set out in this book, then you stand a very good chance of making sure that the data stored in your database is secure and that the conversation between your applications and the database is secure (preventing SQL injection attacks, etc.). For example, any database administrator who implemented the security precautions detailed in the book would not have been affected by the infamous Slammer virus. This second edition offers practical advice on how to implement good practices that will ward off future viruses before they are even created, and it contains new content that reflects all updates to SQL Server's security mechanisms. Table of Contents A Security Roadmap Authenticating Logins Database Security in SQL Server 6.5 Database Security in SQL Server 7.0 and 2000 Securing Data on the Network Designing Security for Applications Securing Data Transformation Services Replication Security Managing Security for SQL Server CE SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Securing SQL Server is one of the most important responsibilities of the SQL Server professional. __SQL Server Distilled, Second Edition__ is a very carefully researched, clearly explained book on securing SQL Server, by an author who knows SQL Server inside and out. If you follow the practical guidelines that are clearly set out in this book, then you stand a very good chance of making sure that the data stored in your database is secure and that the conversation between your applications and the database is secure (preventing SQL injection attacks, etc.). For example, any database administrator who implemented the security precautions detailed in the book would not have been affected by the infamous Slammer virus. This second edition offers practical advice on how to implement good practices that will ward off future viruses before they are even created, and it contains new content that reflects all updates to SQL Server's security mechanisms.