Professional SQL Server 2005 Programming (Programmer to Programmer) (Paperback)

by Robert Vieira (Author)
Key Phrases: management objects, data source view, advanced queries, Management Studio, Visual Studio, Cancel Figure (more...)

Editorial Reviews

Product Description
Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped feature set of the latest release of Microsoft SQL Server. The book begins with a concise overview of the new features of SQL Server that is of interest to experienced developers. This is especially important given the substantial changes to SQL Server with this release. From there, the book quickly moves on to the meat of the title. Beginning-level material has been removed to provide more room for covering new features and more extensive code examples.

About the Author
Robert Vieira is one of the leading authorities on Microsoft SQL Server and author of the bestselling title from Wrox Press, Professional SQL Server 2000 Programming, with nearly 40,000 copies in print.  Vieira is currently a Software Architect for NetIQ Corporation in Portland, OR, where he performs design work and coaches other developers. He speaks frequently at both public and private conferences nationally, and is perhaps best known for his light-hearted approach to teaching and writing.

Product Details

• Paperback: 912 pages
• Publisher: Wrox; illustrated edition edition (December 1, 2006)
• Language: English
• ISBN-10: 0764584340
• ISBN-13: 978-0764584343
• Product Dimensions: 9.2 x 7.4 x 2 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #22,307 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #43 in	Books > Computers & Internet > Networking > Data in the Enterprise > Client-Server Systems
  #55 in	Books > Computers & Internet > Databases > Database Management Systems
  #66 in	Books > Computers & Internet > Databases > SQL

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars Good choice for newbies or as a reference, June 10, 2007

By	D. Wyatt (Virginia, USA) - See all my reviews (REAL NAME)

I would highly recommend this book for both someone new to database development and for those who are migrating from earlier versions of SQL Server.

Maybe I'm just a groupie for this author, since I've purchased this same book for SQL Server 7, 2000, and now 2005, but I continue to find his approach easily readable and full of practical advice that is immediately applicable to projects.

Even as an experienced programmer with SQL Server, I'm glad I bought this book, rather than just a "what's new in 2005 version." After a quick scan of the table of contents, I easily found what was new in 2005 and focused on the parts that were relevant to our applications. It's also a great resource to have on the shelf. It has come in handy when our team runs into not-so-common problems. We've been able to crack it open and find exactly what we need.

9 of 12 people found the following review helpful:

3.0 out of 5 stars What is the "2005" doing in the title?, January 4, 2007

By	Ivan Pepelnjak (Slovenia) - See all my reviews (REAL NAME)

A bit of the background: I bought this book after reading a number of other excellent books covering the same subject matter, but not the features of the SQL Server 2005 release. My (unfounded) expectations were that this book would focus on what's new in 2005 release.

Dead wrong ... some of the exciting new features like XML indices are skipped (or lost in circular cross-references), the features new to SQL server 2005 are not clearly marked, so it's not obvious on what to focus, and the technical material in the book is heavily interspersed with page-long author's deliberations on why he put a certain topic in a certain place (frankly, I don't care about his book structuring decisions as long as the content is there and presented in a useful fashion).

If you're not focused on the SQL Server 2005 release, you might be better off buying more time-tested books from other authors.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Awesome title from a surprising source., October 15, 2007

By	Jesse Lee Curry (Tampa, FL USA!) - See all my reviews (REAL NAME)

I've never been a fan of the Wrox product line, but purchased this book on the recommendation of a friend.
I couldn't be happier. The author is one of the most knowledgeable, and he writes in an accessible style.
I've heard some gripes about how he discusses the organization of his book a little too much, but the reasons for these passages are to reinforce the importance of the concepts being covered in relation to other concepts.
I'd recommend this book to beginners who are fast learners, or to old hands that want to pick up a new trick or two.