Table of Contents


microsoft sql server 2005 new features
Microsoft SQL Server 2005 New Features
byMichael Otey
McGraw-Hill/Osborne 2005 (288 pages)
ISBN:0072227761

Get full details on all the innovative features and benefits available in the release of SQL Server 2005. This authoritative guide explains new and improved enterprise data management capabilities, developer functions, and business intelligence tools.

Table of Contents
Microsoft SQL Server 2005 New Features
Introduction
Part I - Database Administration Features
Chapter 1 - Database Architecture and Storage Engine Features
Chapter 2 - Database Administration and Development Tools
Chapter 3 - Availability and Recovery Features
Part II - Database Development Features
Chapter 4 - Programmability Features
Chapter 5 - Notification Services
Chapter 6 - SQL Server Service Broker
Chapter 7 - XML Integration
Part III - Business Intelligence Features
Chapter 8 - Reporting Services
Chapter 9 - Integration Services
Chapter 10 - Analysis Services
Part IV - Appendixes
Appendix A - Installation and Upgrading
Appendix B - Quick Facts
Index
List of Figures
List of Tables


Back Cover

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.



Microsoft SQL Server 2005 New Features

Michael Otey

McGraw-Hill/Osborne
2100 Powell Street, 10th Floor
Emeryville, California  94608
U.S.A.

To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact McGraw-Hill/Osborne at the above address. For information on translations or book distributors outside the U.S.A., please see the International Contact Information page immediately following the index of this book.

Microsoft® SQL Server 2005 New Features

Copyright © 2005 by The McGraw-Hill Companies. All rights reserved. Printed in the United States
of America. Except as permitted under the Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of publisher, with the exception that the program listings may be entered, stored, and executed in a computer system, but they may not be reproduced for publication.

1234567890 FGR FGR 01987654

ISBN 0-07-222776-1

Vice President & Group Publisher
Mike Hays

Vice President & Publisher
Scott Grillo

Acquisitions Editor
Wendy Rinaldi

Project Editor
Julie M. Smith

Acquisitions Coordinator
Alex McDonald

Technical Editor
Tom Rizzo

Copy Editor
Bob Campbell

Proofreader
Susie Elkind

Indexer
Valerie Perry

Composition
Elizabeth Jang, Dick Schwartz

Illustrators
Kathleen Edwards, Melinda Lytle

Series Design
Peter F. Hancik

Cover Series Designer
Pattie Lee

This book was composed with Corel VENTURA Publisher.

Information has been obtained by McGraw-Hill/Osborne from sources believed to be reliable. However, because of the possibility of human or mechanical error by our sources, McGraw-Hill/Osborne, or others, McGraw-Hill/Osborne does not guarantee the accuracy, adequacy, or completeness of any information and is not responsible for any errors or omissions or the results obtained from the use of such information.

Acknowledgments

I’d like to acknowledge all of the help from the great people at Osborne who made this book possible. Wendy Rinaldi planted the seed for this book on SQL Server 2005’s new features and gave me the encouragement to grow it from an idea into a full fledged book. Julie Smith, the book’s project editor, juggled a hectic schedule and a stream of new material, revisions, and edits as she managed the tough task of bringing all of the material for the book together. I’m also thankful for the efforts of copy editor Bob Campbell, proofreader Susie Elkind, indexer Valerie Perry, and Elizabeth Jang and Dick Schwartz for page composition.

I also got substantial help from Tom Rizzo and Eric Brown who provided essential technical reviews. Their efforts helped me to keep up with the rapidly evolving product as it moved through its prerelease and beta cycles. To the degree this book meets my goals of technical excellence; I owe a lot to Tom and Eric. Of course, I take responsibility for any errors that may remain in the final version.

And I’d also like to give a special thanks to my wife, and not-so-silent partner, Denielle Otey, one of the book’s technical editors. She rigorously tested and retested all of the code samples used in the book as well as giving me advice and support throughout the project.

Michael Otey

About the Author

Michael Otey is the Technical Director for Windows ITPro Magazine and Senior Technical Editor for  SQL Server Magazine. He is also President of TECA, Inc (www.teca.com), a software development and consulting company that specializes in networking and database applications. Michael is the co-author of the SQL Server 2000 Developer’s Guide and the ADO.NET: The Complete Reference published by McGraw Hill/Osborne.

Dedication

This book is dedicated to my Mom who planted in me the faith to tackle life’s challenges and problems.

Michael Otey