Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

A Developer's Guide to SQL Server 2005 1st Edition

4.3 out of 5 stars 9 customer reviews
ISBN-13: 978-0321382184
ISBN-10: 0321382188
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$0.36 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$64.99 On clicking this link, a new layer will be open
More Buying Choices
20 New from $7.34 48 Used from $0.36
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Consumer Reports
Access expert, unbiased product reviews from web or app. Learn more
$64.99 FREE Shipping. Only 1 left in stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Editorial Reviews

From the Back Cover

"I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or XML background and suddenly had an urgent need to learn it. SQL Server 2005 is too big of a release to learn from the books online. Fortunately, now there is a book for developers who need to go from SQL Server 2000 to SQL Server 2005 and to do it as painlessly as possible. Basically, it's one-stop shopping for serious developers who have to get up to speed quickly. I'll keep this one on my desk--not on my bookshelf. Well done, Bob and Dan!"

--Dr. Tom Moreau

SQL Server MVP and Monthly Columnist

SQL Server Professional, Brockman Moreau Consulting Inc.

 

"A SQL book truly for developers, from two authorities on the subject. I'll be turning to this book first when I need to understand a component of SQL Server 2005."

--Matt Milner

Instructor

Pluralsight

 

"An excellent book for those of us who need to get up to speed on what's new in SQL Server 2005. The authors made sure this book includes the final information for the release version of the product. Most other books out now are based on beta versions. It covers key areas from XML and SQLCLR to Notification Services. Although the wide variety of information is great, my favorite part was the advice given on when to use what, and how performance is affected."

--Laura Blood

Senior Software Developer

Blue Note Computing, Inc.

 

"SQL Server 2005 is a massive release with a large number of new features. Many of these features were designed to make SQL Server a great application development platform. This book provides comprehensive information about the SQL Server features of most interest to application developers. The lucid text and wealth of examples will give a developer a clear understanding of how to use SQL Server 2005 to a whole new class of database applications. It should be on every SQL Server developer's bookshelf."

--Roger Wolter

Solutions Architect

Microsoft Corporation

 

"While there will be a lot of good books on SQL Server 2005 development, when people refer to the 'bible,' they'll be talking about this book."

--Dr. Greg Low

Senior Consultant

Readify Pty Ltd

 

"SQL Server 2005 is loaded with new features and getting a good overview is essential to understand how you can benefit from SQL Server 2005's features as a developer. Bob and Dan's book goes beyond enumerating the new SQL Server 2005 features, and will provide you with lots of good examples. They did a good job striking a balance between overview and substance."

--Michiel Wories

Senior Program Manager, SQL Server

Microsoft Corporation

 

Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now, two SQL Server insiders deliver the definitive hands-on guide--accurate, comprehensive, and packed with examples. A Developer's Guide to SQL Server 2005 starts where Microsoft's documentation, white papers, and Web articles leave off, showing developers how to take full advantage of SQL Server 2005's key innovations. It draws on exceptional cooperation from Microsoft's SQL Server developers and the authors' extensive access to SQL Server 2005 since its earliest alpha releases.

 

You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL:1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product.

 

Key coverage includes

  • Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance
  • Writing procedures, functions, triggers, and types in .NET languages
  • Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax
  • Effectively using the XML data type and XML queries
  • Implementing native SQL Server 2005 Web Services
  • Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
  • Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS)
  • Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications

About the Author

Bob Beauchemin is a database-centric application practitioner and architect, DBA, instructor, course author, and writer. He's Director of Developer Skills at SQLskills (www.sqskills.com), and teaches his SQL Server 2005 courses around the world. Bob has written extensively on SQL Server and other databases, database security, ADO.NET, and OLE DB.

 

Dan Sullivan runs his own consulting company, does training for Pluralsight (www.pluralsight.com), and has worked with SQL Server since it was first distributed by Microsoft and ran on OS/2. Dan speaks and writes widely on SQL Server.

 

NO_CONTENT_IN_FEATURE

The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

Product Details

  • Paperback: 1088 pages
  • Publisher: Addison-Wesley Professional; 1 edition (May 8, 2006)
  • Language: English
  • ISBN-10: 0321382188
  • ISBN-13: 978-0321382184
  • Product Dimensions: 7 x 1.9 x 9.2 inches
  • Shipping Weight: 3.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #3,597,358 in Books (See Top 100 in Books)

Customer Reviews

5 star
67%
4 star
0%
3 star
33%
2 star
0%
1 star
0%
See all 9 customer reviews
Share your thoughts with other customers

Top Customer Reviews

By Craig Bolon on August 18, 2006
Format: Paperback
I feel cheated by the publishers of this book, because it was described as a "Bible" for SQL Server 2005: a "definitive hands-on guide" with "virtually every key concept" explained. It does not fit such a description, unless one's idea of a "Bible" can leave out Genesis, Exodus and the rest of the Old Testament.

Beauchemin's and Sullivan's book is a competent rendition of new features in SQL Server 2005, but in order to use it one will have to be thoroughly familiar with previous editions of the database product. Beauchemin and Sullivan fail to provide a first-principles description of SQL Server 2005 capabilities and syntax. Anyone hoping to use this book as a reference will probably be as disappointed in it as I have been.
Comment 13 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Covers writing T-SQL and C# code to be executed/hosted within SQL Server. The authors point out many of the new features of SQL Server 2005.

I found the writing style somewhat disjointed. I just couldn't read it from cover to cover. It reads like a course syllabus. It doesn't really fall into the category of a reference either.

Make sure you skim through this book at your local bookstore before you commit to purchasing it.
1 Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Bob's book is written for the passionate Microsoft developer. DBA's and IT Pro's will find this book useful to have on the shelf, as there are number of features that touch the life of the Admin. Additionally, AW press has released another book, SQL Server 2005 Distilled, if you are looking for something less deep, I would try that book too.

HTH.

Dusty...
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
As other reviewers have stated, there is good coverage of topics overall and in new topics in particular. The sentence structure and overall material arrangement are, however, suboptimal. I have used this text as a survey of new features and to get a view of the SQL Server development landscape. I would not recommend any heavy lifting with this text. I would recommend the Inside Series for that.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This is a very good book for Database Developers. It covers most topics thoroughly. Some topics like SQLCLR and XQuery are covered too much in detail for my taste, but who knows one day I might need it! (there is a 17 page WSDL in chapter 12 .. I don't know who decided to put this in :-) Initially the minutiae kind of put me off, but over time I have started to like this book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

A Developer's Guide to SQL Server 2005
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: A Developer's Guide to SQL Server 2005