I have done a blogcast and a few posts around the configuration servers in the betas of SQL Server 2008, however in SQL Server 2008 as released these are now called Central Management Servers. For those of you who have held off form trying the latest version until it was released, this feature is a sort of extension to registered servers that have always been in the SQL Server management tools.
What you do know is to register any instance of SQL Server as a Central Management Server in a given domain (the stuff here only works across serves in the same or trusted domains) in the registered servers tab in SQL Server Management Studio.
Underneath this you can then create a groups or register individual servers as we all used to do in SQL Server 2000. When you right click on the Central Management Server or a group you can do a couple of useful things..
You can register the same server multiple times to put it into different groups. For example you could have a group for each version of SQL Server you have (say 2000,2005, and 2008)and a set of groups for dev test and prod with each server being registered twice , once in group for the version it is running and once for the function (dev test or prod).
With these two sets of groups you can now run sql or evaluate policies against all your dev servers or all of your 2005 servers.
Two things to be aware of:
Thanks to Brent Ozar from Quest for all of this, the demo guru at last night Quest tools launch event.
If you want to know more I will be covering this at length at SQL Bits cubed and these TechNet events:
Hello, sir, and thanks for the link! It was a pleasure working with you at that presentation, and I look forward to getting back to London again!