April has been a month full of conferences and May will be full of workshops! I’m also working on other things and I hope to be able to publish more technical content in my blog very soon! In the meantime, we just announced an edition of the PowerPivot  Read more

As I blogged last month , the spring is a season full of events and this is a reason why I’m not writing technical articles in these weeks. But I promise I’ll write again in a few weeks, there are a lot of interesting ideas that need to be written down.  Read more

As you might know, I wrote three books about LINQ with Paolo Pialorsi. He’s an expert in SharePoint development and after one year of tough writing it is finally available its Microsoft SharePoint 2010 Developer Reference book. If you want to write code  Read more

Several months ago I wrote about the issue importing measures from an Analysis Services cube in PowerPivot. The short story is that, when you define the MDX query, all columns are imported as Text. Of course, this is not a good thing for the numeric measures.  Read more

A common feature request for PerformancePoint is importing a briefing book from ProClarity. As far as I know, this is not available. Today (thanks to a tweet from @denglishbi ) I discovered a product, Pyramid Analytics bioXL , which has a specific feature  Read more

Most of the readers of this blog probably have a good knowledge about MDX. But if you are new to MDX or want to improve a basic knowledge, and you’re in London or you are looking for a very good reason to visit the city, then you cannot miss the public  Read more

I lost the count of how many SQLBits I lost for one reason or another, but now it’s the time! I and Alberto will present a full day training on April 7 at SQLBits 8 in Brighton. Our seminar will be dedicated to the SQLBI Methodology and is based on the  Read more

I have a friend (Sandro Rizzetto) that is also a photographer. A good one, but his job is in IT. For these reasons, after reading some posts of mines, he built a PivotViewer page to navigate its photo database. You can drilldown by category, date, lens,  Read more

As many of you probably already know, Donald Farmer left Microsoft to join QlikView . There are no doubts that Donald have been “the face of Microsoft BI” in the last years. This news has been initially perceived (me included, I admit) as a possible lack  Read more

Greg Galloway just released a new version of the Analysis Services Stored Procedure Project that includes a command to clear the File System Cache , including the standby cache. A technical discussion about how it works is available in this post on his  Read more