SQL Server Security Distilled and over one million other books are available for Amazon Kindle. Learn more
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server Security DBA Handbook Paperback – Nov 2002


See all 4 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback, Nov 2002
CDN$ 29.90 CDN$ 3.52

There is a newer edition of this item:

SQL Server Security Distilled
CDN$ 36.47
(6)
Usually ships within 1 to 2 months.

Best Canadian Books of 2014
Margaret Atwood's stunning new collection of stories, Stone Mattress, is our #1 Canadian pick for 2014. See all


Product Details

  • Paperback: 600 pages
  • Publisher: Curlingstones (November 2002)
  • Language: English
  • ISBN-10: 190434707X
  • ISBN-13: 978-1904347071
  • Product Dimensions: 14 x 1.9 x 22.9 cm
  • Shipping Weight: 408 g
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Bestsellers Rank: #3,140,848 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Publisher

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

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. --This text refers to an alternate Paperback edition.

Inside This Book (Learn More)
Browse and search another edition of this book.
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4.7 out of 5 stars
5 star
4
4 star
2
3 star
0
2 star
0
1 star
0
See all 6 customer reviews
Share your thoughts with other customers

Most helpful customer reviews

By Morris L. on April 15 2003
Format: Paperback
I spent just under 2 years doing the research for this book. In terms of breadth of coverage, there is no better book on the market. Rather than searching Microsoft's mammoth site for articles and white papers, everything you need to understand SQL Server security from version 6.5 to 2000 is in one book.
This book also goes deeper than the basic introduction to the various security mechanisms. Many books will tell you what SQL Server offers, but very few provide detailed information on *how* and *why* it works the way it does. Each chapter provides insights into the inner workings of SQL Server's security architecture and provides practical advice on how to use that information to keep your systems safe.
There are some other books that focus on showing you "hackers' tricks" for attacking your database servers, but this book takes the premise that if you do things the right way from the beginning, no hacker is ever going to find a trick that works on your systems. As an example, this book recommended configuring firewalls to block the traffic used by the Spammer virus long before the virus became news. Those who read this book and followed its advice slept soundly the weekend that Spammer was taking the Internet down.
Since the future of Curlingstone is in doubt, support for the book has moved to [...] and the author is not only committed to maintaining the current work but also planning to release an interim update in electronic format in the fall covering changes in SQL Server 2000 Service Pack 3 and any new discoveries found since December, 2002. The author also plans to release additional chapters on Yukon early next year for early adopters. This book is alive and will be updated periodically to keep its readers safe from the bad guys.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
I've been working with SQL Server for 11 years and run SQL Server Central.
And I learned a bunch from this book. This is one of the best references on SQL Server Security that I have seen written and I recommend it highly to every SQL Server DBA.
The book is written to cover versions 6.5, 7.0, and 2000. And it does a great job with each. It starts by looking at the way that logins are authenticated by the server. Great detail is given, even to the point of examining network sniffer traces to show how the communication occurs between the client and server.
From there, the database security is examined with separate chapters for v6.5 and 7/2000 since they work differently. Not only is the process explained, but the author notes where there are bugs and unforseen consequences of assigning security in certain ways.
The early chapters provide insight into how security works in SQL Server. The later chapters build on this to give hints and suggestions for implementing security in your applications, DTS, replication, and even SQL Server CE.
Overall, this is a must read for SQL Server DBAs. Developers will benefit as well since a thorough understanding can solve a great many problems and prevent even more.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
A good definition for exactly what this book does. It breaks down every segment of the SQL Server security infrastructure in intricate detail so security professionals and DBAs alike can make the right decisions. The books is a good fit for anyone who must support multiple SQL Server versions (including SQL 6.5/7/2000 and CE) in almost every conceivable scenario including replicated deployments.
Noticably absent were any discussions of the security implications of MSDE or a detailed guide to setting up SSL on SQL Server. That said, the information in this book is absolutely vital to anyone who needs to get up to date on SQL Server security and doesn't have time to sort through Books Online, White Papers, and assorted websites on the subject.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.


Feedback