Programming SQL Server 2005
Programming SQL Server 2005 By Bill Hamilton
February 2006
Pages: 586

| Table of Contents | Index | Sample Chapter | Colophon

Table of Contents

  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

Return to Programming SQL Server 2005