SQL Server Security Distilled - 2nd Edition by Morris Lewis (Paperback)

About the Book

SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Written by someone who knows SQL Server inside and out, this carefully researched second edition features practical advice on how to implement good practices that will ward off future viruses before they are even created.

Book Synopsis

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.

This is a very carefully researched, clearly explained book on this subject by someone who knows SQL Server inside and out. If you follow the practical guidelines set that are clearly set out in this book then you stand a very good chance of making sure that the data stored in the database is secure and that the conversation between your applications and the database is secure (preventing SQL injection attacks and so on). For example, any DBA who implemented the security precautions detailed in the book would not have been affected by the infamous Slammer virus (http: //members.microsoft.com/partner/support/slammer.aspx). The second edition will just have more practical advice on how to implement good practices that will ward off future viruses before they are even created.

Special Note: This update will contain new content that reflects all updates to SQL Server's security mechanisms resulting from Microsoft's Palladium Security initiative. It will also be written for the latest Service Pack (SP3).

About the Author

Morris Lewis has been smitten with Structured Query Language since the first time his professor wrote SELECT * FROM AUTHORS on the chalkboard 14 years ago. He has worked with no other database server since he first installed SQL Server 4.21a on his 16MHZ Intel 386 computer with all of the 32 megabytes of RAM running Windows NT 3.51 many years ago. With the mantra, "It is O.K. to worry if they really are out to get you," he has focused on all aspects of securing Windows and SQL Server since he connected his first server to the Internet. Now, he runs a training and consulting company, Holistech Inc., which focuses on helping clients create better and more secure database applications, and teaching them how to avoid the mistakes that can lead to problems in the future.