Truck Reviews Beauty Spring Reading Men's slip on sneakers nav_sap_plcc_ascpsc Unlimited Music. Always ad-free. Learn more. Electronics Gift Guide Fire TV Stick Grocery Handmade Personalized Jewelry Shop by look Book a house cleaner for 2 or more hours on Amazon MMM MMM MMM  Kids Edition Echo Dot Fire tablets: Designed for entertainment Kindle Paperwhite GNO Shop now Start your Baby Registry

VINE VOICEon June 6, 2004
Occasionally I have the need to leave my IBM/Lotus programming platform and interact with data stored in Microsoft SQL Server 2000. I even have it running on my laptop as a higher-end alternative to Access. I found that the book, Professional SQL Server 2000 Programming by Robert Vieira (Wrox) is a very good reference for manipulating data in that environment.
Vieira concentrates specifically on the programming aspects of SQL Server 2000 as opposed to teaching you how to administer the server. He does touch on an administration overview in chapter 30, but it's not something you'd read in order to pass an administration exam. Although the title does say "Professional", this does not mean you have to be a veteran SQL programmer to benefit from it. The earlier chapters cover the fundamentals of RDBMS technology, as well as how SQL is used in a SQL Server 2000 environment. The further you get into the book, the more you'll find subjects that are either more advanced or cover techniques you'll use in application development, such as how to build triggers and stored procedures. While you will learn all these skills within the SQL Server 2000 platform, the core technologies are transferable to just about any RDBMS. Time spent with this book will continue to pay off regardless of what database system you need to use at any given time.
While the content is technical, the writing style is conversational and approachable. It's actually quite easy to read the material and digest the concepts without trying to fight against the author's style. If you have need to work with SQL Server 2000 from a development standpoint, this is definitely a book to consider to guide you along the way.
7 people found this helpful
|0Comment|Report abuse
on December 26, 2001
This book is actually really good. I thought Database programming and design would be one of the most boring things I've ever studied in my life, but with this book it was actually quite interesting. They would do well to trim off about 200 pages, but otherwise it's good. I don't like the fact that the book holds your hand so much, but I guess it's understandable since the target audience is people who have never done any database programming. If you're looking for a good introductory book to dealing with SQL Server from a non API standpoint (as in dealing directly with the Enterprise Manager, etc), then you can't really go wrong with this book.
3 people found this helpful
|0Comment|Report abuse
on March 13, 2011
The author certainly knows his topic and writes as though he were standing in front of a class teaching off the top of his head, he's good and I got quite a bit from this book but...
You could cull 200 pages from this novel and still convey all the same information, it's very wordy - a bit too wordy for me. I found it a little slow. Once a concept is explained, the author tends to dwell on it for a few more pages discussing the finer details, some of which I thought were fairly obvious and really didn't need the depth of investigation they got and I frequently found myself skipping ahead.

Overall it is a good book but be prepared to spend some time working through it.
|0Comment|Report abuse
on April 12, 2003
I really enjoyed this book, but I feel that it should have been titled "Professional SQL Server 2000 DBA". This is not a book on Transact SQL programming, though there is some discussion of T-SQL in there. For T-SQL, a better reference would be Ken Henderson's "Guru" book.
Still, I felt that the book made me a better DBA, and that's important too. This book is a good introduction to lots of things, like DTS, that will in turn lead you to reading other, more advanced books. So if you are new to SQL Server, this is a good place to start.
3 people found this helpful
|0Comment|Report abuse
on June 2, 2016
Good reference
|0Comment|Report abuse
on June 23, 2002
If SQL Server 2000 were as good as this book there would be no competition from other RDBMS. There are a number of other reviews which lay out the thoroughness of this book. It is thorough. It is also well written and extremely smart. The book deserves five stars and for doing extremely well that which it sets out to do. It sets out to be a guide through the basics to the intermediate aspects of SQL Server 2000. If you are an expert DBA/SQL Programmer you will find this book remedial. However, if you are good in certain aspects but not as grounded in others this book will fill in any gaps and cement your previous knowledge. Enjoy this book. It will make you want to read each section not just use it as a lookup reference. It is worth the full read.
2 people found this helpful
|0Comment|Report abuse
on July 14, 2005
Robert Vieira knows how to write!

His coverage of SQL is thorough and his ability to explain why you would use a feature is wonderful. Amazing clarity and thoughtful concise examples. And, he includes the complete syntax of SQL statements before explaining them, something lacking in other guru books.

It is a great buy.

Thanks Robert for your work.
3 people found this helpful
|0Comment|Report abuse
on November 15, 2011
It provides lots of example and pinpoint the important knowledge you need to learn to write the SQL server programming. It makes your code more effective as well.
|0Comment|Report abuse
on April 23, 2003
As has already been stated this is not a reference book. I think the author has covered quite a bit in this book but I think the "Professional" in the title is a little misleading. It doesn't quite have the technical depth I would consider to be "Professional". It also has a writing style is more along the lines of a "Dummies Guide" then a "Professional" programming book. In the end it depends what you are looking for.
5 people found this helpful
|0Comment|Report abuse
on September 19, 2006
In general the book is ok. The author needed to make more research in some areas and not made use only of his own experience.

He does not mention about the issues with no following ANSI 92. The stored procedures and the trigger parts are really boring.

Sometimes the book is good but the author likes to move into areas he should not or he is not proficient enough. His comments on normalization and security are sometimes so strong that I tend to think that this guy is watching just one side of the coin.

3 people found this helpful
|0Comment|Report abuse

Need customer service? Click here