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

Using SSAS 2005/2008, there is no way to apply security to DRILLTHROUGH actions, so we cannot decide whether a specific user is authorized or not to perform a specific action. This is a “by design” behavior, since DRILLTHROUGH actions are initiated at  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

Today I ran into a nice misfeature of SSIS that worths sharing. If I want to use SSIS to sort a flow of data, containing both lowecase and uppercase strings, I would expect a standard behaviour or, at least, something with some “common sense”. As I am  Read more

Guys, I’m excited of being a speaker at the European PASS Conference 2009 (April 22-24, 2009 - Neuss, Germany). I will present three sessions, on Slowly Changing Dimension Handling, OLAP partitioning with SSIS and scripts and, most interesting (at least  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