SQL Server Essential Reference provides solid grounding in fundamental SQL Server 7 administrative tasks to help you tame your SQL Server environment. With coverage ranging from installation, monitoring, troubleshooting, security, managing client connectivity, storage and transaction management, and back-up and recovery plans, SQL Server Essential Reference breaks down SQL Server administration into its necessary functions and key conceptual areas, making a quick reference work even more quickly.This speed and flexibility is derived from Sharon Dooley¿s care with the layout and content of the book. Utilizing convenient referential aids such as concise descriptions, useful examples, code examples, performance tips, warning and danger alerts, best practices, and helpful cross-references, this portable volume is the ultimate SQL Server reference. SQL Server Essential Reference is a must-have for any SQL Server administrator.
Book Description
Editorial Reviews
From the Back Cover
About the Author
Sharon Dooley's love affair with computers began 35 years ago when she learned to write FORTRAN for the IBM 7094. Since then she has worked with a variety of mainframe, minicomputer, and PC database management systems including SQL Server, Sybase, IMS, Oracle, and IDMS (not to mention the venerable dBase). A true veteran of Microsoft's SQL Server, Sharon has been working with the product since the OS/2-based Version 1.0. Since then, she has maintained an active consulting practice specializing in Microsoft SQL Server. She works as a database designer, database administrator, and as a mentor for application developers who are writing front ends in Visual Basic and ASP. For 12 years, Sharon has been writing Transact-SQL code for stored procedures, triggers and views that implement complex security schemes for applications, such as document image management, telephony market research, sales force automation, and marketing communications tracking. She is skilled at analyzing and solving performance problems.
Well-known as an instructor and author, Sharon continues to share her knowledge with the IT community. Currently an instructor for Learning Tree International, Sharon has also authored many of their training seminars, including SQL Server 7 Administration, SQL Server 6 System Administration, Optimizing SQL Server Database and Application Performance, and Sybase System 10 Hands-On Introduction. She is the technical editor of Learning Tree's SQL Server 6 Introduction and Developing SQL Server Applications with Visual Basic courses. In addition, Sharon frequently presents at professional conferences and contributes articles to http://www.swynk.com. She faithfully follows SWYNK's SQL Server list servers where her explanations and answers to questions have lead to her being referred to as a "SQL Server goddess." She is also the lead author of Professional SQL Server 6.5 Administration published by Wrox Press, and served as technical reviewer for Joe Celko's Instant SQL Programming (Wrox Press). Among her other positions and achievements, Sharon is a member of the Professional Association for SQL Server (PASS) Web Services Committee, which is responsible for (among other things) developing a SQL Server-based Knowledge Portal that provides a repository of SQL Server information. Ms. Dooley also holds a bachelor's degree in Computer and Information Sciences (Magna cum Laude) from the University of Pennsylvania.
When Sharon can tear herself away from SQL Server, she is an avid vegetable gardener and entertains her three feline housemates.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
29 of 30 people found the following review helpful:
5.0 out of 5 stars
Like Having An Experienced DBA At Your Side,
By
This review is from: SQL Server 7 Essential Reference (The Essential Reference Series) (Paperback)
As databases become more and more common, network engineers without prior training are becoming responsible for database administration and they need to become competent quickly. This book touches base with all the important points in database and server administration in a clear, concise format that quickly educates the reader, guides them to important activities, and steers them around obscure obstacles.Sharon Dooley takes a practical, hands-on approach to database administration that reflects a wealth of field experience. Having read my way through more than 5 SQL books already I might have passed on one entitled SQL Server 7.0 Essential Reference, expecting it to be too basic. What I found was a perceptive field guide to managing a SQL Server. This book provides a clear, understandable review of administration topics that is useful to experienced administrators for the richness of knowledge revealed while remaining an excellent book for persons new to database work who need an introduction that is at once accessible, concise, and relevant. I disagreed with the author about the value of defragmenting SQL Servers and believe that if she is going to say that there has been no proof of the value of defrag software she needs to deal with the findings of the National Software Testing Laboratory on Diskeeper. She also says that Microsoft is fuzzy about supporting defragged databases and yet Diskeeper was one of the first products to gain the Certified for Windows logo. I think she is out of date in this area. I also thought her distrust of third-party backup software needed more defense as I personally have not run into problems though she alluded to many. Other than these specific points I found the material to be outstanding and I would acknowledge that there is room for disagreement on these points. For the experienced administrator the book reveals undocumented and falsely documented issues that can improve administration. The book is very realistic about what can and cannot be done on a SQL Server. I liked the point made that server tuning can only account for about 10% of performance while the bulk of what really matters is in database design. Upgrading from 6.X to 7.0 is covered very nicely. The author provides useful suggestions for dealing with what might not convert seamlessly in an upgrade. I have worked with SQLdiag numerous times. Sharon Dooley is the first person that has clarified that this utility must be run directly on the server; it cannot run from a client workstation. I liked the way she touched on many of the places where an administrator could go wrong. The discussion of SQL Mail reviews how to make it work with Lotus Notes as well as POP3 and Exchange. Previously I had thought that if I did not have an Exchange Server available I could not setup email alerts. Books On Line is not as helpful here as is Sharon Dooley. This book is like having an experienced DBA standing right beside you interpreting the fine points and telling you about undocumented or misdocumented features while you do your everyday work. The general tips and warnings alone are more than worth the cost of the book.
5 of 5 people found the following review helpful:
5.0 out of 5 stars
Excellent book written by an expert,
By Andrew in Illinois "Andrew" (Illinois, USA) - See all my reviews
This review is from: SQL Server 7 Essential Reference (The Essential Reference Series) (Paperback)
Ms. Dooley is among just a handful of people who can write about SQL Server at such an experience level. She shares her deep expertise and wisdom gained through hands-on use of SQL Server and real-world implementations. I also enjoyed generous warnings and tips which appeared throughout the book. They make the book fun to read and vividly illustrate technical points. As I read the book I kept thinking, "This is so useful and practical!" Ms. Dooley does an excellent job in presenting the information in a way that is best to learn and remember. Obviously, the author's experience as a prominent SQL Server trainer helped her to organize the book in such a great fashion. I recommend this book to a wide range of SQL Server administrators and developers. The book covers SQL Server 7.0, has some mentions of SQL Server 2000, and also refers to older versions that may benefit users who have experience with prior releases. Developers, especially advanced ones, will also benefit from the best coverage of DMO I've seen in any resource.
5 of 5 people found the following review helpful:
5.0 out of 5 stars
DBAs essential ref,
By Allan M Mitchell (Tonbridge Kent UK) - See all my reviews
This review is from: SQL Server 7 Essential Reference (The Essential Reference Series) (Paperback)
I believe that this book is to the DBA side of SQL Server what Inside SQL Server by Kalen Delaney is to the developers side, Awesome. I have two copies 1 for work and 1 for home. I often find myself jogging my memory with things in the book. Buy it you won't regret it.
Share your thoughts with other customers: Create your own review
|
|
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
