Microsoft SQL Server 2005 Developer's Guide

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780072260991 | 0072260998
Cover: Paperback
Copyright: 12/28/2005

Buy New

In Stock Usually Ships in 24-48 Hours

$55.70
eBook

Available Instantly

Online: 1825 Days

Downloadable: Lifetime Access

$52.20

Developers will discover how to unleash the full power of Microsoft SQL Server 2005 with this developer's guide by best-selling author, Michael Otey. Completely rewritten and reengineered, this book will focus on the new programming models and will provide readers with all the information they need to produce top-quality commercial applications. Covers all of the new upgrades Includes real-world examples All executable applications and their source code will be available free online

Acknowledgments

xiii

Introduction

xiv

The Development Environment

(20)

SQL Server Management Studio

(12)

The SQL Server Management Studio User Interface

(1)

SQL Server Management Studio User Interface Windows

(10)

SQL Server 2005 Administrative Tools

(1)

BI Development Studio

(6)

The Business Intelligence Development Studio User Interface

(1)

BI Development Studio User Interface Windows

(4)

Summary

(1)

Developing with T-SQL

(56)

T-SQL Development Tools

(12)

SQL Server Management Studio

(5)

Visual Studio 2005

(7)

Creating Database Objects Using T-SQL DDL

(15)

Databases

(1)

Tables

(4)

Views

(1)

Synonyms

(1)

Stored Procedures

(2)

Functions

(2)

Triggers

(1)

Security

(2)

Storage for Searching

(1)

Querying and Updating with T-SQL DML

(26)

Select and Joins

(16)

Modifying Data

(9)

Error Handling

(1)

Summary

(2)

Developing CLR Database Objects

(40)

Understanding CLR and SQL Server 2005 Database Engine

(5)

CLR Architecture

(1)

Enabling CLR Support

(1)

CLR Database Object Components

(3)

Creating CLR Database Objects

(27)

CLR Stored Procedures

(7)

User-Defined Functions

(4)

Triggers

(5)

User-Defined Types

(6)

Aggregates

105

(5)

Debugging CLR Database Objects

110

(5)

.NET Database Object Security

112

(3)

Managing CLR Database Objects

115

(1)

Summary

115

(2)

SQL Server Service Broker

117

(18)

SQL Server Service Broker Architecture

118

(4)

Messages

119

(1)

Queues

120

(1)

Contracts

120

(1)

Services

120

(1)

Dialogs

120

(2)

Developing SQL Service Broker Applications

122

(9)

SQL Server Service Broker DDL and DML

122

(1)

T-SQL DDL

122

(1)

T-SQL DML

122

(1)

Enabling SQL Server Broker

122

(2)

Using Queues

124

(1)

Sample SQL Server Service Broker Application

125

(6)

SQL Server Service Broker Activation

131

(1)

Dialog Security

132

(1)

System Views

132

(1)

Summary

133

(2)

Developing with Notification Services

135

(34)

Notification Services Overview

136

(3)

Events

136

(2)

Subscriptions

138

(1)

Notifications

138

(1)

Developing Notification Services Applications

139

(1)

Defining the Application

139

(1)

Compiling the Application

139

(1)

Building the Notification Subscription Management Application

140

(1)

Adding Custom Components

140

(1)

Notification Services Application Sample

140

(17)

Creating the ICF File

140

(4)

Defining the ADF File

144

(8)

Building the Notification Services Application

152

(5)

Updating Notification Services Applications

157

(1)

Building a .NET Subscription/Event Application

158

(9)

Listing Subscriptions

159

(1)

Adding Subscriptions

160

(3)

Deleting Subscriptions

163

(1)

Firing the Data Event Using .NET

163

(3)

Firing the Data Event Using T-SQL

166

(1)

Summary

167

(2)

Developing Database Applications with ADO.NET

169

(52)

The ADO.NET Architecture

170

(2)

