Microsoft SQL Server 2000 for Dummies [Paperback]

Anthony T. Mann (Author)

Book Description

ISBN-10: 0764507753 | ISBN-13: 978-0764507755 | Publication Date: January 29, 2001

Network administrators challenged with the task of building and deploying a network database can look to Microsoft SQL Server 2000 For Dummies for simple answers about a complex tool. Microsoft bills its SQL server as the best and fastest network database for NT-based networks and the Internet. Microsoft SQL Server 2000 For Dummies explores the processes and tasks involved with installing, configuring, and using the latest release of Microsoft SQL Server. This book explores designing SQL databases, scaling your server to handle the tasks you need, creating a database system to handle your business, and SQL's tight integration with other Microsoft networking and Internet management products including BackOffice and the rest of the Windows DNA 2000 suite. This book includes a CD that contains such software as IE 5.5, Vision Builder, Vision JADE and sp_Assist.

Editorial Reviews

Amazon.com Review

Microsoft SQL Server 2000 has become standard equipment in lots of organizations, largely owing to its relatively friendly user interface on top of its solid infrastructure. That user interface, however, can intimidate users who are new to the environment and lack the experience to interpret what they see. Microsoft SQL Server 2000 for Dummies decodes this top-of-the-line relational database management system (RDBMS) for the benefit of such novices, as well as for people coming to SQL Server 2000 from one of its competitors. Anthony Mann does a fine job of explaining not only administrative matters, but also issues of database design, Structured Query Language (SQL), and integration of SQL Server databases into larger information systems.

The instructional style in this book varies depending on the subject at hand. When explaining subjects that are mostly conceptual in nature, such as relational database structure, Mann relies mainly on text and bulleted lists (and perhaps not enough on diagrams, which can really clarify these topics). When covering areas that have more to do with the specifics of SQL Server 2000--running Data Transformation Services (DTS) imports and exports, for instance--he employs steps (with options and alternate paths explained) and screen shots of the user interface. --David Wall

Topics covered: How to set up and maintain databases under SQL Server 2000, with some instruction in relational database design and Structured Query Language (SQL) thrown in. Databases, tables, keys, foreign keys, basic Transact-SQL, stored procedures, triggers, and administrative subjects like backup, restoration, and distributed databases are all covered.

From the Back Cover

Your fun and easy guide to building scalable databases

Get the lowdown on distributed queries and programming

Create a robust, Internet-ready database system--starting today!
With its new tools, wizards, services, and enhancements, the latest version of SQL Server is better -- and more complicated -- than ever. Relax! With SQL Server guru Anthony T. Mann at your side, you'll quickly pick up the know-how you need to build, deploy, and manage a scalable database system for your business or e-business.

Discover how to:
* Use SQL Server 2000 tools
* Design a multi-tier database
* Create tables and other database objects
* Work with SQL and the Query Analyzer
* Harness the DTS Import/Export Wizard
* Back up your data
all this on the bonus CD-ROM
Microsoft SQL Server 2000 120-day Enterprise Evaluation Edition

Get Smart! www.dummies.com
* Register to win cool prizes
* Browse exclusive articles and excerpts
* Get a free Dummies Daily e-mail newsletter
* Chat with authors and preview other books
* Talk to us, ask questions, get answers

See all Editorial Reviews

Product Details

• Paperback: 408 pages
• Publisher: For Dummies (January 29, 2001)
• Language: English
• ISBN-10: 0764507753
• ISBN-13: 978-0764507755
• Product Dimensions: 9.1 x 7.4 x 1 inches
• Shipping Weight: 1.4 pounds
• Average Customer Review: 2.5 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #1,442,506 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

17 of 19 people found the following review helpful:

3.0 out of 5 stars Not much smarter now, June 27, 2001

By 

Gary Sprandel (Frankfort, Kentucky) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft SQL Server 2000 for Dummies (Paperback)

Although the book covers the major features it offers little over the online help. What is missing is the overall context or a complete example that might help understanding of how to put everything together into a working application. When it presents triggers and stored procedures the examples are so basic as to not explore the potential power. The chapter on relational database design was particularly lacking in ideas or references. Some of the more powerful features such as metadata and analysis services are barely mentioned. The book did introduce the major administrative functions well. If you do buy the book, do go the authors web site described in the book, to get the "bonus" chapters on installation and security, which should also help a new administrator.

4 of 4 people found the following review helpful:

2.0 out of 5 stars At least it includes an eval copy of SQL Server..., July 26, 2003

By 

Adam Harper (Exton, PA USA) - See all my reviews

This review is from: Microsoft SQL Server 2000 for Dummies (Paperback)

Let's just say this is not a very good dummies book. There are very very few "real world" examples of the topics presented. The technical accuracy is pretty decent, but this book will not enlighten any beginners to the world of SQL Server. Advanced topics are rarely explained in layman terms and the depth of coverage is, shall we say, not very deep at all! Stick to the SQL Server Online Books (which this book just seems to re-hash, albeit in much less detail) and you'll learn alot more about SQL Server.

5 of 6 people found the following review helpful:

3.0 out of 5 stars Not bad, but could be better, July 30, 2003

By 

"webgeekinc" - See all my reviews

This review is from: Microsoft SQL Server 2000 for Dummies (Paperback)

This is a good book if you are a "rank beginner" and you don't need to do anything complex with SQL. It's missing a lot of information that could be considered more advanced.

I bought it to help me with my SQL queries in Active Server Pages and I just haven't found it to be that useful. One of my employees, who knows nothing about SQL has found it to be very useful, however.