Table of Contents

Programming SQL Server 2005
By Bill Hamilton
...............................................
Publisher: O'Reilly
Pub Date: February 2006
Print ISBN-10: 0-596-00479-6
Print ISBN-13: 978-0-59-600479-8
Pages: 586

Table of Contents  | Index

		Programming SQL Server 2005
		Preface
			What You Need to Use This Book
			Conventions Used in This Book
			How to Contact Us
			Safari® Enabled
			Acknowledgments
		Chapter 1.  Introduction
			Section 1.1.  Contents of This Book
			Section 1.2.  What's Not in This Book
		Chapter 2.  Tools and Utilities
			Section 2.1.  SQL Server Management Studio
			Section 2.2.  SQL Server Configuration Manager
			Section 2.3.  SQL Server Surface Area Configuration
			Section 2.4.  Database Engine Tuning Advisor
			Section 2.5.  SQL Server Profiler
			Section 2.6.  SQL Server Business Intelligence Development Studio
			Section 2.7.  Visual Studio 2005
			Section 2.8.  New Command-Line Utilities
		Chapter 3.  T-SQL Enhancements
			Section 3.1.  New Data Types
			Section 3.2.  T-SQL Language Enhancements
			Section 3.3.  Data Definition Language (DDL) Triggers
			Section 3.4.  Metadata
		Chapter 4.  Introduction to Common Language Runtime (CLR) Integration
			Section 4.1.  CLR Integration Design Objectives
			Section 4.2.  Enabling CLR Integration
			Section 4.3.  Required .NET Namespaces
			Section 4.4.  Types of CLR Routines
			Section 4.5.  Hello World Example
			Section 4.6.  DDL Support for CLR Integration
			Section 4.7.  ADO.NET In-Process Extensions Supporting CLR Programming
			Section 4.8.  Custom Attributes for CLR Routines
			Section 4.9.  SQL Server Data Types in the .NET Framework
			Section 4.10.  Testing and Debugging CLR Routines
		Chapter 5.  Programming SQL Server CLR Routines
			Section 5.1.  Scalar-Valued Functions
			Section 5.2.  Table-Valued Functions
			Section 5.3.  Stored Procedures
			Section 5.4.  User-Defined Aggregate Functions
			Section 5.5.  User-Defined Types
			Section 5.6.  Triggers
		Chapter 6.  .NET Client-Side Programming
			Section 6.1.  SQL Native Client Programming
			Section 6.2.  SQLXML 4.0
			Section 6.3.  Exception Message Box
		Chapter 7.  XML Data
			Section 7.1.  xml Data Type
			Section 7.2.  Creating xml Data Type Instances
			Section 7.3.  XML Data Type Methods
			Section 7.4.  Viewing XML Data as Relational Data
			Section 7.5.  Indexing XML Data
			Section 7.6.  Managing XML Schema Collections
			Section 7.7.  XQuery Support
			Section 7.8.  XML Data Manipulation Language
			Section 7.9.  XML Results Using the FOR XML Clause
			Section 7.10.  XML Catalog Views
		Chapter 8.  Native XML Web Services
			Section 8.1.  Open Standards
			Section 8.2.  Creating a Web Service
			Section 8.3.  Creating the HTTP Endpoint and Exposing a Web Method Example
			Section 8.4.  SOAP Request and Response Messages
			Section 8.5.  Managing HTTP Endpoints
		Chapter 9.  SQL Server Management Objects (SMO)
			Section 9.1.  SMO Object Model
			Section 9.2.  Creating an SMO Project in Visual Studio .NET
			Section 9.3.  A Simple SMO Application
		Chapter 10.  SQL Server Management Objects (SMO) Instance Classes, Part 1
			Section 10.1.  Programming SMO Instance Classes for Administering Data Storage Objects
			Section 10.2.  SMO Instance Classes for Administering Data Storage Objects Reference
		Chapter 11.  SQL Server Management Objects (SMO) Instance Classes, Part 2
			Section 11.1.  Programming SMO Instance Classes for Administering Database Objects Not Used for Data Storage
			Section 11.2.  SMO Instance Classes for Administering Objects Not Used for Data Storage Reference
		Chapter 12.  SQL Server Management Objects (SMO) Utility Classes
			Section 12.1.  Scripting
			Section 12.2.  Backing Up and Restoring Data
			Section 12.3.  Transferring Data
			Section 12.4.  Tracing
			Section 12.5.  Database Mail
		Chapter 13.  Programming Windows Management Instrumentation (WMI)
			Section 13.1.  Programming SMO WMI Classes
		Chapter 14.  SQL Server Reporting Services (SSRS)
			Section 14.1.  Getting Started
			Section 14.2.  Integrating Reports into Applications
			Section 14.3.  Reporting Services Extensions
		Chapter 15.  SQL Server Integration Services (SSIS)
			Section 15.1.  Architecture
			Section 15.2.  Tools
			Section 15.3.  Programming SSIS
		Chapter 16.  SQL Server Agent
			Section 16.1.  Programming SQL Server Agent
		Chapter 17.  Service Broker
			Section 17.1.  Architecture
			Section 17.2.  Programming Service Broker
		Chapter 18.  Notification Services
			Section 18.1.  Architecture
			Section 18.2.  Creating a Notification Services Application
			Section 18.3.  Programming Notification Services
		Chapter 19.  Replication
			Section 19.1.  Programming Replication
		Chapter 20.  SQL Server Analysis Services (SSAS)
			Section 20.1.  Before You Begin
			Section 20.2.  SSAS Overview
			Section 20.3.  SSAS Database
			Section 20.4.  SSAS Languages
			Section 20.5.  Development
			Section 20.6.  Accessing Data by Using ADOMD.NET
			Section 20.7.  Administering SSAS Objects
		Chapter 21.  SQL Server Mobile Edition
			Section 21.1.  Environments
			Section 21.2.  Prerequisites
			Section 21.3.  Programming SQL Server Mobile
		Appendix A.  ADO.NET 2.0
			Section A.1.  Data Provider Enumeration and Factories
			Section A.2.  Data Provider Enhancements
			Section A.3.  Disconnected Class Enhancements
		About the Author
		Colophon
		Index