Professional Microsoft® SQL Server® 2008 Administration

8.6. Summary

With the SQL Server Service Broker, messaging is now deeply integrated into the Database Engine. 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 Service Broker, which adds reliability and fault tolerance to this approach. Service Broker also simplifies the design, construction, deployment, and servicing of service-oriented applications. With SQL Server 2008 you can now also define the conversation priority to send and receive messages in the order defined by your application. You have to set the HONOR_BROKER_PRIORITY option to 1 for the particular database in order for conversation priority to work. With 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 permission 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 Chapter 9, you will learn much more about securing ...