ADO.NET Namespaces

172

(1)

.NET Data Providers

172

(5)

Namespaces for the .NET Data Providers

173

(2)

Core Classes for the .NET Data Providers

175

(2)

Core Classes in the ADO.NET System.Data Namespace

177

(5)

DataSet

178

(1)

DataTable

178

(1)

DataColumn

179

(1)

DataRow

180

(1)

DataView

180

(1)

DataViewManager

180

(1)

DataRelation

181

(1)

Constraint

181

(1)

ForeignKeyConstraint

181

(1)

UniqueConstraint

181

(1)

DataException

182

(1)

Using the .NET Framework Data Provider for SQL Server

182

(1)

Adding the System.Data.SqlClient Namespace

182

(1)

Using the SqlConnection Object

183

(7)

The .NET Framework Data Provider for SQL Server Connection String Keywords

184

(2)

Opening a Trusted Connection

186

(1)

Using Connection Pooling

187

(3)

Using the SqlCommand Object

190

(11)

Executing Dynamic SQL Statements

191

(2)

Executing Parameterized SQL Statements

193

(3)

Executing Stored Procedures with Return Values

196

(2)

Executing Transactions

198

(3)

Using the SqlDependency Object

201

(3)

Using the SqlDataReader Object

204

(11)

Retrieving a Fast Forward--Only Result Set

205

(3)

Reading Schema-Only Information

208

(1)

Asynchronous Support

209

(1)

Multiple Active Result Sets (MARS)

210

(2)

Retrieving BLOB Data

212

(3)

Using the SqlDataAdapter Object

215

(5)

Populating the DataSet

215

(1)

Using the CommandBuilder Class

216

(4)

Summary

220

(1)

Developing with XML

221

(34)

The XML Data Type

222

(5)

Data Validation Using an XSD Schema

223

(4)

XQuery Support

227

(4)

Querying Element Data

228

(3)

XML Data Type Methods

231

(4)

Exist(XQuery)

231

(1)

Modify(XML DML)

232

(1)

Query(XQuery)

233

(1)

Value(XQuery, [node ref])

234

(1)

XML Indexes

235

(1)

Primary XML Indexes

235

(1)

Secondary XML Indexes

235

(1)

Using the For XML Clause

236

(8)

For XML Raw

236

(1)

For XML Auto

237

(1)

For XML Explicit

237

(2)

Type Mode

239

(1)

For XML Path

240

(2)

Nested For XML Queries

242

(1)

Inline XSD Schema Generation

242

(2)

OPENXML

244

(1)

XML Bulk Load

245

(2)

Native HTTP SOAP Access

247

(6)

Creating SOAP Endpoints

247

(2)

Using SOAP Endpoints

249

(4)

Summary

253

(2)

Developing Database Applications with ADO

255

(70)

An Overview of OLE DB

256

(1)

OLE DB Architecture Overview

256

(2)

ADO (ActiveX Data Objects)

258

(2)

OLE DB and ADO Files

260

(1)

ADO Architecture

260

(3)

An Overview of Using ADO

262

(1)

Adding the ADO Reference to Visual Basic

263

(1)

Using ADO Objects with Visual Basic

264

(56)

Connecting to SQL Server

265

(16)

Retrieving Data with the ADO Recordset

281

(24)

Executing Dynamic SQL with the ADO Connection Object

305

(2)

Modifying Data with ADO

307

(9)

Executing Stored Procedures with Command Objects

316

(2)

Error Handling

318

(2)

Advanced Database Functions Using ADO

320

(4)

Batch Updates

320

(2)

Using Transactions

322

(2)

Summary

324

(1)

Reporting Services

325

(48)

Reporting Services Architecture

326

(10)

Reporting Services Components

327

(2)

Installing Reporting Services

329

(7)

Report Server

336

(4)

Report Server Processors

337

(1)

Report Server Extensions

338

(2)

Report Manager

340

(1)

