Share via


SQL Server 2005: CLR Integration

Samples, tips and tricks, insights from the CLR Integration team at SQL Server.

Today we’ll look at an example where sgen did not solve the problem with a dynamically loaded...

Date: 11/06/2006

Simple question: what security permission level is required to allow dynamic loading of assemblies?...

Date: 10/18/2006

Usually, talking about the differences between running code under the CLR vs. running under SQL CLR...

Date: 07/25/2006

There have been some questions about the sysadmin requirement of SQL Server 2005 Debugging, and I’d...

Date: 07/07/2006

Naveen covered the TSQL exception handling in his posts on sqlprogrammability blog site. How does...

Date: 06/29/2006

SQL Server 2005 ships with a new debugging engine that supports debugging of any T-SQL and CLR code...

Date: 06/29/2006

Very often, you may wish to factor out your code into separate assemblies in your application. For...

Date: 06/22/2006

In part 1 we created a nice user defined aggregate. Now we are going to make it more sophisticated...

Date: 06/22/2006

When the user code will try to access a resource outside of the SQL server it will run in the...

Date: 06/17/2006

Assembly redirection is not supported in SQL CLR. Assembly redirection can be done using publisher,...

Date: 06/17/2006

This is a sample on how to register satellite assemblies in SQL Server 2005. Based on the...

Date: 06/13/2006

As we saw in the last post, cooperative clr code that explicitly yields during long-running...

Date: 04/14/2006

Perhaps you've seen the following note in BOL advising SQLCLR users to explicitly yield in their...

Date: 04/10/2006

There are two important memory considerations you may want to track when using SQL CLR...

Date: 03/24/2006

Perhaps you’ve heard all about the power and flexibility .NET framework integration provides in Sql...

Date: 03/14/2006

The required cases for execute permission on UDFs and UDPs are pretty understandable, however the...

Date: 03/06/2006

From the query I described yesterday, here are the different possible appdomain states and what they...

Date: 02/22/2006

The dmv sys.dm_clr_appdomains is a great way to find information about the appdomains currently...

Date: 02/21/2006

Using a CLR trigger we can register all user defined functions, procedures, types, aggregates etc.,...

Date: 11/21/2005

This code is provided "AS IS" with no warranties, and confers no rights. I've made some small...

Date: 11/21/2005

SQL Server provides the ability to find the week of the year in which a given date lies. For...

Date: 11/11/2005

Some people peeked (and poked) under the covers and have been surprised at how SQL Server is...

Date: 10/17/2005

Restrictive world of SqlClr computed columns and indexability With Yukon entering the world of...

Date: 10/03/2005

Last time we saw an example of using a powerful functionality, Regular Expressions, from a supported...

Date: 07/25/2005

One of the many benefits of using CLR Integration in your database applications is the availability...

Date: 06/29/2005

When using CLR UDTs, there has been some confusion regarding the difference between the T-SQL IS...

Date: 06/21/2005

Introduction Writing locale-safe external code in SQL Server has always been important due to the...

Date: 06/15/2005

In my previous BLOG entry dated May 5th, I promised another sample that retrieves multiple files...

Date: 05/20/2005

Let's say we have a very simple (and silly) CLR UDT defined and loaded into SQL Server named CLRInt,...

Date: 05/11/2005

In this article, we will discuss a sample CLR function that illustrates accessing an external...

Date: 05/05/2005

We hope to use this blog to communicate with the SQL Server user community on the CLR Integration...

Date: 05/04/2005