1. Chapter 1 Introduction

   1. Contents of This Book

   2. What's Not in This Book

2. Chapter 2 Tools and Utilities

   1. SQL Server Management Studio

   2. SQL Server Configuration Manager

   3. SQL Server Surface Area Configuration

   4. Database Engine Tuning Advisor

   5. SQL Server Profiler

   6. SQL Server Business Intelligence Development Studio

   7. Visual Studio 2005

   8. New Command-Line Utilities

3. Chapter 3 T-SQL Enhancements

   1. New Data Types

   2. T-SQL Language Enhancements

   3. Data Definition Language (DDL) Triggers

   4. Metadata

4. Chapter 4 Introduction to Common Language Runtime (CLR) Integration

   1. CLR Integration Design Objectives

   2. Enabling CLR Integration

   3. Required .NET Namespaces

   4. Types of CLR Routines

   5. Hello World Example

   6. DDL Support for CLR Integration

   7. ADO.NET In-Process Extensions Supporting CLR Programming

   8. Custom Attributes for CLR Routines

   9. SQL Server Data Types in the .NET Framework

   10. Testing and Debugging CLR Routines

5. Chapter 5 Programming SQL Server CLR Routines

   1. Scalar-Valued Functions

   2. Table-Valued Functions

   3. Stored Procedures

   4. User-Defined Aggregate Functions

   5. User-Defined Types

   6. Triggers

6. Chapter 6 .NET Client-Side Programming

   1. SQL Native Client Programming

   2. SQLXML 4.0

   3. Exception Message Box

7. Chapter 7 XML Data

   1. xml Data Type

   2. Creating xml Data Type Instances

   3. XML Data Type Methods

   4. Viewing XML Data as Relational Data

   5. Indexing XML Data

   6. Managing XML Schema Collections

   7. XQuery Support

   8. XML Data Manipulation Language

   9. XML Results Using the FOR XML Clause

   10. XML Catalog Views

8. Chapter 8 Native XML Web Services

   1. Open Standards

   2. Creating a Web Service

   3. Creating the HTTP Endpoint and Exposing a Web Method Example

   4. SOAP Request and Response Messages

   5. Managing HTTP Endpoints

9. Chapter 9 SQL Server Management Objects (SMO)

   1. SMO Object Model

   2. Creating an SMO Project in Visual Studio .NET

   3. A Simple SMO Application

10. Chapter 10 SQL Server Management Objects (SMO) Instance Classes, Part 1

    1. Programming SMO Instance Classes for Administering Data Storage Objects

    2. SMO Instance Classes for Administering Data Storage Objects Reference

11. Chapter 11 SQL Server Management Objects (SMO) Instance Classes, Part 2

    1. Programming SMO Instance Classes for Administering Database Objects Not Used for Data Storage

    2. SMO Instance Classes for Administering Objects Not Used for Data Storage Reference

12. Chapter 12 SQL Server Management Objects (SMO) Utility Classes

    1. Scripting

    2. Backing Up and Restoring Data

    3. Transferring Data

    4. Tracing

    5. Database Mail

13. Chapter 13 Programming Windows Management Instrumentation (WMI)

    1. Programming SMO WMI Classes

14. Chapter 14 SQL Server Reporting Services (SSRS)

    1. Getting Started

    2. Integrating Reports into Applications

    3. Reporting Services Extensions

15. Chapter 15 SQL Server Integration Services (SSIS)

    1. Architecture

    2. Tools

    3. Programming SSIS

16. Chapter 16 SQL Server Agent

    1. Programming SQL Server Agent

17. Chapter 17 Service Broker

    1. Architecture

    2. Programming Service Broker

18. Chapter 18 Notification Services

    1. Architecture

    2. Creating a Notification Services Application

    3. Programming Notification Services

19. Chapter 19 Replication

    1. Programming Replication

20. Chapter 20 SQL Server Analysis Services (SSAS)

    1. Before You Begin

    2. SSAS Overview

    3. SSAS Database

    4. SSAS Languages

    5. Development

    6. Accessing Data by Using ADOMD.NET

    7. Administering SSAS Objects

21. Chapter 21 SQL Server Mobile Edition

    1. Environments

    2. Prerequisites

    3. Programming SQL Server Mobile

1. Appendix A ADO.NET 2.0

   1. Data Provider Enumeration and Factories

   2. Data Provider Enhancements

   3. Disconnected Class Enhancements

2. About the Author

3. Colophon

The animal on the cover of Programming SQL Server 2005 is an arctic cod. The arctic cod (Boreogadus saida) can be found living in the icy waters off northern Russia, Greenland, Canada, and Alaska. It is smaller and thinner than its cousin, the Atlantic cod, and characterized by a deeply forked tail, projecting lower jaw, and the presence of a small-sized "whisker" or barbel beneath its jaw.

Little is known about the life stages of young arctic cod as they are bred beneath layers of ice in autumn and winter off the coast of Canada, and from January to February off the coast of Russia. It is known that females can release between 9,000 to 21,000 eggs, which are then externally fertilized by the males with a milky substance called milt.

Arctic cod become mature at three years and can measure as long as 15 inches but usually not longer than a foot. Weight is related to length with a 4-inch fish weighing less than an ounce and an 11-inch fish weighing over six ounces. The body size of the species decreases from north to south so that Arctic cod in northern waters appear larger than their southern family members.

Arctic cod can be found near the surface waters or as deep as 2,953 feet. In open waters, arctic cod swim in schools, but closer to the surface, they tend to live in much smaller groups. They can be found living in narrow spaces of water called "water wedges" between layers of ice. The water wedges are inaccessible to larger predators such as seals.

Adults have small scales and are brown-colored along their sides and back, with black spots. Fins are dark and nearly black in color, with a pale edge and a long pale line that runs along the side of the fish from head to tail. The arctic cod can live up to six years, and scientists can determine their age by counting the rings that appear in the ear bones of the creatures.

Arctic cod consume mostly plankton, which are tiny marine plants and animals that float near the surface of ocean water. They are themselves an important part of the food chain, and narwhals, beluga whales, and seabirds such as murres depend on them as food.

The cover image is from Wood's Animate Creation. The cover font is Adobe ITC Garamond. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed.