Table of contents for Microsoft SQL server 2005 unleashed / Ray Rankins, et al.

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
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
***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. 
(, 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
Paul Bertucci is the founder of Database Architechs (, 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 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
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
(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***
***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***
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.
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 for 
convenient access to any updates, downloads, or errata that might be available for 
this book. 

Library of Congress Subject Headings for this publication:

SQL server.
Database management.