Book description
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.
Publisher resources
Table of contents
- A Note Regarding Supplemental Files
- Preface
- 1. Introduction
- 2. Tools and Utilities
- 3. T-SQL Enhancements
-
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
- 6. .NET Client-Side Programming
- 7. XML Data
-
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)
- 10. SQL Server Management Objects (SMO) Instance Classes, Part 1
-
11. SQL Server Management Objects (SMO) Instance Classes, Part 2
- Programming SMO Instance Classes for Administering Database Objects Not Used for Data Storage
-
SMO Instance Classes for Administering Objects Not Used for Data Storage Reference
- Server Configuration
- Registered Servers
- Linked Servers
- Database Defaults
- Files and Filegroups
- Partition Functions
- Partition Schemes
- Logins
- Users
- Server Roles
- Database Roles
- Server Permissions
- Database Permissions
- Application Roles
- .NET Framework Assemblies
- Endpoints
- XML Schemas
- Languages
- Statistics
- Certificates
- Credentials
- Keys
- Synonyms
- System Messages
- User-Defined Messages
- Full-Text Search
- OLE DB Providers
- 12. SQL Server Management Objects (SMO) Utility Classes
- 13. Programming Windows Management Instrumentation (WMI)
- 14. SQL Server Reporting Services (SSRS)
- 15. SQL Server Integration Services (SSIS)
- 16. SQL Server Agent
- 17. Service Broker
-
18. Notification Services
- Architecture
- Creating a Notification Services Application
-
Programming Notification Services
- Creating a Notification Services Application and Service
- Creating a Notification Services Instance and Application
- Creating a Delivery Channel
- Creating an Event Class
- Creating a Subscription Class and Subscription Event Rule
- Creating a Notification Class, Content Formatter, and Notification Class Protocol
- Creating an Event Provider
- Creating a Generator
- Creating a Distributor
- Creating a Vacuum Schedule
- Creating a Subscriber and Subscriber Device
- Creating a Subscription
- Enumerating a Notification Services Instance Database
- Enumerating a Notification Services Application Database
-
19. Replication
-
Programming Replication
- Prerequisites
- Installing a Distributor
- Creating a Publisher
- Enabling a Database for Publication
- Creating a Publication
- Creating an Article
- Enumerating Items Available for Replication
- Filtering an Article
- Registering a Subscriber
- Creating a Subscription
- Generating the Initial Snapshot
- Synchronizing a Subscription to an Initial Snapshot
- Retrieving Agent History
- Specifying a Replication Schedule
- Validating Subscriber Data
- Monitoring Replication
- Business Logic Handlers
-
Programming Replication
- 20. SQL Server Analysis Services (SSAS)
- 21. SQL Server Mobile Edition
-
A. ADO.NET 2.0
- Data Provider Enumeration and Factories
-
Data Provider Enhancements
- Asynchronous Processing
- Support for SQL Server Notifications
- Multiple Active Result Sets
- Bulk Copy
- Support for New SQL Server Large-Value Data Types
- Support for SQL Server User-Defined Types
- Support for Snapshot Isolation in Transactions
- Database Mirroring Support
- Server Enumeration
- Support for Retrieving Provider Statistics in SQL Server 2005
- Change Password Support
- Schema Discovery
- Disconnected Class Enhancements
- Index
- About the Author
- Colophon
- Copyright
Product information
- Title: Programming SQL Server 2005
- Author(s):
- Release date: February 2006
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596004798
You might also like
book
Professional Microsoft® SQL Server® 2008 Programming
Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the …
book
A Developer’s Guide to SQL Server 2005
"I come from a T-SQL background, so when I first laid my eyes on SQL Server …
book
SQL Server 2005 Distilled
Need to get your arms around Microsoft SQL Server 2005 fast, without getting buried in the …
book
Microsoft® SQL Server® 2008 Internals
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team …