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]
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
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.
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.
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.