Cumulative update package 6 for SQL Server 2005 SP 2

February 24, 2008

CU6 for SQL Server 2005 Service Pack 2 was released last week. The knowledgebase article detailing what's inside is available here and the download itself is available only after requesting CU6 from Microsoft here. Chris Webb had just written in his blog, that apparently this still does not necessarily lead to a SP3 for SQL Server 2005. 

SQL Server 2008 February CTP

February 20, 2008

Well as some very good people in the community have managed to say even before me, SQL Server 2008 has shipped a new CTP version just yesterday. As I have mentioned before, this is the feature complete version which includes all the functionality planned for the final release in Q3 of 2008. I think that for most people, the big change here will be the integrated Full Text Search which should really enhance performance. Go ahead and download it here!
no comments

Updating your Report Model

February 9, 2008

I know I had written of the simplicity and ease of creating a report model based on a cube, but I too would have to admit that even a good thing can be made better. Just in case you hadn't noticed, when you enter the report site you can manage your models. If you can't see the "Models" folder, simply click the "Show details" and you'll see it. Select the folder and click on the name of your model or on the "edit" icon next to it. You now have a chance to "Edit" or "Update" your...

Visual Totals in MDX and Role Security

February 6, 2008

Well I thought today we'd go over visual totals in MDX and also see how they may have an impact on how you assign role based security in you SSAS project. Visual Totals in MDX are there to give you just what they describe – a sum on the children in a certain set. Child members which are not in the specified set will be ignored during the calculation. For instance, if I have a set that consists of: USA, New York, Washington and California, when I look at the total for USA, I will only see it's sum...