Bibliographic record and links to related information available from the Library of Congress catalog.
Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.
Table of Contents Introduction Part I Welcome to Microsoft SQL Server 1 SQL Server 2005 Overview 2 What's New in SQL Server 2005 Part II SQL Server Tools and Utilities 3 SQL Server Management Studio 4 SQL Server Command-Line Utilities 5 SQL Server Profiler Part III SQL Server Administration 6 SQL Server System and Database Administration 7 Installing SQL Server 2005 8 Upgrading to SQL Server 2005 9 Client Installation and Configuration 10 Security and User Administration 11 Database Backup and Restore 12 Database Mail 13 SQL Server Scheduling and Notification 14 SQL Server High Availability 15 Replication 16 Database Mirroring 17 SQL Server Clustering Part IV Database Administration 18 Creating and Managing Databases 19 Creating and Managing Tables 20 Creating and Managing Indexes 21 Implementing Data Integrity 22 Creating and Managing Views 23 Creating and Managing Stored Procedures 24 Creating and Managing User Defined Functions 25 Creating and Managing Triggers 26 Transaction Management and the Transaction Log 27 Database Snapshots 28 Database Maintenance Part V SQL Server Performance and Optimization 29 Indexes and Performance 30 Understanding Query Optimization 31 Query Analysis 32 Locking and Performance 33 Database Design and Performance 34 Monitoring SQL Server Performance Part VI SQL Server Application Development 35 What's New for Transact-SQL in SQL Server 2005 36 SQL Server and the .NET Framework 37 Using XML in SQL Server 2005 38 SQL Server Web Services Part VII SQL Server Business Intelligence Features 39 SQL Server Analysis Services 40 SQL Server Integration Services 41 SQL Server Reporting Services Bonus Chapters on the CD 42 Managing Linked and Remote Servers 43 Configuring, Tuning, and Optimizing SQL Server Options 44 Administering Very Large SQL Server Databases 45 SQL Server Disaster Recovery Planning 46 Transact-SQL Programming Guidelines, Tips, and Tricks 47 SQL Server Notification Services 48 SQL Server Service Broker 49 SQL Server Full-Text Search Index ************************************************************** ***PRODUCTION: Please insert full TOC here*** ***Begin About the Author page*** (c)About the Lead Authors Ray Rankins is owner and president of Gotham Consulting Services, Inc. (www.gothamconsulting.com), near Saratoga Springs, New York. Ray has been working with Sybase and Microsoft SQL Server for over 17 years and has experience in database administration, database design, project management, application development, consulting, courseware development, and training. He has worked in a variety of industries, including financial, manufacturing, health care, retail, insurance, communications, public utilities, and state and federal government. His expertise is in database performance and tuning, query analysis, advanced SQL programming and stored procedure development, database design, data architecture, and database application design and development. Ray's presentations on these topics at user group conferences have been very well received. Ray is coauthor of Microsoft SQL Server 2000 Unleashed (first and second editions), Microsoft SQL Server 6.5 Unleashed (all editions), Sybase SQL Server 11 Unleashed, and Sybase SQL Server 11 DBA Survival Guide, second edition, all published by Sams Publishing. He has also authored a number of articles, white papers, and database-related courses. As an instructor, Ray regularly teaches classes on SQL, advanced SQL programming and optimization, database design, database administration, and database performance and tuning. Ray's ability to bring his real-world experience into the classroom consistently rates very high marks from students in his classes for both his instructional skills and courseware. Ray can be reached at email@example.com. Paul Bertucci is the founder of Database Architechs (www.dbarchitechs.com), a database consulting firm with offices in the United States and Paris, France. He has more than 26 years of experience with database design, data architecture, data replication, performance and tuning, distributed data systems, data integration, high-availability assessments, and systems integration for numerous Fortune 500 companies, including Intel, 3COM, Coca-Cola, Apple, Toshiba, Lockheed, Wells Fargo, Safeway, Texaco, Charles Schwab, Cisco Systems, Sybase, Symantec, Veritas, and Honda, to name a few. He has authored numerous articles, standards, and high-profile courses, such as Sybase's "Performance and Tuning" and "Physical Database Design" courses. Other Sams books that he has authored include the highly popular Microsoft SQL Server 2000 Unleashed, ADO.NET in 24 Hours, and Microsoft SQL Server High Availability. He has deployed numerous systems with Microsoft SQL Server, Sybase, DB2, and Oracle database engines, and he has designed/architected several commercially available tools in the database, data modeling, performance and tuning, data integration, and multidimensional planning spaces. Paul's current working arrangement is as Symantec Corporations Chief Data Architect, and he also serves part time as chief technical advisor for a data integration server software company. Paul received his formal education in computer science and electrical engineering from UC Berkeley (Go Bears!). He lives in the great Pacific northwest (Oregon) with his wife, Vilay, and five children, Donny, Juliana, Paul Jr., Marissa, and Nina. Paul can be reached at pbertucci@DBArchitechs.com or Bertucci@Alum.CalBerkeley.Org. Chris Gallelli is president of CGAL Consulting Services, Inc. His company focuses on consulting services in the areas of database administration, database tuning and database programming using Visual Basic .NET. Chris has more than 10 years of experience with SQL Server and over 20 years in the field of Information Technology. He has a Bachelors degree in Electrical Engineering and a Masters in Business Administration from Union College. Chris was also one of the authors of "Microsoft SQL Server 2000 Unleashed" published by SAMS Publishing. Chris currently lives near Albany, New York with his lovely wife Laura and two daughters Rachael and Kayla. You can contact Chris at CGallelli@gmail.com. Alex T. Silverstein is managing principal and chief architect of the Unified Digital Group, LLC, a consulting and custom software development firm headquartered near Saratoga Springs, NY. He specializes in designing SQL Server and Microsoft .NET-powered solutions using the principles of Agile development and the Rational Unified Process. Alex has over a decade of experience providing application development, database administration, and training services worldwide to a variety of industries. He was also a contributing author for "Microsoft SQL Server 2000 Unleashed" published by SAMS Publishing. You can reach Alex anytime at firstname.lastname@example.org. (c)About the Contributing Authors Tudor Trufinescu joined Microsoft in January 1999, and has since worked on a number of projects and technologies ranging from Microsoft Metadata services, HTTP-DAV, and SQL Server Reporting Services. He was one of the founding members of the SQL Server reporting services team. His team designed and built the server components of Reporting Services as and the report controls included in Visual Studio 2005. Before joining Microsoft, Tudor helped build a number of software solutions, including a workflow and document management application and a real-time production monitoring system. Tudor received his degree in Electronic Engineering and Information Technology from the University of Bucharest, Romania in 1992. Tudor and his family currently live in Redmond, WA. ***End About the Author*** ************************************************************** ***Begin Dedication/Acknowledgments page*** (c)Dedication ***Begin Dedication*** I would like to dedicate this book to my beautiful wife of 20 years, Elizabeth, and my son, Jason, for their continued love, support, and understanding during the long hours and lost weekends spent working on this book. [md]Ray Rankins Dedicated to my wife, Vilay, for whom I say "koin hug chow" ("I love you" in Thai/Laotian). [md]Paul Bertucci This book is dedicated to my wife, Laura, and my two daughters, Rachael and Kayla. Keeping an active house quiet while I was working on this book was no small feat but they made it happen. They showed a great deal of patience and understanding during the entire process. Thank you!!! [md]Chris Gallelli I dedicate this work to my girlfriend, Ellen, who patiently endured my absence during the scores of hours devoted to it. [md]Alex T. Silverstein ***End Dedication*** (c)Acknowledgments I would first like to thank my coauthors for their tireless efforts in helping to turn out a quality publication and their willingness to take on more work when needed to help keep things on track. I would also like to thank Neil Rowe at Sams Publishing for providing us the opportunity to write this book and for his patience in regard to our deadlines. Most of all, I wish to thank my family, Elizabeth and Jason, for their patience and understanding during the long days and late nights spent working on this book when I should have been spending quality family time with them. [md]Ray Rankins With any writing effort, there is always a huge sacrifice of time that must be made to properly research, demonstrate, and describe leading-edge subject matter. The brunt of the burden usually falls on those many people who are near and very dear to me. With this in mind, I desperately need to thank my family for allowing me to encroach on many months of what should have been my family's "quality time." However, with sacrifice also comes reward in the form of technical excellence and solid business relationships. Many individuals were involved in this effort, both directly and indirectly. Starting with Jeff Brzycki, Jack McElreath, Emily Breuner- Jaquette, Jay Jones, Mark Johnson, Scott Smith, and Walter Kuketz. And special thanks this time must go to my colleagues in France, Yves Moison and Thierry Gerardin. Their expertise in and knowledge of SQL, performance and tuning, and high availability are unmatched. Merci beaucoup! [md]Paul Bertucci Writing a book of this size and scope requires a tremendous amount of time and dedication. The time and dedication applies to the authors that are writing the book but also applies to their family members as well. My wife and daughters were very understanding while I was holed up working on this book and that understanding helped make the book happen. My love and thanks to them. I would also like to thank many of my clients that embraced SQL Server 2005 and adopted the product shortly after if was released. In particular, I would like to thank Ray McQuade and his company Spruce Computer Systems. Spruce has had tremendous success with SQL Server 2005 and they gave me some of the ?real world? experience that was invaluable in creating this book. [md]Chris Gallelli I am most grateful to those whom I am gifted with the opportunity to serve: You are my teachers on this path. To my fellow authors, clients, friends, and mentors: Without you, I would not be the person I am today. Particularly, I?d like to express my appreciation to the men and women at Thomson Learning and at HANYS for making the consulting life a pleasure (and for using the latest technology!), to the staff of Sams Publishing for putting this book together, to my co-authors for trusting in me and providing such an awesome opportunity, to my family, both original and chosen, for their unconditional love, and, finally, to that unknown power which continually drives me on to a better life. Thanks to all who gave me a chance to grow throughout this process. [md]Alex T. Silverstein ***End Acknowledgments*** ***Begin Tell Us What You Think page*** (c)We Want to Hear from You! As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what we're doing right, what we could do better, what areas you'd like to see us publish in, and any other words of wisdom you're willing to pass our way. As an associate publisher for Sams Publishing, I welcome your comments. You can email or write me directly to let me know what you did or didn't like about this book[md]as well as what we can do to make our books better. Please note that I cannot help you with technical problems related to the topic of this book. We do have a User Services group, however, where I will forward specific technical questions related to the book. When you write, please be sure to include this book?s title and author as well as your name, email address, and phone number. I will carefully review your comments and share them with the author and editors who worked on the book. Email: email@example.com Mail: Greg Wiegand Associate Publisher Sams Publishing 800 East 96th Street Indianapolis, IN 46240 USA (c)Reader Services Visit our website and register this book at www.samspublishing.com/register for convenient access to any updates, downloads, or errata that might be available for this book.
Library of Congress Subject Headings for this publication: