Programming Sql Server 2005

SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on. Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product.

Bill Hamilton is the author of the highly praised ADO.NET Cookbook. He is an enterprise architect specializing in designing, developing and implementing enterprise applications using .NET and J2EE technologies. Over the last fifteen years, Bill has provided consulting services for B2B, B2C, B2E, enterprise application integration, portal initiatives, and custom application development for financial services, retail, professional services, and manufacturing clients. Bill is also the author of O'Reilly's NUnit Pocket Reference, the co-author of ADO.NET in a Nutshell, and also writes for Microsoft Developer Network.

Preface

ix

Introduction

1

(7)

Contents of This Book

3

(4)

What's Not in This Book

7

(1)

Tools and Utilities

8

(22)

SQL Server Management Studio

8

(16)

SQL Server Configuration Manager

24

(1)

SQL Server Surface Area Configuration

25

(1)

Database Engine Tuning Advisor

25

(1)

SQL Server Profiler

25

(1)

SQL Server Business Intelligence Development Studio

26

(1)

Visual Studio 2005

27

(1)

New Command-Line Utilities

28

(2)

T-SQL Enhancements

30

(28)

New Data Types

30

(2)

T-SQL Language Enhancements

32

(21)

Data Definition Language (DDL) Triggers

53

(4)

Metadata

57

(1)

Introduction to Common Language Runtime (CLR) Integration

58

(35)

CLR Integration Design Objectives

59

(2)

Enabling CLR Integration

61

(1)

Required .NET Namespaces

61

(1)

Types of CLR Routines

62

(1)

Hello World Example

62

(6)

DDL Support for CLR Integration

68

(19)

ADO.NET In-Process Extensions Supporting CLR Programming

87

(3)

Custom Attributes for CLR Routines

90

(1)

SQL Server Data Types in the .NET Framework

90

(2)

Testing and Debugging CLR Routines

92

(1)

Programming SQL Server CLR Routines

93

(35)

Scalar-Valued Functions

93

(3)

Table-Valued Functions

96

(4)

Stored Procedures

100

(6)

User-Defined Aggregate Functions

106

(3)

User-Defined Types

109

(8)

Triggers

117

(11)

.NET Client-Side Programming

128

(34)

SQL Native Client Programming

128

(2)

SQLXML 4.0

130

(26)

Exception Message Box

156

(6)

XML Data

162

(48)

xml Data Type

162

(5)

Creating xml Data Type Instances

167

(5)

XML Data Type Methods

172

(4)

Viewing XML Data as Relational Data

176

(4)

Indexing XML Data

180

(6)

Managing XML Schema Collections

186

(7)

XQuery Support

193

(4)

XML Data Manipulation Language

197

(4)

XML Results Using the FOR XML Clause

201

(7)

XML Catalog Views

208

(2)

Native XML Web Services

210

(24)

Open Standards

210

(1)

Creating a Web Service

211

(1)

Creating the HTTP Endpoint and Exposing a Web Method Example

211

(6)

SOAP Request and Response Messages

217

(1)

Managing HTTP Endpoints

218

(16)

SQL Server Management Objects (SMO)

234

(4)

SMO Object Model

235

(1)

Creating an SMO Project in Visual Studio .NET

236

(1)

A Simple SMO Application

237

(1)

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

238

(29)

Programming SMO Instance Classes for Administering Data Storage Objects

238

(17)

SMO Instance Classes for Administering Data Storage Objects Reference

255

(12)

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

267

(31)

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

267

(19)

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

286

(12)

SQL Server Management Objects (SMO) Utility Classes

298

(20)

Scripting

298

(7)

Backing Up and Restoring Data

305

(4)

Transferring Data

309

(2)

Tracing

311

(3)

Database Mail

314

(4)

Programming Windows Management Instrumentation (WMI)

318

(9)

Programming SMO WMI Classes

318

(9)

SQL Server Reporting Services (SSRS)

327

(16)

Getting Started

328

(1)

Integrating Reports into Applications

329

(13)

Reporting Services Extensions

342

(1)

SQL Server Integration Services (SSIS)

343

(32)

Architecture

343

(7)

Tools

350

(1)

Programming SSIS

351

(24)

SQL Server Agent

375

(13)

Programming SQL Server Agent

375

(13)

Service Broker

388

(14)

Architecture

388

(1)

Programming Service Broker

389

(13)

Notification Services

402

(39)

Architecture

402

(4)

Creating a Notification Services Application

406

(1)

Programming Notification Services

407

(34)

Replication

441

(37)

Programming Replication

442

(36)

SQL Server Analysis Services (SSAS)

478

(18)

Before You Begin

479

(1)

SSAS Overview

479

(1)

SSAS Database

480

(1)

SSAS Languages

480

(6)

Development

486

(1)

Accessing Data by Using ADOMD.NET

487

(6)

Administering SSAS Objects

493

(3)

SQL Server Mobile Edition

496

(13)

Environments

497

(1)

Prerequisites

497

(1)

Programming SQL Server Mobile

498

(11)

Appendix: ADO.NET 2.0

509

(36)

Index

545

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Programming Sql Server 2005

Summary

Author Biography

Table of Contents

Supplemental Materials