Summary

With the SQL Server Service Broker, messaging is now deeply integrated into the database engine. The Service Broker provides an excellent platform on which to build a reliable, scalable, and secure messaging system. You can base your service-oriented application on the Service Broker, which adds reliability and fault tolerance to this approach. The Service Broker also simplifies the design, construction, deployment, and servicing of service-oriented applications. With the Service Broker, you can build asynchronous applications using T-SQL language with reliable message transport. You have learned how to build the messaging application and how to administer it in this chapter.

With CLR integration, SQL Server has now become an application platform along with its usual database engine capabilities. You learned how to create an assembly and register it into SQL Server. You also learned how to set permissions on assemblies and maintain them. The CLR's Framework class libraries are categorized according to degree of safety, which will alleviate some concerns DBAs have.

With the key concepts out of the way, you can now drill into more specific areas to manage, such as security. In the Chapter 9, you will learn much more about securing your SQL Server.