Policy-based management almost makes it to AS2008
I was using SQLMS with AS2008 the other day and noticed when right-clicking on the server node in the Object Explorer window some policy-based management options seemed to be available:
Now policy-based management is one of the new features of the relational engine in SQL2008; you can read more about it here:
For a moment I was excited, then I took a look at what facets were actually available for Analysis Services: there’s only one, and that gives you the same options to set as you got in the old Surface Area Configuration tool. Maybe in a future release we’ll get some more functionality – it would be great to be able to enforce policies like "Always associate a partition with an aggregation design" and so on.