|Table of Contents|
|Part I -
|Part II -
|Part III -
|Part IV -
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:
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
2100 Powell Street, 10th Floor
Emeryville, California 94608
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
Vice President & Group Publisher
Vice President & Publisher
Julie M. Smith
Elizabeth Jang, Dick Schwartz
Kathleen Edwards, Melinda Lytle
Peter F. Hancik
Cover Series Designer
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.
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.
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.
This book is dedicated to my Mom who planted in me the faith to tackle life’s challenges and problems.