Professional SQL Server 2005 CLR Programming

With Stored Procedures, Functions, Triggers, Aggregates, and Types

Derek Comingore, Douglas Hinson - Collection Programmer to Programmer

410 pages, parution le 19/12/2006

Ajouter à une liste

Indisponible

Résumé

SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language. You can read and write to resources outside of SQL Server and enjoy a tighter integration with XML, web services, and simple file and logging capabilities.

Here's the reference you'll want on your desk as you develop SQL CLR solutions. It helps you decide whether to use SQL CLR, how to lock down security, and learn from real examples. If you want to develop stored procedures or other objects in .NET for SQL Server 2005, this book offers exactly what you need.

What you will learn from this book

The concepts and architecture of SQL CLR
Uses of .NET namespaces in SQL Server programming tasks
How to develop and benchmark routines in T-SQL and .NET to determine when CLR-based solutions are advantageous
How to replace extended stored procedures using SQL CLR stored procedures
How to use SQL CLR objects in external applications
How to restrict and secure SQL CLR object capabilities
Processes and procedures for deploying SQL CLR objects

Who this book is for

This book is for developers and architects who are familiar with .NET concepts as well as DBAs who, although developers in their own right, may be slightly less up to date on .NET. A solid grounding in T-SQL is necessary.

L'auteur - Derek Comingore

Derek Comingore is the software development manager for Hosting.com. He holds the MCAD/MCDBA Microsoft certifications, the Carnegie Mellon Personal Software Process (PSP) credential, and an AAS/BS in Computer Information Systems. In addition to his role for Hosting.com, Derek enjoys writing articles for Hosting.com's newsletter and has written his first article for MSDN (soon to be published) on leveraging SQL Server 2005 Service Broker to obtain real-time ETL. He is also starting up a new SQL Server community, www.sqlserver360.org, which promises to deliver a rich and rewarding experience for the SQL Server professional.

Sommaire

Introducing SQL CLR
Your First CLR Stored Procedure
SQL CLR Structure and Common Tasks
Creating SQL CLR Objects
Comparing T-SQL with Managed Code
Replacing Extended Stored Procedures, Functions, and Other T-SQL Objects
The .NET Framework's Base Class Library
Using SQL CLR Stored Procedures in Your Applications Handling Errors in CLR Stored Procedures
CLR Administration and Security Case Study
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Derek Comingore, Douglas Hinson
Collection	Programmer to Programmer
Parution	19/12/2006
Nb. de pages	410
Format	18,5 x 23,5
Couverture	Broché
Poids	622g
Intérieur	Noir et Blanc
EAN13	9780470054031
ISBN13	978-0-470-05403-1