Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

Quantity:

More Buying Choices

36 used & new from $6.87

Have one to sell? Sell yours here

Tell the Publisher! I�d like to read this book on Kindle Don�t have a Kindle? Get yours here.

Programming SQL Server 2005 (Paperback)

by Bill Hamilton (Author)
Key Phrases: server management objects, database engine, web services, Notification Services, Server Agent, Server Mobile (more...)

4.1 out of 5 stars See all reviews (13 customer reviews)

List Price:	$54.99
Price:	$34.64 & this item ships for FREE with Super Saver Shipping. Details
You Save:	$20.35 (37%)

In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Monday, July 13? Choose One-Day Shipping at checkout. Details

19 new from $34.64 17 used from $6.87

Like this book? Find similar titles from O'Reilly and Partners in our O'Reilly Bookstore.

› See more product promotions

Frequently Bought Together

Customers Who Bought This Item Also Bought

Learning SQL on SQL Server 2005

by Sikha Bagui

3.9 out of 5 stars (12) $29.69

Transact-SQL Cookbook

by Ales Spetic

3.4 out of 5 stars (14) $31.35

Programming ASP.NET AJAX: Build rich, Web 2.0-style UI with ASP.NET AJAX

by Christian Wenz

5.0 out of 5 stars (4) $29.19

Performance Tuning and Optimizing ASP.NET Applications

by Jeffrey Hasan

4.4 out of 5 stars (10) $40.49

Programming ASP.NET 3.5

by Jesse Liberty

4.7 out of 5 stars (3) $37.79

› Explore similar items

Editorial Reviews

Product Description
SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on.

"Programming SQL Server 2005" from O'Reilly provides a practical look at this updated version of Microsoft's premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005.

"Programming SQL Server 2005" can help you: Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems

Because the goal of "Programming SQL Server 2005" is to introduce all facets of Programming SQL Server 2005, it's beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or asbackground and primer to specific concepts.

Any IT professional who wants to learn about SQL Server 2005's comprehensive feature set, interoperability with existing systems, and automation of routine tasks will find the answers in this authoritative guide.

About the Author
Bill Hamilton is the author of the highly praised ADO.NET Cookbook. He is an enterprise architect specializing in designing, developing and implementing enterprise applications using .NET and J2EE technologies. Over the last fifteen years, Bill has provided consulting services for B2B, B2C, B2E, enterprise application integration, portal initiatives, and custom application development for financial services, retail, professional services, and manufacturing clients. Bill is also the author of O'Reilly's NUnit Pocket Reference, the co-author of ADO.NET in a Nutshell, and also writes for Microsoft Developer Network.

Product Details

Paperback: 600 pages
Publisher: O'Reilly Media, Inc. (February 21, 2006)
Language: English
ISBN-10: 0596004796
ISBN-13: 978-0596004798
Product Dimensions: 9 x 7 x 1.4 inches
Shipping Weight: 1.8 pounds (View shipping rates and policies)

Average Customer Review: 4.1 out of 5 stars See all reviews (13 customer reviews)

Amazon.com Sales Rank: #268,462 in Books (See Bestsellers in Books)

Would you like to update product info or give feedback on images?

Inside This Book (learn more)

Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
server management objects, database engine, web services, language enhancements, production technician, replication server, utility classes, sales amount, integrating reports, schema collections, registered servers, report designer, table designer, distributor properties, filter rows, foreach loop, custom button, linked server, xml data type columns, xml data type variable, triggers scoped, nonhosted event providers, xml data type methods, exception message box, business logic handlers

Key Phrases - Capitalized Phrases (CAPs): (learn more)
Notification Services, Server Agent, Server Mobile, Class Description, Server Management Studio, Service Broker, Object Explorer, Visual Studio, Instance Classes, Adventure Works, Books Online, Native Client, Server Integration Services, Analysis Services, Common Language Runtime, Sample Reports, Integrated Security, Server Database Mail, Server Profiler, Server Reporting Services, Client-Side Programming, Server Configuration Manager, Cancel Figure, Property Description, Data Manipulation Language

What Do Customers Ultimately Buy After Viewing This Item?

	61% buy the item featured on this page: Programming SQL Server 2005 4.1 out of 5 stars (13) $34.64
	13% buy Beginning SQL Server 2005 Programming (Programmer to Programmer) 4.2 out of 5 stars (24) $26.39
	11% buy Microsoft SQL Server 2005 Unleashed 4.4 out of 5 stars (20) $40.49
	10% buy Pro T-SQL 2005 Programmer's Guide (Expert's Voice) 4.8 out of 5 stars (6) $31.49

Explore similar items

Tags Customers Associate with This Product

