Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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