Welcome to MSDN Blogs Sign in | Join | Help

June 2006 - Posts

Thursday, June 29, 2006 7:42 PM

Exception handling in SQLCLR

Naveen covered the TSQL exception handling in his posts on sqlprogrammability blog site. How does the TSQL exception handling mechanism interacts with SQLCLR exception handling mechanism? We will cover this topic in this post. When SQL server execute
Posted by sqlclr | 2 Comments
Thursday, June 29, 2006 7:39 PM

Overview of T-SQL and CLR debugging in SQL Server 2005

SQL Server 2005 ships with a new debugging engine that supports debugging of any T-SQL and CLR code running in the server, including batches, stored procedures, user defined functions/aggregates/triggers, etc. You can use Visual Studio 2005 to debug against
Posted by sqlclr | 15 Comments
Thursday, June 22, 2006 6:49 PM

Strong named assemblies and AllowPartiallyTrustedCallers

Very often, you may wish to factor out your code into separate assemblies in your application. For example, you separate your type in one assembly because it gets used by multiple areas in your application. And you save your proc that uses that type in
Posted by sqlclr | 1 Comments
Thursday, June 22, 2006 6:42 PM

Creating a CLR user define aggregate (part 2). Use multiple columns in the aggregation function

In part 1 we created a nice user defined aggregate. Now we are going to make it more sophisticated and let its value depend on two parameters ShipCountry and ShipShipCity. You might try having two parameters in Accumulate function of the aggregate but
Posted by sqlclr | 1 Comments

Attachment(s): ClrAggregates.zip
Thursday, June 22, 2006 6:40 PM

Creating a CLR user define aggregate (part 1). Simple CLR aggregate

SQL Server 2005 allows creating of User Defined Aggregate in any of the .NET languages such as C# or VB. For simple cases like SUM or MAX you probably want to use built-in aggregates, however there are cases where build-ins are insufficient. In such cases
Posted by sqlclr | 7 Comments
Friday, June 16, 2006 10:21 PM

Impersonation in SQL CLR

When the user code will try to access a resource outside of the SQL server it will run in the security context under which SQL Server is running. But this is not the ideal situation since it could become a security issue when the logged user that calls
Posted by sqlclr | 5 Comments
Friday, June 16, 2006 10:03 PM

Assembly redirection and CLR Integration

Assembly redirection is not supported in SQL CLR. Assembly redirection can be done using publisher, application configuration and machine configuration files. SQL Server 2005 uses application configuration to redirect assembly call after Alter Assembly.
Posted by sqlclr | 5 Comments
Tuesday, June 13, 2006 2:56 PM

Satellite assemblies in SQL Server 2005

This is a sample on how to register satellite assemblies in SQL Server 2005. Based on the CultureInfo on the executing thread, CLR will try to load the respective resource assembly. It should not be a difference between satellite assemblies inside and
Posted by sqlclr | 1 Comments
 
Page view tracker