Chapter IV.7. Advanced Development Topics

After you master the basics of programming in SQL Server 2008, you might want to spread your wings and take on some of the more advanced development topics. In this chapter, we take a look at the possibilities you can achieve with the following advanced tools:

  • Service Broker provides you with some sophisticated messaging without all the messy development work to manage messaging.

  • SQL Server Management Objects (SMO) can be used to automate many of the administration tasks.

  • CLR integrated objects (such as triggers and stored procedures) allow you to take advantage of the strengths of managed code by using any .NET programming language within SQL Server.

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.