|Amazon Price||New from||Used from|
When it comes to selecting computer books, deciding which book to buy can sometimes be even more confusing than the software it is written about. However, if you are looking for a book to instruct you on the use of SQL Server 2000, choosing this book, Professional SQL Server 2000 Programming, could well simplify your selection process.
In addition to providing a thorough treatment of SQL Server 2000 development, Robert Vieira's extensive reference also devotes quite a lot of space to covering SQL in general and issues relating to database design. Included is a complete introduction to Transact-SQL and an excellent chapter on normalisation that will go a long way for many to de-mystify the mystery of an over-referenced but much misunderstood database design concept. There is also in-depth information on the new features of SQL Server 2000, including indexed views, user-defined functions and support of XML. Sadly, there is no accompanying CD, but source code for the book can be downloaded from the Wrox Web site.
While you don't need any knowledge of SQL Server or database administration to make the most of this book, you will need a reasonable understanding of programming fundamentals. That said, the author's down-to-earth style makes it possible for anyone with some programming background and the will to learn, to really get to grips with SQL Server 2000 development. If you are looking for a book that combines rich content with clear explanation, then look no further than this excellent title. --Peter Lunn --This text refers to an out of print or unavailable edition of this title.
This book is a revised follow on from Professional SQL Server 7.0 Programming, to address the new features of this recent release. With a general understanding of programming principles, (eg familiarity with VB, C++, VB Script) Professional SQL Server 2000 Programming provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server. From basic database design concepts a tutorial explains more advanced topics and specific areas including Stored Procedures and Advanced Queries. Advanced topics - performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. The new XML features are explored to provide an understanding of this important area. With over 1,500 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so you can get the most out of SQL Server 2000. --This text refers to an out of print or unavailable edition of this title.See all Product Description
I've read the MSPress Certification book, BOL (SQL server Books Online), and neither come close to the under standing this book gives. Read morePublished on July 14 2004
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. Read morePublished on July 9 2004 by ravi lobo
I agree with the reviewer Wendt, who complained that this book is too much like its earlier edition. Read morePublished on May 17 2004 by Alois van Klinken
This book covers everything a professional programmer using SQL server 2000 needs to know in just the right depth and breadth of topics. Can't beat it. Read morePublished on May 10 2004
This book has some good info, but the book itself has many flaws.
First, much of the info is copied verbatim from the 7.0 book. Read more
This book covers the client side of Sql Server application development extremely well. It covers nearly all the client side technolgies and provides real-world examples for putting... Read morePublished on May 1 2004 by Lyle Edwards
This is THE book to have on SQL Server 2000. Robert Vieira unquestionably knows his stuff and covers every aspect of SQL Server completely and thoroughly.Published on Feb. 12 2004 by Terry Smith
Like another review, I find the 'Professional' in the title inappropriate. I'm an experienced SQL developer and I quickly discovered that there was never anything in here that I... Read morePublished on Jan. 7 2004