How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...

Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables  Read more...

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...

Learn how to build a CLR function that can be used to perform string manipulations that might be rather complex in T-SQL.  Read more...

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing  Read more...

Only the brave, and foolhardy, write production CLR routines if you can get the functionality already-written and tested. Whether you’re a DBA or developer, there are plenty of times when a CLR routine will save a lot of time, and occasionally provide new functionality.  Read more...

Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.  Read more...

How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available  Read more...

A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser  Read more...

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...

It is recommended that you remove all special characters and HTML formatting. This task can be handled in TSQL code, however in this case I have the opportunity to use .NET and the power of the regular expressions to manage the string. In this tip, I'll build a CLR function which cleans up a string of HTML tags and special characters. I'll use Visual Studio 2010 with C# as the programming language. Check out this tip for my solution.  Read more...

Learn to use SQLCLR, parallelism and how to write better performing SQL code from MVP Adam Machanic in New York City on July 14-15. Early bird discounts available with the code "EARLYBIRD".  Read more...

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...

Learn to use SQLCLR, parallelism and how to write better performing SQL code from MVP Adam Machanic in New York City on July 14-15. Early bird discounts available with the code "EARLYBIRD".  Read more...

Learn to use SQLCLR, parallelism and how to write better performing SQL code from MVP Adam Machanic in New York City on July 14-15. Early bird discounts available with the code "EARLYBIRD".  Read more...

Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.  Read more...

Learn how to use SQLCLR to get file system information instead of using xp_cmdshell on your SQL Servers.  Read more...

You are a database developer looking for a common approach for handling read and write access to binary files. You may be a DBA wanting to read various information from binary files and collect it into tables. The code sample presented in this tip will get you started with binary file content handling in SQL Server.  Read more...

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.   Read more...