In this chapter, we covered an overview of .NET development on SQL Server. Using .NET, custom objects help us to enhance SQL Server's capabilities in many ways. This is especially true when we need to create our own aggregation functions, as .NET programming is the only way to do it. However, overusing CLR objects may also lead to many issues and disappointed users.
The first part of this chapter was dedicated to providing an overview of SQLCLR. Here, we looked at how this works and when it is beneficial to use it. We then started to create an empty end-to-end SQL Server Database Project to demonstrate the development life cycle.
After the introductory section, we explored development in more detail. During this section, we developed and published our own CLR aggregation calculating statistical moments. The additional knowledge taken from this section describes what...
