An interesting example using a CLR aggregate function to perform linear regression. I’ve done a linear regression within an SSRS custom chart component (to draw a trend line), and I have done text string concatenation using a CLR aggregate, but I never thought of doing this. I don’t know that I ever WOULD do it, but I thought I would pass it along anyway.
Moving to a new version of SQL Server is always interesting, and this version is proving to be no exception. It has been a lot of fun so far, and I hardly know where to start, but I will start with CLR assemblies.