SQL Server 2005: CLR Integration
Samples, tips and tricks, insights from the CLR Integration team at SQL Server.
Dynamic Assembly Loading II: SGen and System Defined Classes
Today we’ll look at an example where sgen did not solve the problem with a dynamically loaded...
Date: 11/06/2006
Dynamic Assembly Loading
Simple question: what security permission level is required to allow dynamic loading of assemblies?...
Date: 10/18/2006
Deadlock Detection in SQL CLR
Usually, talking about the differences between running code under the CLR vs. running under SQL CLR...
Date: 07/25/2006
SQL Server 2005 Debugging Requirements
There have been some questions about the sysadmin requirement of SQL Server 2005 Debugging, and I’d...
Date: 07/07/2006
Exception handling in SQLCLR
Naveen covered the TSQL exception handling in his posts on sqlprogrammability blog site. How does...
Date: 06/29/2006
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...
Date: 06/29/2006
Strong named assemblies and AllowPartiallyTrustedCallers
Very often, you may wish to factor out your code into separate assemblies in your application. For...
Date: 06/22/2006
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...
Date: 06/22/2006
Impersonation in SQL CLR
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 and CLR Integration
Assembly redirection is not supported in SQL CLR. Assembly redirection can be done using publisher,...
Date: 06/17/2006
Satellite assemblies in SQL Server 2005
This is a sample on how to register satellite assemblies in SQL Server 2005. Based on the...
Date: 06/13/2006
How to tell if your code should be yielding
As we saw in the last post, cooperative clr code that explicitly yields during long-running...
Date: 04/14/2006
Who says tough guys never yield?
Perhaps you've seen the following note in BOL advising SQLCLR users to explicitly yield in their...
Date: 04/10/2006
Memory Usage in SQL CLR
There are two important memory considerations you may want to track when using SQL CLR...
Date: 03/24/2006
Now THAT's a Sample!
Perhaps you’ve heard all about the power and flexibility .NET framework integration provides in Sql...
Date: 03/14/2006
UDT Execute Permission
The required cases for execute permission on UDFs and UDPs are pretty understandable, however the...
Date: 03/06/2006
I found my appdomain, now what?
From the query I described yesterday, here are the different possible appdomain states and what they...
Date: 02/22/2006
It’s 3 AM. Do you know where your appdomain is?
The dmv sys.dm_clr_appdomains is a great way to find information about the appdomains currently...
Date: 02/21/2006
CLR Trigger for Automatic Registration of UDXs on CREATE ASSEMBLY
Using a CLR trigger we can register all user defined functions, procedures, types, aggregates etc.,...
Date: 11/21/2005
CLR Trigger for Automatic Registration of UDXs on CREATE ASSEMBLY
This code is provided "AS IS" with no warranties, and confers no rights. I've made some small...
Date: 11/21/2005
Best Week Ever
SQL Server provides the ability to find the week of the year in which a given date lies. For...
Date: 11/11/2005
Serialization and Ordering: An Integral Example
Some people peeked (and poked) under the covers and have been surprised at how SQL Server is...
Date: 10/17/2005
Tutorial on SqlClr Computed Columns and Indexability
Restrictive world of SqlClr computed columns and indexability With Yukon entering the world of...
Date: 10/03/2005
Using Webservices and Xml Serialization in CLR Integration
Last time we saw an example of using a powerful functionality, Regular Expressions, from a supported...
Date: 07/25/2005
Working with Regular Expressions
One of the many benefits of using CLR Integration in your database applications is the availability...
Date: 06/29/2005
IS NULL vs. IsNull
When using CLR UDTs, there has been some confusion regarding the difference between the T-SQL IS...
Date: 06/21/2005
Locales in SQL Server
Introduction Writing locale-safe external code in SQL Server has always been important due to the...
Date: 06/15/2005
Yet another TVF: returning files from a directory
In my previous BLOG entry dated May 5th, I promised another sample that retrieves multiple files...
Date: 05/20/2005
An Enigmatic Error while Returning UDT Results
Let's say we have a very simple (and silly) CLR UDT defined and loaded into SQL Server named CLRInt,...
Date: 05/11/2005
File Access and table-valued functions
In this article, we will discuss a sample CLR function that illustrates accessing an external...
Date: 05/05/2005
Welcome to the SQL-CLR blog
We hope to use this blog to communicate with the SQL Server user community on the CLR Integration...
Date: 05/04/2005