Programming Microsoft SQL Server 2005 [Paperback]

Andrew Brust (Author), Stephen Forte (Author)

List Price:	CDN$ 67.99
Price:	CDN$ 42.98 & this item ships for FREE with Super Saver Shipping. Details
You Save:	CDN$ 25.01 (37%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

Usually ships within 1 to 3 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.

Product Details

Paperback: 928 pages
Publisher: Microsoft Press; 1 edition (Jun 28 2006)
Language: English
ISBN-10: 0735619239
ISBN-13: 978-0735619234
Product Dimensions: 22.4 x 19.8 x 3.8 cm
Shipping Weight: 1.4 Kg
Amazon Bestsellers Rank: #359,670 in Books (See Top 100 in Books)
- #73 in Books > Computers & Internet > Databases > Relational Databases

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

See Complete Table of Contents

Product Description

Book Description

Get the straightforward information you need to learn the core programmability features in SQL Server 2005. This guide offers hands-on programming instruction, practical examples, and code samples to help you design and develop robust database applications and business intelligence solutions.

Discover how to:

Program views, stored procedures, triggers, and functions using T-SQL
Work with the new XML data type and XQuery method
Automate common administration and maintenance tasks
Debug databases, reports, and objects using Microsoft Visual Studio 2005
Write transactional code and implement local and distributed transactions
Develop mobile data applications using SQL Server 2005 Everywhere Edition
Use SQL Server Notification Services to develop applications that deliver event-driven notifications to users
Use business intelligence tools, such as SQL Server Reporting Services and OLAP and data mining components
PLUS—Get C# code samples on the Web

About the Author

Andrew J. Brust is the Chief, New Technology at twentysix New York, a Microsoft Gold Certified Partner specializing in business intelligence, enterprise integration and Microsoft .NET application development. Andrew is a Microsoft Regional Director for New York/New Jersey and a member of Microsoft’s Business Intelligence Partner Advisory Council.

Stephen Forte is the cofounder and CTO of Corzen, Inc. He is also a Microsoft Regional Director for New York and a Microsoft MVP.

Inside This Book (Learn More)

First Sentence
This book is all about Microsoft SQL Server 2005 and specifically how to program it. Read the first page

Explore More
Concordance

Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

Customer Reviews

There are no customer reviews yet on Amazon.ca

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

Share your experience with this product with others

Create your own review

Most Helpful Customer Reviews on Amazon.com ^(beta)

Amazon.com: 4.1 out of 5 stars (7 customer reviews)

25 of 27 people found the following review helpful

5.0 out of 5 stars Great book on programming new features, Sep 10 2006

By Christophe Besant - Published on Amazon.com

This review is from: Programming Microsoft SQL Server 2005 (Paperback)

This book is clearly written and I feel it does a good job of covering the major new features of SQL Server 2005 well enough so you can get up to speed quickly and save enough time versus puzzling things out using just the online materials that come with SQL Server 2005 to easily justify the purchase price and reading time. A number of people with expertise in various aspects of SQL Server collaborated on this book, and the value of the information in each area reflects the depth of expertise.

The book is thick, but it's not bloat -- there is just a heck of a lot of stuff to cover in SQL Server 2005. If anything, I'd be happy to buy the book again if another edition comes out with 300 more pages full of more details and more complex examples in several areas. In the mean time, there is plenty to get one going and fill out specific details with the online doco and the 'net.

I think this book is too advanced for programmers who aren't already up to speed with .NET and relational database server programming. For those of us for which MS SQL 2005 is mostly just another iteration of good ol' Squirrel Server (albeit a big whopping upgrade architecturally and feature-wise), and who've already moved to C# + VS 2005 + .NET 2.0, this is the best book I've found so far.

I addition to covering the new features of SQL Server 2005, this book also provides deeper coverage of several advanced relational database techniques than just the enhancements specific to the 2005 edition of SQL Server. OLAP and XML operations being prime examples. I think the authors made a good choice by providing more than just an overview of the 2005 enhancements as without the broader coverage, presentation of the enhancements themselves wouldn't have made much sense to me.

I also think the book is pretty well organized so you don't have to waste time hunting down what you need. I do warn you however, that you may have to read some parts of the book first before plunging into the specific topic you need first. It's not a fault: SQL Server 2005 includes the CLR, and much of the rest of the book sensibly uses C# on the SQL Server CLR examples, so you kinda have to get up to speed programming in the SQL server CLR first, don't you?

7 of 7 people found the following review helpful

5.0 out of 5 stars New Favorite Reference Book, Nov 4 2006

By Chris Anderson - Published on Amazon.com

This review is from: Programming Microsoft SQL Server 2005 (Paperback)

I've had this book for a little over a week, looking for time to give it some proper due. Now I only wished I had delved into it right away. Or gotten it sooner. It's now moved to the front of the line as my favorite reference book.

Clearly written and organized, it took me all of 15 minutes to follow a new concept (to me). It was logical, building upon itself and fully explained what was going on, and HOW it works too. It's been my experience in the past that developer books fall into one of two categories: Tutorial and Reference. This is the first one that I have seen sucessfully split the two and combine the best of both. The author right up front explains what the book does and does not cover.

This book isn't for DBAs or people who want to know how to use SQL Server 2005. The book is for developers who want to know how to use the new features of SQLServer 2005, and how to use them in .NET 2.0.

I'm not sure how I've gone so long with out this book. Just in the last hour, it's been a life savor. I'm learning about capabilities that I'd never seen documented anywhere else.

9 of 11 people found the following review helpful

3.0 out of 5 stars Nice Intro but Little Content., Feb 8 2007

By M. Loftus - Published on Amazon.com

Amazon Verified Purchase(What's this?)

This review is from: Programming Microsoft SQL Server 2005 (Paperback)

This is your typical intro book, good for a tour through the highlights. But it is not a reference book, and because it covers so many topics it can spend very little time on any one subject. You will find all the material at the MS web site. You will still need to find more thorough reference material in order to be successful.

› Go to Amazon.com to see all 7 reviews 4.1 out of 5 stars