SQL Server 2000 Administration (Book/CD-ROM)
||Author: Mark A. Linsenbardt, M. Shane Stigler, Shane Stigler, Mark Linsebardt|
List Price: $44.99
Our Price: Click to see the latest and low price
Publisher: McGraw-Hill Osborne Media (18 October, 2000)
Sales Rank: 223,630
Average Customer Rating: 2.67 out of 5
Customer ReviewsRating: 2 out of 5
This ain't the book.
Having recently been "elevated" to the rank of DBA in my company, I was looking for a good reference book. I already had a thorough background in relational databases, and I was not looking for a study guide to any MS licensing exam; I just wanted a book to explain the working details of SQL Server database administration. (For example: How can you tell if a trigger is in enabled/disabled status?) Well, this ain't the book.
This book, contrary to the Norwegian reviewer, is a very basic overview of DB administration. Its approach with each topic is to start with an explanation of the obvious, and then to continue with walk-thrus of Wizards available in Enterprise Manager. There is no depth and no breadth; in other words there is little to no discussion of wizard options not selected in the walk-thru, and only cursory explanation of the options that *were* selected.
Here is one example of the kind of fluff that comprises the bulk of this 600-page book, from the chapter on security: "The very first thing to understand, of course, is why we want to prevent unauthorized users from accessing data on our SQL Servers. Data, as you know, comes in a very wide variety..." This drivel continues in the same vein for a full page! Excuse me but if you don't already know this, you have no future in IT, much less being a DBA.
Finally, the book is bound in an ugly green "stay-closed" binding that makes this book a physical struggle to read, and impossible to use on your desk next to your PC.
Rating: 4 out of 5
a great book!
As the authors stated in chapter 1, the book is written with experienced network administrators in mind. They try to explain the theory behind SQL and do so by bringing in-depth and well-founded information followed with tips and tricks from hands on experience. Accordingly this book is not suited for people who are completely new to this topic.
The book is divided into 13 chapters,
The first chapter, installation, explains the process of installing the SQL server in a fashioned manner.
Chapter tow, system architecture of SQL, give in depth knowledge of net-library, command parser, storage engine, lock manager, memory, cache and checkpoints, disk i/o, the default databases objects and system tables.
Chapter three, security, includes server logins, database users, server and database roles, database, statement and object permission, security using views and sp. The other 10 chapters are devides into the following capters;
Data structure, Distribution and transferring of data, Backup solutions, Restore, Monitoring and optimization, Automating SQL, Replication, Troubleshooting and understanding of TSQL.
I have used both Sybex and MS press book for my SQL certs. They provide a lot of lab simulations but they lack the in-depth knowledge needed to pass the exam.
There are some conflicting use of the two words SQL Server 7 and SQL 2000. I suppose the bad typo can bring some confusion while reading the book, but it is so obvious and are easy to spot. The typo mistakes forced me to give the book only 4 stars, but I will highly recommend this book to anyone who is dipping into the mcdba track and other SQL interested people out there.
This book along with Professional SQL Server 2000 Programming
by rob vieira, will make your life a lot easyer and provide you all the knowlege you can hadle for months to come.
Rating: 2 out of 5
Is this actually 2000?
I'm new to administration and I've noticed several things that are wrong. This book seems like just version 7 with a new cover. All they talk about is SQL Server 7. It will say things like "In SQL Server 7, however, these stored procedures have been removed...". That's all well and good but I bought a book on SQL Server 2000 and in 2000, they are there and I've been using them. I just wonder if they were trying to use them wrong and so they couldn't find them. I'm not sure how many of the mistakes are just changes between the versions and how many are wrong in both books. I recommend looking somewhere else.
· SQL Server 2000: The Complete Reference
· Essential SQL Server(TM) 2000: An Administration Handbook
· SQL Server 2000 Programming by Example
· SQL Server 2000 Web Application Developer's Guide