Mastering SQL Server 2000 Security (Gearhead Press--In the Trenches) (Paperback)

~ (Author), Curtis W. Young (Author) "Microsoft SQL Server has continued to grow i market share over the last several years..." (more)
Key Phrases: sysadmin server role, designing application security, current activity window, Enterprise Manager, Client Network Utility, Data Transformation Services (more...)

Editorial Reviews

Product Description

Learn how to protect corporate information by properly designing, managing, and maintaining security at the database level
Security is a primary concern in all aspects of development and IT administration. While locking down networks and erecting firewalls will always be necessary, so much more can be done to protect a corporation's most valuable intangible assets: accounting records, customer lists, and inventories. Microsoft SQL Server 2000 has proven itself to be the fastest and most reliable product available for protecting corporate data. No other book covers as thoroughly the subject of security design and implementation strategies; Mastering SQL Server 2000 Security fills that gap in literature with practical, hands-on advice.
Packed with indispensable design information that can make a tightly secured database faster and easier to use, this book is essential reading for both administrators and developers of databases. The authors explain just how much more is possible in the task of protecting corporate information by properly designing, managing, and maintaining security at the database level.
From this book you will:
* Learn the ins and outs of SQL Server 2000 Security design
* Understand the implementation differences between SQL Server Authentication and Windows Authentication
* Understand the security options in SQL Server 2000 for Internet applications
* Integrate the security of Windows 2000 (Kerberos) into your SQL Server deployment
* Master the security requirements for distributed data environments, such as DTS, replication, linked servers, and data warehousing

From the Back Cover

Learn how to protect corporate information by properly designing, managing, and maintaining security at the database level

Security is a primary concern in all aspects of development and IT administration. While locking down networks and erecting firewalls will always be necessary, so much more can be done to protect a corporation's most valuable intangible assets: accounting records, customer lists, and inventories. Microsoft SQL Server 2000 has proven itself to be the fastest and most reliable product available for protecting corporate data. No other book covers as thoroughly the subject of security design and implementation strategies; Mastering SQL Server 2000 Security fills that gap in literature with practical, hands-on advice.

Packed with indispensable design information that can make a tightly secured database faster and easier to use, this book is essential reading for both administrators and developers of databases. The authors explain just how much more is possible in the task of protecting corporate information by properly designing, managing, and maintaining security at the database level.

From this book you will:

• Learn the ins and outs of SQL Server 2000 Security design
• Understand the implementation differences between SQL Server Authentication and Windows Authentication
• Understand the security options in SQL Server 2000 for Internet applications
• Integrate the security of Windows 2000 (Kerberos) into your SQL Server deployment
• Master the security requirements for distributed data environments, such as DTS, replication, linked servers, and data warehousing

See all Editorial Reviews

Product Details

• Paperback: 500 pages
• Publisher: Wiley; 1 edition (August 30, 2002)
• Language: English
• ISBN-10: 0471219703
• ISBN-13: 978-0471219705
• Product Dimensions: 9.2 x 7.5 x 1 inches
• Shipping Weight: 1.8 pounds
• Average Customer Review: 2.0 out of 5 stars  See all reviews (1 customer review)
• Amazon.com Sales Rank: #930,442 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

2.0 out of 5 stars This book is for a beginner, June 10, 2004

By A Customer

If you are a dba with I would say less than 1-2 years experience, then maybe get this book. For a seasoned dba, its going to be a big disappointment. I was expecting explanations at a much more granular level covering much more complex topics. Its basically a primer on how to do the most basic things via the gui (oh, and by the way there is a stored procedure way to do things too). If you are new to SQL Server EM and are unfamiliar with the menus, wizards, and the gui, then it might be a good "get me out of the frying pan quickly" book. And I say "might" because most people can figure things out just by going through the gui and looking at Books Online. The most useful chapter, I found, was the auditing chapter. Some things the authors point out about security I would actually disagree with if I was building a "highly" secure system. For example, which accounts to put in the admins group. For what its worth, I got a lot more from the MS site believe it or not.