Order from a Major Online Bookstore
Ultimate Book Price Comparison Engine
Save Your Time And Money
| AnyBook4Less.com | Order from a Major Online Bookstore |
|
| Home | Store List | FAQ | Contact Us | | ||
| Ultimate Book Price Comparison Engine Save Your Time And Money |
||
 |
Title: Microsoft SQL Server 2000 for Dummies by Anthony T. Mann ISBN: 0-7645-0775-3 Publisher: For Dummies Pub. Date: 15 January, 2001 Format: Paperback Volumes: 1 List Price(USD): $29.99 |
Average Customer Rating: 2.5 (4 reviews)
Rating: 2
Summary: Muzzled author produces mediocre book
Comment: The only perceived value of this book could be the enclosed CD, a 120 day Evaluation version of the SQL 2K Server, Enterprise Edition, a couple thousand retail, which will need a updater to SP3a on the MS support website. This will bring the app to the latest version, since "Yukon" is currently in beta, will not be released until Late 04. You probably can get an Eval CD directly from MS for small shipping, or free at a trade show, such as Comdex, at a local MS Sales office, or SQL Server Users Group (UG). No additional files are on the CD. You can install this on Server 2K, Server 2K3, Server NT4SP6, and Win98SE; but the installation chapter is a download from the publisher's website to save book space!
The heart of the book, Part II DataBase (DB) Design, has 4 chapters over 112 pages for describing relational DB, creating a Customer DB, indexing, triggers, programming, and procedures. He devotes 2+ pages to Locking. Then in Part III Interface Design, he has 3 chapters covering 80 pages for describing SQL, Query, and Import/Export. Slim pickings for a budding DBA, many tables; maybe one can use this book as an abridged reference.
Then there's more, Part IV Enterprise Issues, Chap 11 goes over making a DB backup / restore that I agree needs to be covered. And Chap 12 covering web serving your DB is OK, but I'd hold the line on Chap 13 where he covers Distributed Queries over multiple servers, to exploit the Enterprise version capability. Like most budding DBAs are going to have multiple, remote, networked DB servers at his disposal? Nonetheless, this chapter seems to be the author's pride and joy. I'd highly recommend the author use these 12 precious pages to beef up what he has already covered.
But most superfilous is his Appendix A, where he expends over 18 precious pages for Wizard flowcharts. What a waste! The Security chapter is a download from the publisher's website. The author is at tmann at vbasic dot com .
His book's most significant failing is not showing how to display or print out a result or report of a DB query. Perhaps the author hasn't found out that reports are the life-blood of business. He gives a half page mention of the Crystal Report Writer in the last chapter (p338), but neither integrates reports in his book, nor indicates that an older v4.5 (96) version is bundled with the SQL Server 2K. SQL Server Help for reports is useless as Crystal has its own separate Help. As demoed in our local UG, MS has just released its own Reporting Services module (free download) to supplant the highly regarded Crystal Reports.
Rating: 3
Summary: Not bad, but could be better
Comment: 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.
Rating: 2
Summary: At least it includes an eval copy of SQL Server...
Comment: 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.
 |
Title: MCSE SQL Server 2000 Administration for Dummies (with CD-ROM, covers test #70-228) by Rozanne Whalen, Dan Whalen ISBN: 0764504800 Publisher: For Dummies Pub. Date: 15 April, 2001 List Price(USD): $34.99 |
 |
Title: SQL for Dummies by Allen G. Taylor ISBN: 0764540750 Publisher: For Dummies Pub. Date: 28 July, 2003 List Price(USD): $24.99 |
 |
Title: Sams Teach Yourself SQL in 10 Minutes (2nd Edition) by Ben Forta ISBN: 0672321289 Publisher: Sams Pub. Date: 26 April, 2001 List Price(USD): $14.99 |
 |
Title: Crystal Reports 9 for Dummies by Allen G. Taylor ISBN: 0764516418 Publisher: For Dummies Pub. Date: 02 September, 2002 List Price(USD): $24.99 |
 |
Title: ASP.NET for Dummies by Bill Hatfield ISBN: 0764508660 Publisher: For Dummies Pub. Date: 15 November, 2001 List Price(USD): $24.99 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments
