Pro SQL Server 2005 Assemblies [Paperback]

* First book on the market to show how to effectively exploit the new .NET capabilities of the SQL Server 2005 database.

* Broad audience, with strong appeal to SQL Server developers as well as to VB.NET and C# programmers.

* Provides a detailed and example-driven tutorial on how to build and use .NET assemblies. Shows not only what you can do with assemblies, but what you should, and should not, do.

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.

1. Introducing Assemblies
2. Writing a Simple SQL Assembly
3. The SQL Server .NET Programming Model
4. CLR Stored Procedures
5. User-Defined Functions
6. User-Defined Types
7. User-Defined Aggregates
8. CLR Triggers
9. Error Handling and Debugging Strategies
10. Security
11. Integrating Assemblies with Other Technologies

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his ownl“Æ