Microsoft SQL Server 2005 New Features [Paperback]

Michael Otey (Author)

Book Description

ISBN-10: 0072227761 | ISBN-13: 978-0072227765 | Publication Date: June 25, 2004 | Edition: 1

Written by Michael Otey, Senior Technical Editor of SQL Server Magazine, this authoritative resource introduces the new features in the Yukon release, providing a jump start for IT professionals transitioning from SQL Server 7 and SQL Server 2000.

Editorial Reviews

From the Back Cover

Take Full Advantage of The Database and Analysis Potential of SQL Server 2005

Get full details on all the innovative features and benefits available in the upcoming release of SQL Server 2005. This authoritative guide explains the new and improved enterprise data management capabilities, developer functions, and business intelligence tools. You’ll see how the new release offers enhanced scalability, availability, and security, as well as ease-of-use. Written by the Senior Technical Editor of SQL Server Magazine, this is an ideal resource for decision-makers, developers, and DBAs preparing for upgrades or migration.

Covers new and improved capabilities including:

• All news tools such as SQL Server Management Studio and Business Intelligence Development Studio
• .NET Common Language Runtime (CLR) integration
• Enhanced availability and recovery features including Database Mirroring and Snapshot Isolation
• T-SQL enhancements and new data types
• Improved XML integration and the new native XML data type
• The new Reporting Services and SQL Server Broker subsystems
• The new Unified Dimensional Model and Data Mining algorithms
• Security enhancements such as secure default settings and Schema ownership
• The enterprise-ready Integration Services
• All new development models: AMO, SMO, ODL, XMLA

About the Author: Michael Otey is Senior Technical Editor of SQL Server Magazine, Technical Director of Windows IT Pro Magazine, and co-author of SQL Server 2000 Developer’s Guide and SQL Server 7 Developer’s Guide, both from McGraw-Hill/Osborne. He is the president of TECA, Inc., a software development and consulting firm.

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 & SQL Server 7 Developer’s Guide. H is the president of TECA, Inc., a software development and consulting firm.

Product Details

• Paperback: 352 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (June 25, 2004)
• Language: English
• ISBN-10: 0072227761
• ISBN-13: 978-0072227765
• Product Dimensions: 9.1 x 7.2 x 0.8 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #1,688,208 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

5 of 5 people found the following review helpful:

4.0 out of 5 stars Great Overview of New Functionality, March 15, 2006

By 

Terry Smith "http://terrysmith.net -- http:/... (Little Rock, AR USA) - See all my reviews
(REAL NAME)   

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

This book came out when SQL Server 2005 was still in Beta. Even though the product has already shipped, I would still recommend this book to anyone wanting a broad overview of the product suite. It covers what's new in the development and administration tools, T-SQL enhancements, and overviews of Notification Services, SQL Server Service Broker, XML Integration, Reporting Services, Integration Services, and Analysis Services. Even though it's a high-level perspective there are enough code snippets and technical details to keep it interesting. The author is Senior Technical Editor of SQL Server Magazine, and the book is excellently written.

2 of 2 people found the following review helpful:

2.0 out of 5 stars Very high level overview, October 24, 2006

By 

Marc D. Troike "Vette Owner" (Dayton, OH) - See all my reviews
(REAL NAME)   

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

While I acknowledge that I am writing this review long after the initial release of this book, I expected more from it when I made the purchase.

I've just started chapter 4, Programmability Features. The code is out of date and many of the features discussed have been changed in Visual Studio 2005.

The book is still useful for a brief introduction of new features. If you want to implement any of the features be sure to get a book that is based on the actual released versions of SQL Server 2005 and Visual Studio 2005.

1 of 1 people found the following review helpful:

3.0 out of 5 stars it's a bit out of date, March 27, 2007

By 

Chopper2000 - See all my reviews

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

I don't think you should read this book if you wanting an overview of the new features in SQL Server 2005. Much of the content is out of date because the product changed while the book was being printed.

If you interested in a book with accurate feature explanations, I'd try SQL Server 2005 Distilled. It's very accurate and not full of filler content- like entire XML schemas:>