Microsoft SQL Server 2005 Developer's Guide [Paperback]

Michael Otey (Author), Denielle Otey (Author)

Book Description

ISBN-10: 0072260998 | ISBN-13: 978-0072260991 | Publication Date: October 31, 2005 | Edition: 1

Developers will discover how to unleash the full power of Microsoft SQL Server 2005 with this developer's guide by best-selling author, Michael Otey. Completely rewritten and reengineered, this book will focus on the new programming models and will provide readers with all the information they need to produce top-quality commercial applications

Editorial Reviews

From the Back Cover

CREATE ROBUST DATA MANAGEMENT AND BUSINESS INTELLIGENCE APPLICATIONS

Build powerful, enterprise-wide database programs using Microsoft SQL Server 2005 and the comprehensive information contained in this definitive volume. Microsoft SQL Server 2005 Developer's Guide explains how to develop server-side and client-side database applications and analyze business intelligence data. All of the brand-new features are covered in-depth -- including .NET CLR Integration, Reporting Services, Integration Services, Notification Services, and Service Broker. Real-world examples and practical tips detail how to use SQL Server 2005 as a cross-tier database platform with Visual Studio 2005, create custom management scripts with SQLCMD, and improve performance with SQL Profiler.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS

• Use SQL Server Management Studio and Business Intelligence Development Studio
• Write stored procedures and use T-SQL Data Definition Language (DDL) and Data Manipulation Language (DML)
• Create custom database objects with .NET CLR
• Build enterprise database applications using ADO, ADO.NET, and ADOMD.NET
• Develop and deploy SQL Server Integration Services packages
• Design enterprise reports using Reporting Services and Report Builder
• Integrate cross-platform data using XML and Web services
• Extend SQL Server manageability using SQL Management Objects (SMO)

About the Author

Michael Otey (Portland, OR) is Senior Technical Editor of SQL Server 2000 Magazine and co-author of SQL Server 2000 Developer's Guide and SQL Server 7 Developer's Guide. He is the president of TECA, Inc., a software development and consulting firm.

Product Details

• Paperback: 507 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (October 31, 2005)
• Language: English
• ISBN-10: 0072260998
• ISBN-13: 978-0072260991
• Product Dimensions: 9.2 x 7.5 x 1 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 2.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #666,182 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

3 of 3 people found the following review helpful:

3.0 out of 5 stars Book was very helpful., July 22, 2006

By 

RVSSUG "Roanoke Valley SQL Server Users Group" (Ronaoke, VA) - See all my reviews

This review is from: Microsoft SQL Server 2005 Developer's Guide (Paperback)

This book review was submitted by a Roanoke Valley SQL Server Users Group member as part of the Book Review Program.

Review by Will Ashley

As someone who doesn't know too much database stuff (just SP's and light administration things), I thought this book was very helpful in pointing me in the right direction and giving me a good overview of some of the new features of SQL Server 2005. I would not recommend this book to a SQL expert, as you probably know most of what is covered already. I like the way he has this book organized, it makes it easy to find the section you are dealing with. This book will be on my reference shelf if I need to figure out something in SQL Server 2005.

Will Ashley

4 of 7 people found the following review helpful:

2.0 out of 5 stars What a mess, March 15, 2006

By 

Michael Baumann (Atlanta, GA United States) - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server 2005 Developer's Guide (Paperback)

OK, the structure of this book is not bad, the chapters covered overall appeared to make for a good read. I further have to admit I have not worked through the whole book yet, but who prove-read this book? There are so many errors in there it is no fun whatsoever to work with the code examples. And if an example has no error it has inconsistencies like projects being named differently in two code blocks/screenshots.
I definately do NOT recommend this book, especially not for experienced SQL Developers as the Author rambles the first 80 or so pages on how to use Select, Insert and Update statements with putting only little weigth on the T-SQL enhancements of SQL Server 2005.