Reporting Services Configuration and Management Tools

341

(7)

Reporting Services Configuration Tool

342

(2)

Report Server Command-Prompt Utilities

344

(4)

Report Authoring Tools

348

(11)

Report Designer

348

(5)

Report Model Designer

353

(4)

Report Builder

357

(2)

Programmability

359

(3)

Using URL Access in a Window Form

359

(2)

Integrating Reporting Services Using SOAP

361

(1)

Extensions

361

(1)

RDL

362

(1)

Accessing Reports

362

(1)

Using URL Access

362

(1)

URL Access Through a Form POST Method

363

(1)

Report Authoring

363

(8)

Development Stages

363

(1)

Creating a Reporting Services Report

364

(5)

Deploying a Reporting Services Report

369

(1)

Running a Reporting Services Report

369

(2)

Summary

371

(2)

SQL Server Integration Services

373

(42)

An Overview of SQL Server Integration Services

374

(3)

Data Transformation Pipeline (DTP)

375

(1)

Data Transformation Runtime (DTR)

376

(1)

Creating Packages

377

(22)

Using the SSIS Import and Export Wizard

377

(1)

Using the SSIS Designer

378

(17)

Using Breakpoints

395

(2)

Using Checkpoints

397

(1)

Using Transactions

398

(1)

Package Security

399

(1)

Deploying Packages

399

(5)

Creating Configurations

400

(3)

Using the Package Deployment Utility

403

(1)

Programming with the SQL Server Integration Services APIs

404

(8)

Summary

412

(3)

Developing BI Applications with ADOMD.NET

415

(24)

Analysis Services Overview

416

(5)

XML for Analysis

417

(1)

Analysis Management Objects (AMO) Overview

417

(1)

ADOMD.NET Overview

418

(1)

AMO Hierarchy

418

(1)

ADOMD.NET Object Model

419

(2)

Building a BI Application with ADOMD.NET

421

(16)

Adding a Reference for ADOMD.NET

422

(1)

Using the AdomdConnection Object

423

(4)

Using the AdomdCommand Object

427

(7)

Using the AdomdDataAdapter Object

434

(2)

Using the CubeDef Object

436

(1)

Summary

437

(2)

Developing with SMO

439

(38)

Using SMO

440

(9)

Adding SMO Objects to Visual Studio

441

(1)

Creating the Server Object

442

(2)

Using SMO Properties

444

(1)

SMO Property Collections

445

(4)

SMO Hierarchy

449

(10)

Building the SMO Sample Application

459

(16)

Creating the Server Object

460

(1)

Listing the Registered SQL Systems

461

(1)

Connecting to the Selected SQL Server System

461

(2)

Listing Databases

463

(1)

Listing Tables

464

(1)

Listing Columns

465

(2)

Retrieving Column Attributes

467

(1)

Creating Databases

468

(1)

Transferring Tables

469

(3)

Showing T-SQL Script for Tables

472

(2)

SMO Error Handling

474

(1)

Summary

475

(2)

Using sqlcmd

477

(14)

sqlcmd Components

478

(7)

Command Shell

478

(1)

Command-Line Parameters

479

(5)

sqlcmd Extended Commands

484

(1)

sqlcmd Variables

484

(1)

Developing sqlcmd Scripts

485

(5)

Developing sqlcmd Scripts with Query Editor

485

(2)

Using sqlcmd Variables

487

(1)

Using sqlcmd Script Nesting

488

(1)

Using sqlcmd Variables and T-SQL Statements

489

(1)

Summary

490

(1)

Appendix SQL Profiler

491

(10)

Starting SQL Profiler

491

(5)

Starting, Pausing, and Stopping a Trace

496

(1)

Replaying a Trace

497

(1)

Showplan Events

497

(4)

Index

501

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Microsoft SQL Server 2005 Developer's Guide

Summary

Author Biography

Table of Contents

Supplemental Materials