Microsoft SQL Server 2005 Developer's Guide (Paperback)

by Michael Otey (Author), Denielle Otey (Author)

Editorial Reviews

Product Description
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

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)

See all Editorial Reviews

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 x 7.3 x 1.3 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.com Sales Rank: #783,428 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #46 in

  Books > Computers & Internet > Certification Central > MS SQL Server

Customer Reviews

Most Helpful Customer Reviews

2 of 2 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 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

3 of 4 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)

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.