The previous chapter demonstrated how to work with statistician summaries in data. However, T-SQL capabilities are sometimes quite limited to statistics and data science. This chapter is going to demonstrate how to create our own custom aggregates in order to enhance core T-SQL functionality.
The only way to create a custom aggregate is to use one of the .NET languages, as well as the result of development and deployment on the SQL Server. This chapter is not intended to fully describe how to use C# and learn it, but is intended to give an overview of SQL Server enhancement possibilities using .NET. This overview is especially targeted at custom aggregates.
The following topics will be covered in this chapter:
- Overview of SQLCLR: In the first section of this chapter, we will describe how .NET works on SQL Server, what the SQLCLR is, what can...
