Purpose

Reason for Creating this Project

1. No maintained opensource SQLCLR libraries on web. I personally plan on living forever, and I really enjoy working on this project because it makes my DBA life much easier.
2. Only a pay library, SQLSharp or SQL#. $500 a seat, and no recent updates. Has SQLCLR fallen out of favor. Probably, but it works for me.
3. SQL Server adds utility functions at a rate of about 1 to 2 a major release. I recall STRING_SPLIT and now STRING_AGG being added, and those are great, but it's too slow.
4. SQLCLR is backwards compatible fairly far, whereas STRING_AGG is not going to be available on 2012.
5. Expanding parameter capability. A common home-spun split_string function I see in many shops takes an NCHAR as the split-on string. Often I want to split on more than one character.
6. RegEx.
7. Reducing parameters. Rather than a lot over parameters which have to be filled in, even with DEFAULT or NULL, I use the name to give me the specific I want.