SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has also increased its popularityanyone, not just database administrators, can use a SQL Server database.
This book recognizes that aspiring DBAs need more than just a basic knowledge of the available features in order to be considered 'a safe pair of hands' for the database and the mission-critical data that is stored in it. Aspiring DBAs can benefit from the direction and advice of an expert mentor who not only understands the features available and how they should be used, but also knows what it takes to be a good and effective DBA. In essence, this book is that 'mentor,' which is what sets it apart from the other books on the market that only present feature overviews.
Database novices will learn the core job and roles involved in administering a SQL Server database. You'll follow the life cycle of the database from installation, design, and modeling; through to development, tuning, and securing; and on to growth and migration. This comprehensive guide provides practical advice, answers typical questions that you'll encounter from managers and developers, and offers practical steps to overcome issues with which new DBAs traditionally struggle.
At every stage of the life cycle, this book supplies a range of tried-and-tested practices and techniques that will help you to establish and maintain a healthy database system.
Customer Reviews
Average Rating:
Rating: - A review
Warning! This might be a wonderful book except for the fact that the publishers decided to use much smaller print than is normally used for computer manuals. If staring at small print is not a problem for you then buy this book, otherwise you might be better off buying another book with normal sized print.
Rating: - A very good book for SQL server self-learner
Excellent. It is a good reference for your SQL Server examination or self-learning. The examples are listed in details. If you follow them step by step, you can 100% learn the skills for your SQL server daily maintenance. I am not a professional in SQL Server, but after reading this book, I have much stronger confidence to use it.
IF THE AUTHOR CAN WRITE THE SAME KINDS/STYLE OF MATERIAL IN ORACLE FIELD, I THINK HE/SHE WILL FURTHER HELP A LOT OF LEARNERS OR USERS.
Rating: - Not enough T-SQL
Overall, I would say this book is well put together and is an excellent resource. I personally was hoping for a bit more meat on the programming of the T-SQL commands and methods, but the lack of that information is not the fault of the author, merely my selection of the wrong book.
I picked up valuable knowledge about SQL Server that will serve me well, but DBAs in my company do a heck of a lot with T-SQL that apparently is not as common in other places.
Rating: - Extensive coverage of what every SQL DBA should know
Packed with practical, real-world information for anyone involved with SQL Server Administration, "Beginning SQL Server 2000 DBA: From Novice to Professional" is one of the most complete administration books available. It is not without its problems but they are generally pretty minor and in fact somewhat humorous at times. For example, page 84 has a section titled "Upgrading to SQL Server 6.5" and page 90 a section titled "Upgrading to Earlier Versions of SQL Server". Obviously you don't upgrade ... Read More
- A review
- A very good book for SQL server self-learner
