Programming Sql Server 2005

by Hamilton, Bill

• ISBN13: 9780596004798
• ISBN10: 0596004796
• Format: Paperback
• Copyright: 2006-03-01
• Publisher: Oreilly & Associates Inc

Summary

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.

Author Biography

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.

Table of Contents

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