Well it's been quite a while since I last blogged about anything of note, but reading through my RSS subscriptions this morning I noticed that Richard Seroter has written a very handy utility for managing configuration data stored in the SSO database.
I tend to use a combination of the BizTalk rules engine and the SSO database to store configuration information for the projects that I work on. I tend to use the rules engine where I wish to have several items returned in one operation rather than a simple name-value pair. I also tend to use the rules engine where it is beneficial to have the data returned as xml. Plus there are performance considerations and versioning implications to consider. The SSO database I find very useful especially for configuration parameters that are environment specific, and I will tend to use this database as the configuration store of first choice.
On my current project we are using the Scott Colestock BizTalk Deployment Framework, and we use this for deploying the SSO data. In the past I have built specific utilities for support teams to use to alter configuration data stored in SSO, but this new tool that Richard Seroter has built is a fully comprehensive application for this purpose. I think I'll be making a lot of use of this on my projects in the future.
Thanks Richard!