A few months ago I wrote about a possible bug using both DirectSlice and MeasureExpression . A few days ago, Edward Melomed answered that the behavior we observed was not a bug but by design: you can read the complete answer on Connect . The key point  Read more

This is the type of blog posts you write after you spent hours on a stupid issue and you want to remind what’s happened. And may be it will help someone else in the future. Scenario: you have a MOSS 2007 with SSRS 2008 in SharePoint integrated mode. You  Read more

I already talked about the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book I wrote with Chris and Alberto . We found several posts around the blogosphere and I’d like to keep track of them – I’ll try to update this post whenever  Read more

In these days, I’m starting to use Gemini and I’m discussing about it in dedicated CTP newsgroups. I recently wrote a message that I’d like to share here, but not before some considerations. First of all, like Chris said , Gemini is less than a threat  Read more

I and Alberto will present the SQLBI Methodology session at PASS Summit 2009 . After the very good feedback we got at the European PASS Conference 2009 , we will have the big opportunity to discuss this methodology in front of a broader audience. In the  Read more

A few days ago, I talked about Oslo and metadata issues with BI stack . I got several comments and the discussions it’s interesting, but as I said it is too early now to use Oslo – but it could be a foundation for a future product. As a side note, today  Read more

We (I found the issue, Chris created the repro) detected a possible bug using DirectSlice and MeasureExpression. We just posted it here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=455732 The issue could be very dangerous  Read more

You know, today Microsoft doesn’t have a solution to handle metadata of a BI Solution. Really, they don’t have nothing to handle a single layer of the architecture like the Data Warehouse. In a (how much near?) future this gap could be filled by using  Read more

Even this year I will be a speaker at the European PASS Conference 2009 (April 22-24, 2009 – Neuss, Germany). Last year I had a session discussing the Many-to-Many Revolution paper. This year I’m excited to introduce the SQLBI Methodology joining Alberto  Read more

If you try to use the WITH clause in a SQL Command of an OLE DB Source in a Data Flow of Integration Services, you might receive the error ‘Statement(s) could not be prepared’. Solution: put a semicolon (;) just before the WITH keyword.  Read more