Programming Microsoft SQL Server 2005 [Paperback]

Andrew J Brust (Author), Stephen Forte (Author)

Book Description

Publication Date: June 28, 2006

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

Editorial Reviews

From the Publisher

Key Book Benefits:

-Features essential coverage of key mobile-development topics -Covers application development for .NET Compact Framework 2.0, in addition to SQL Server 2005 Everywhere Edition and Microsoft Windows Mobile® 5.0, running on devices such as Pocket PCs and Windows Mobile Smartphones -Delivers practical guidance based on the authors' extensive, real-world experience -Includes code samples in C#, with additional code samples in Visual Basic on the Web

About the Author

Andy Wigley Andy has been building mobile computing solutions for many years, and has been awarded Most Valuable Professional (MVP) status by Microsoft every year since 2003 for his work assisting the .NET Compact Framework developer community.He has enjoyed a long working relationship with Content Master, delivering consultancy and creating books, MSDN articles and other training materials mainly aimed at those early adopters working at the 'bleeding edge' of the newest Microsoft development technologies. Andy is a regular speaker at major Microsoft conferences such as MEDC and TechEd, and the co-author of the Microsoft Press books on the .NET Compact Framework V1.0 and on developing ASP.NET Websites for mobile devices. Outside computing, Andy is a climber/mountaineer, both on the crags of Wales where he lives, and also mountaineering in the Alps and the Himalaya. He also performs regularly in the pubs of North Wales in a three-piece rock band.

Daniel Moth Daniel Moth works in the UK for Microsoft in the Development & Platform group. Daniel gets to "play" with the latest and greatest Microsoft software and then explains and demonstrates it via his blog, articles, webcasts, screencasts, online chats and in person at developer events. Before joining Microsoft, he worked for a large consultancy and before that in an R&D department. In addition to significant industry experience, he holds a BSc in Computing for Business, an MSc with distinction in Object Oriented Software Technology, Microsoft certifications and he has been working with .NET since the first public beta in 2000. Daniel gained the Most Valuable Professional (MVP) award in .In his spare time he loves to travel around the world, be it on city breaks, lazing on the beach or SCUBA diving the oceans.

Peter Foot Peter is the founder of In The Hand Ltd, a company providing development and consulting services for mobile devices. In The Hand also produces software components for the .NET Compact Framework to assist other developers from hobbyists through to Small to Medium Enterprises. Prior to working with Pocket PCs, Peter led a test team for a major UK mobile internet portal and the UK's first consumer GPRS service. Peter holds a BSc in Computer Science. Peter established the 32feet.NET shared-source community project bringing Bluetooth and IrDA technologies into easy reach of .NET developers. Peter has also been an active contributor to other shared-source initiatives for mobile and embedded developers.He has also had developer articles published at MSDN.

Product Details

• Paperback: 950 pages
• Publisher: Microsoft Press (June 28, 2006)
• Language: English
• ISBN-10: 0735619239
• ISBN-13: 978-0735619234
• Product Dimensions: 8.8 x 7.8 x 1.5 inches
• Shipping Weight: 3 pounds (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #968,660 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

25 of 27 people found the following review helpful:

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

By 

Christophe Besant (Minnetrista, MN USA) - See all my reviews
(REAL NAME)   

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, November 4, 2006

By 

Chris Anderson (Bellevue, NE United States) - See all my reviews

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., February 8, 2007

By 

M. Loftus - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

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.