Pro SQL Server 2005 Assemblies free download online
Title: Pro SQL Server 2005 Assemblies Author(s): Robin Dewson, Julian Skinner Pages: 296 Publisher: Apress Publication date: 2005 Language: English Format: PDF ISBN-10: 1590595661 ISBN-13: Description: Pro SQL Server 2005 Assemblies provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download. Assemblies are not a complete replacement for T-SQL stored procedures and triggers; rather, they're enhancements, to be used at the right place and right time. This book examines the ins and outs of assemblies--when they should and should not be used, what you can do with them, and how you can get the most out of them.
The main aim of this book is to show you each of the different types of .NET assemblies now possible within SQL Server 2005. This is a major leap in technology for developers and database administrators alike. Knowing when, how, and why to use this technology is crucial in continuing to offer stable and efficient database servers and database solutions.
By the end of this book, you will not only be competent in building assemblies, but also know which assemblies are safe for your server, what expansions each can give your server, and how you can build and deploy your own assemblies.
The ability to run .NET code in the database is arguably the most exciting development in SQL Server for years. Traditionally, if T-SQL did not meet your needs, then you could write the required logic in either an external business object or an extended stored procedure. With the former, you could often generate unnecessary network traffic, and you also would lose the advantages associated with encapsulating data-centric logic in a single location (i.e., the database). The latter were complex to write and notorious for decreasing the stability of SQL Server.
In SQL Server 2005, which hosts the common language runtime (CLR), all this has changed. You can now write modules such as stored procedures, triggers, functions, and custom types in a .NET language instead of T-SQL. These modules have access to powerful .NET Framework classes, so they vastly extend the processing and formatting capabilities available through T-SQL. They also allow access to custom data sources for which there may not be an ODBC driver or OLE DB provider.
We hope you enjoy this book.
TABLE OF CONTENT
Chapter 01 - Introducing Assemblies
Chapter 02 - Writing a Simple SQL Assembly
Chapter 03 - The SQL Server .NET Programming Model
Chapter 04 - CLR Stored Procedures
Chapter 05 - User-Defined Functions
Chapter 06 - User-Defined Types
Chapter 07 - User-Defined Aggregates
Chapter 08 - CLR Triggers
Chapter 09 - Error Handling and Debugging Strategies
Chapter 10 - Security
Chapter 11 - Integrating Assemblies with Other Technologie
Pro SQL Server 2005 Assemblies free download links:
Title: Pro SQL Server 2005 Assemblies