Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Policy-based management almost makes it to AS2008

leave a comment »

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:

policy

Now policy-based management is one of the new features of the relational engine in SQL2008; you can read more about it here:
http://www.mssqltips.com/tip.asp?tip=1492

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.

Written by Chris Webb

June 24, 2008 at 12:56 pm

Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,302 other followers

%d bloggers like this: