19 June 2008

Tool to Groom Reporting DataWarehouse

My previous article was very much focused on how to modify the database grooming settings for OpsMgr reporting database. I have taken this a step further by developing a small and simple tool that saves non-SQL Server administrators the time and effort to do so. Basically this tool will connect to the tables that defines the grooming settings and retrieves the information and display them to a UI. User can then modify the grooming settings by setting the MaxDataAgeDays value in the table and save it.

For those who are interested in this tool can just email me at theankeong@gmail.com