I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here’s more of what I showed for 1:00pm – "New and Shiny":
There are a few features in SQL Server that can be complex to implement. That’s often due to the nature of the feature – they are complicated things to do. So in SQL Server 2008 SSMS, we’ve added a few new dialogs and wizards to help you along with some of the more often used features. Two that are of note are the Service Broker and Partitioning. Service Broker gets a new set of dialogs that in essence script out a new SB application, and Partitioning gets its own Wizard to help automate the process.