Run the script to get a list of all CLR objects in your database.
SELECT o.object_id AS [Object_ID]
,schema_name(o.schema_id) + '.' + o.[name] AS [CLRObjectName]
,o.type_desc AS [CLRType]
,o.create_date AS [Created]
,o.modify_date AS [Modified]
,a.permission_set_desc AS [CLRPermission]
,a.name [AssemblyName]
FROM sys.objects o
INNER JOIN sys.module_assembly_usages ma
ON o.object_id = ma.object_id
INNER JOIN sys.assemblies a
ON ma.assembly_id = a.assembly_id 
A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.
2011-06-23
10,656 reads
You need to generate random data directly into SQL Server table columns or close to the database engine as variables or expressions. Looking at the SQL Server available functions, you notice that only RAND function offers support for random data generation. Although RAND([seed]) is a built-in function, it can only return a float value between 0 and 1, and has other limitations in regards to seed values. Because your table columns may be of various data types, and each data type may have a lower value and an upper value, you would prefer to create your custom random data generators. This is when SQL Server CLR functions come into play and provide a viable solution.
2011-03-24
3,275 reads
Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.
2010-07-21
7,966 reads
When looking for impending problems due to lack of disk space it's necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR.
2010-04-27
3,390 reads
SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
2009-12-23
13,009 reads