SQL Server Security DBA Handbook [Paperback]

Securing SQL Server is one of the most important responsibilities of the SQL Server professional. Ensuring your data is safe requires a combination of good systems and database administration, and intelligent application design – weaving a security plan that matches the capabilities and vulnerabilities of each contributing part.

But at its root, security is concerned with controlling access – authenticating who can access the data on the server, authorizing what users can do with that data, and securing data as it is transported. These core topics are the focus of this book.

SQL Server Security Distilled shows you:

What you can do to secure date in SQL Server
How SQL Server handles authentication and authorization in different versions
How SQL Server security integrates with Windows security
The security pros and cons of different transport protocols
Ways to tailor SQL Server security to different applications, including client-server and Web applications
How to secure DTS packages
The implications of different types of replication for security
The security features of SQL Server CE and its server-side agents

Curlingstone is a new imprint providing practical information on all aspects of the technology, techniques, and job roles that form the database community.

Curlingstone is a new imprint providing practical information on all aspects of the technology, techniques, and job roles that form the database community.

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 more than 8 years ago. With the mantra "It is OK 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, 6 years ago. Now, he runs a training and consulting company, Holistech Inc., that 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. --This text refers to an alternate Paperback edition.