Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates, and Types

SQL Server 2005 offers the capability to write code in a 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 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 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 namespaces in SQL Server programming tasks
How to develop and benchmark routines in T-SQL and 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 concepts as well as DBAs who, although developers in their own right, may be slightly less up to date on . A solid grounding in T-SQL is necessary.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Share your thoughts on the Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates, and Types ebook with other internet viewers!

Title of ebook: Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates, and Types
ISBN: 9780470121061
parent-ISBN: 9780470054031
Publisher: Wrox
Internet download file size: 6317 kb
Pages: 432
Published: 02-2007
Released online for download: 02-03-2007
Author of eBook: Comingore, Derek
Author of eBook: Hinson, Douglas

Format

Encrypted

Sku

ISBN

File size

Security

Printing

Copying

Read aloud

Devices

Digital Editions

Yes

0470121068

9780470121061

6317 KB

n/a

Not allowed

15 selections to your clipboard every 365 days

Sys Requirments

Download reader

Professional SQL Server 2005 CLR Programming

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

Chapter One

Introducing SQL CLR

SQL Server's .NET integration is arguably the most important feature of SQL Server 2005 for developers. Developers can now move their existing .NET objects closer to the database with SQL CLR. SQL CLR provides an optimized environment for procedural- and processing-intensive tasks that can be run in the SQL Server tier of your software's architecture. Also, database administrators need a strong knowledge of SQL CLR to assist them in making key administrative decisions regarding it. If you ignore SQL CLR, you're missing out on the full potential SQL Server 2005 can offer you and your organization, thus limiting your effectiveness with the product.

SQL CLR is a very hot topic in the technical communities but also one that is frequently misunderstood. Unquestionably, there will be additional work devoted to SQL CLR from Microsoft and Paul Flessner (Microsoft's sen ... read full excerpt from Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates, and Types ebook

Other Computers eBooks Categories

Computers General (1564)

Artificial Intelligence (34)

Business Software (633)

Certification (341)

Computer Graphics (1059)

Computer Science (38)

Data Transmission Sys (106)

Database Mgmt (713)

Electronic Commerce (85)

Electronic Publishing (260)

Hardware (530)

Information Technology (165)

Internet (868)

Security (62)

Web Site Design (299)

Miscellaneous Software (40)

Networking (882)

Operating Sys (910)

Programming (2452)

Reference (212)

Security (197)

Top eBooks in Database Mgmt

Advanced Computer Architecture and Parallel Processing
by EL-Rewini, Hesham / Abd-El-Barr, Mostafa

Computer architecture deals with the physical configuration, logical structure, formats, protocols, and operational sequences for processing data, controlling ...more

Best price: $117.84

Biometrics
by Woodward, John D., Jr.

Discover how to make biometrics -- the technology involving scanning and analyzing unique body characteristics and matching them against information stored in a...more

Best price: $43.13

Data Mining Methods and Models
by Larose, Daniel T.

Provides an introduction into data mining methods and models, including association rules, clustering, K-nearest neighbor, statistical inference, neural ...more

Best price: $100.99

Components of a Canonical Data Model
by Dunn, Lawrence

White Paper Abstract There is much discussion on the needs and benefits of a canonical data model to support an SOA initiative. However, many Data Management ...more

Best price: $2.56

Access 2007 Bible
by Groh, Michael R. / Stockman, Joseph C. / Powell, Gavin

"I recommend this book for anyone who wants a strong foundation in Access."
—Jeff Lenamon, CIBC World MarketsUpdated edition with exciting new ...more

Best price: $43.13

Beginning MySQL
by Sheldon, Robert / Moes, Geoff

* Provides programmers with a complete foundation in MySQL, the multi-user, multi-threaded SQL database server that easily stores, updates, and accesses ...more

Best price: $34.50

SQL Server 2005 Distilled

Customer review:
The books provide in depth coverage of various sql server 2005 features.The various features of sql server 2005 are explained thoroughly with relavant real time examples. PLease go...more

Best price: $26.66

Microsoft SQL Server 2005 Express Edition For Dummies

Customer review:
This book delivers even more than I expected. I needed a little extra clarification on this SQL product to be able to use it properly. The examples are right on target and some are...more

Best price: $22.06

Microsoft SQL Server 2005 Notification Services

Customer review:
IT's really a good book for my career.XXXX....XXXXXXXXXXXX....XXXXX.....XXXXXXXXXXXXX.XXXXXXXXXXXX...XXXXX.XXXXXXXXXXXXXXXXXXXXXXXXXXXXX...more

Best price: $41.40