|
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. It guides you through all the new
features, explaining how they work and how to use them. The
first half of the book examines the changes and new features
of the SQL Server Engine itself. The second addresses the
enhanced features and tools of the platform, including the
new services blended into this popular version. Each
chapter contains numerous code samples-written in C# and
compiled using the Visual Studio 2005 development
environment-that show you exactly how to program SQL Server
2005.
Programming SQL Server 2005 can help you:
Build, deploy, and manage enterprise applications that are
more secure, scalable, and reliable
Maximize IT productivity by reducing the complexity of
building, deploying, and managing database applications
Share data across multiple platforms, applications, and
devices to make it easier to connect internal and external
systems
Because the goal of Programming SQL Server 2005 is to
introduce all facets of Programming SQL Server 2005, it's
beneficial to programmers of all levels. The book can be
used as a primer by developers with little experience with
SQL Server, as a ramp up to the new programming models for
SQL Server 2005 for more experienced programmers, or as
background and primer to specific concepts.
Any IT professional who wants to learn about SQL Server
2005's comprehensive feature set, interoperability with
existing systems, and automation of routine tasks will find
the answers in this authoritative guide.
Preface
1. Introduction
Contents of This Book
What's Not in This Book
2. Tools and Utilities
SQL Server Management Studio
SQL Server Configuration Manager
SQL Server Surface Area Configuration
Database Engine Tuning Advisor
SQL Server Profiler
SQL Server Business Intelligence Development Studio
Visual Studio 2005
New Command-Line Utilities
3. T-SQL Enhancements
New Data Types
T-SQL Language Enhancements
Data Definition Language (DDL) Triggers
Metadata
4. Introduction to Common Language Runtime (CLR) Integration
CLR Integration Design Objectives
Enabling CLR Integration
Required .NET Namespaces
Types of CLR Routines
Hello World Example
DDL Support for CLR Integration
ADO.NET In-Process Extensions Supporting CLR Programming
Custom Attributes for CLR Routines
SQL Server Data Types in the .NET Framework
Testing and Debugging CLR Routines
5. Programming SQL Server CLR Routines
Scalar-Valued Functions
Table-Valued Functions
Stored Procedures
User-Defined Aggregate Functions
User-Defined Types
Triggers
6. .NET Client-Side Programming
SQL Native Client Programming
SQLXML 4.0
Exception Message Box
7. XML Data
xml Data Type
Creating xml Data Type Instances
XML Data Type Methods
Viewing XML Data as Relational Data
Indexing XML Data
Managing XML Schema Collections
XQuery Support
XML Data Manipulation Language
XML Results Using the FOR XML Clause
XML Catalog Views
8. Native XML Web Services
Open Standards
Creating a Web Service
Creating the HTTP Endpoint and Exposing a Web Method Example
SOAP Request and Response Messages
Managing HTTP Endpoints
9. SQL Server Management Objects (SMO)
SMO Object Model
Creating an SMO Project in Visual Studio .NET
A Simple SMO Application
10. SQL Server Management Objects (SMO) Instance Classes, Part 1
Programming SMO Instance Classes for AdministeringData Storage Objects
SMO Instance Classes for Administering Data Storage Objects Reference
11. SQL Server Management Objects (SMO) Instance Classes, Part 2
Programming SMO Instance Classes for AdministeringDatabase Objects Not Used for Data Storage
SMO Instance Classes for Administering Objects Not Usedfor Data Storage Reference
12. SQL Server Management Objects (SMO) Utility Classes
Scripting
Backing Up and Restoring Data
Transferring Data
Tracing
Database Mail
13. Programming Windows Management Instrumentation (WMI)
Programming SMO WMI Classes
14. SQL Server Reporting Services (SSRS)
Getting Started
Integrating Reports into Applications
Reporting Services Extensions
15. SQL Server Integration Services (SSIS)
Architecture
Tools
Programming SSIS
16. SQL Server Agent
Programming SQL Server Agent
17. Service Broker
Architecture
Programming Service Broker
18. Notification Services
Architecture
Creating a Notification Services Application
Programming Notification Services
19. Replication
Programming Replication
20. SQL Server Analysis Services (SSAS)
Before You Begin
SSAS Overview
SSAS Database
SSAS Languages
Development
Accessing Data by Using ADOMD.NET
Administering SSAS Objects
21. SQL Server Mobile Edition
Environments
Prerequisites
Programming SQL Server Mobile
Appendix: ADO.NET 2.0
Index
|