(What's this?)

Click on a tag to find related items, discussions, and people.

sql server 2005(4)

databases(3)

sql server 2005 programming(3)

database management systems(1)

dont waste your money(1)

lame(1)

poorly written(1)

slow(1)

sql(1)

t-sql(1)

See all 11 tags...

Help others find this product — tag it for Amazon search

No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

13 Reviews

5 star:		(8)
4 star:		(2)
3 star:		(0)
2 star:		(2)
1 star:		(1)

Average Customer Review

4.1 out of 5 stars (13 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

5.0 out of 5 stars Very Informative and Easy to Read, May 5, 2006

By	Jerry Dixon - See all my reviews (REAL NAME)

This book is an easy-to-read tutorial on many of the new features of SQL Server 2005. It covers the expected topics, such as T-SQL Enhancements, HTTP Endpoints (Web Services), CLR Integration, and the XML data type. I was pleased to discover, however, that it also does a good job of explaining the often left-out features such as SQL Server Management Objects (SMO), SQL Server Integration Services (SSIS), and Analysis Services. (There are three chapters on SMO alone!) There is even a chapter on using SMO to program the SQL Server Agent service. That's an extra that I haven't seen before.

One of the things that I really liked about this book was the writing style. Reading it didn't feel like a chore. I wound up reading a bit of it each night after work, in order to relax. This is fairly unusual for me, as I typically get more than enough exposure to SQL during the day.

I was quite pleased with this book. I am a Microsoft Certified Trainer, and have been teaching classes on SQL Server 2005 for over a year. Therefore, I've seen numerous books and classes on SQL 2005. In my mind, this book stands out from the pack.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

5 of 5 people found the following review helpful:

5.0 out of 5 stars Must-have book!, April 15, 2006

By	M. Strader - See all my reviews (REAL NAME)

This book provides a clear, concise walkthrough about programming all aspects of SQL Server 2005. Numerous code samples are included that can be downloaded from the O'Reilly web site. The book contains excellent coverage of programming CLR routines, XML support, native Web services support, and SQL Server Management Objects (SMO) (which replaces DMO). I also found the sections about topics such as Notification Services, replication, Reporting Services, and Integration Services helpful. These topics are new to me and I now both understand them and have been able to program solutions.

As a previous reviewer correctly mentioned, this book only covers new T-SQL features. I actually prefer this since I already know T-SQL (and there are already a lot of good T-SQL books available). The coverage of new T-SQL features is complete and the examples are good.

This book includes an appendix that explains the new features of ADO.NET 2.0. The writing and examples are clear and helped me understand the changes and enhancements. It's great that the author chose to include this since programming ADO.NET 2.0 is related to programming SQL Server 2005 but not the same thing at all.

Finally, I really like that this book does not simply recycle MSDN content, but rather complements it. There is enough reference material in the book to support the discussion and examples. After reading the book, you'll know enough about programming SQL Server 2005 to quickly find any reference material that you need in MSDN.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

2 of 2 people found the following review helpful:

5.0 out of 5 stars A very precise book, August 23, 2006

By	SPYRIDON PRANTALOS (Miami, FL USA) - See all my reviews (REAL NAME)

This is a very good book. It is quite compact and does not waste time and pages on huge examples that would not make any sense at the end. The only issue, at least for me, is that it includes only the new features of the Sql Server. As a result if you are a beginner with SQL Server you need to buy an introductory book before you read this one.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 13 customer reviews...

Most Recent Customer Reviews

5.0 out of 5 stars Very definitive guide to sql server programming. Topics are up-to-date and well covered.
This book covers nearly all topics on SQL Server programming. It begins with the differences between the SQL Server 2000 and 2005. Read more

Published 20 months ago by J. Druin

2.0 out of 5 stars Boring and inaccessible
This book is very inaccessible, not because it is too complex, but because it is poorly written. If you'd like to actually learn SQL Server programming I'd recommend Professional... Read more

Published 21 months ago by Jesse Lee Curry

4.0 out of 5 stars A Great Book for Learning New Features - Review of Database Administrator SQLAuthority.com
User does not have to be experience SQL Server 2005 programmer to use this book; as it is designed for users of all levels. Read more

Published 21 months ago by Pinalkumar Dave

5.0 out of 5 stars One of the best SQL Server programming book.
This is definitely one of my best SQL programming books. It covers the newer programming concepts; such as XML storage and handling in SQL 2005, very well. Read more

Published on July 10, 2007 by Saeer Butt

2.0 out of 5 stars Not for the faint of heart
As a new student to the field of SQL Server 2005, I was hoping to obtain a book learning the various methods of programming in SQL Server 2005. Read more

Published on November 9, 2006 by D. Donald

5.0 out of 5 stars Very easy to implement SMO from scratch
Having never written C# or C++ or DMO, I was able to quickly read parts of this book and successfully create a C# program using SMO/RMO to create my transactional / merge... Read more

Published on October 7, 2006 by P. Davallou

1.0 out of 5 stars Not what I needed
After reading other reviews, I ordered this book. I've worked with SQL Server since version 4.2 and just wanted a resource for new features. I was very disappointed. Read more

Published on August 22, 2006 by D. Rehm

4.0 out of 5 stars Learning SQL Server 2005
'Programming SQL Server 2005' by Bill Hamilton is a nice book, but the title is a bit misleading (in a sense). When it says '2005', this books MEANS 2005. Read more

Published on June 2, 2006 by Daniel McKinnon

5.0 out of 5 stars Nice walkthrough, needs more reference material
I enjoyed reading this book as a walkthrough style introduction to programming SQL Server. The writing is good. The graphics are sparing. Read more

Published on March 29, 2006 by Jack D. Herrington

5.0 out of 5 stars An editorial maistake
The title of the book is "Programming SQL Server 2005". This title is misleading at best. It should read "Programming SQL Server 2005 - New Features Only" implying that if you... Read more

Published on March 4, 2006 by Zeev Atlas

› See all 13 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jsOnDisplayBlock { display: none; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; }