- Paperback: 608 pages
- Publisher: McGraw-Hill Inc.,US; 2nd Revised edition edition (1 Nov 2000)
- Language English
- ISBN-10: 0072126183
- ISBN-13: 978-0072126181
- Product Dimensions: 23.1 x 18.8 x 3.7 cm
- Amazon Bestsellers Rank: 2,488,745 in Books (See Top 100 in Books)
- See Complete Table of Contents
| ||||||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
This title covers general and unattended/remote installations and provides real-world information on system architectures, files, and advanced security measures. It explains efficient backup techniques, data manipulation, and replication procedures and offers day-to-day troubleshooting techniques and optimization methods. It also contains a CD-ROM with 120-day trial version of SQL Server 2000.
From the Back Cover
Get cutting-edge techniques for managing SQL Server 2000.
Provide a scalable, replicated, and reliable foundation for your database-driven e-commerce applications. Packed with up-to-date information, real-world examples, and hands-on solutions, SQL Server 2000 Administration covers installation, configuration, system architecture, security, file management, data manipulation and replication, automation, and restoration. Plus, the "From the Field" sections highlight little-known tips and tricks from the authors' vast SQL Server management experience. This is an indispensable resource for all SQL Server DBAs.
-Set up, configure, and maintain SQL Server 2000
-Perform unattended installations from inside the Windows 2000 directory model
-Manage user databases, file storage, and data queries using the Microsoft Management Console (MMC)
-Handle database security using authentication, Roles, permissions management, stored procedures, and views
-Transfer and transform data using DTS, field mapping, and parsing
-Back up and restore data with minimal impact on users
-Master Analysis Services, data replication, warehousing, and SQL server automation
-Institute and govern data replication
-Prevent downtime, crashes, and data losses
Inside This Book
(Learn More)
First Sentence
This book is written with the experienced network administrator in mind. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
This book is written with the experienced network administrator in mind. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
4 reviews
12 of 12 people found the following review helpful
This ain't the book.
22 May 2003
Format:Paperback|Amazon Verified Purchase
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.
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.
3 of 4 people found the following review helpful
Is this actually 2000?
19 Mar 2002
Format:Paperback
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.
0 of 1 people found the following review helpful
a great book!
28 Mar 2002
Format:Paperback
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.
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.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
