Professional SQL Server 2000 Programming

Rating:
Summary: Best Book By Far....
Review: I've read the MSPress Certification book, BOL (SQL server Books Online), and neither come close to the under standing this book gives. Things I've read 5 times over in the other aforemenioned book and still didn't get an understanding, I read once in this book and understood right off.

I wished I had this book before taking the admin exam (I passed, but caught heck doing it).

[e-mail]

Rating:
Summary: Best Book By Far....
Review: This is a very good book for sql server programmers. Not like the other books where you find lots of cut and paste from BOL. I feel every sql server programmer should reed this book. Lots of insight and very good information on sql server. Only a person who loves sql server can write a book like this. A must read!!

Rating:
Summary: Complete and readable guide to programming SQL Server...
Review: 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.