Using SharePoint Content Types as Report Templates

Last week a customer asked us if he could help users to start a PowerPivot file from an existing template.  For this specific environment some analysis was to be done on content stored in SharePoint Lists.  Using SharePoint 2010 and PowerPivot enables you to subscribe to these lists as Data Feeds, which is a nice…


New Windows Azure Platform Features Available Today

Building out an infrastructure that supports your web service or application can be expensive, complicated and time consuming. Whether you need to forecast the highest possible demand, build out the network to support your peak times, getting the right servers in place at the right time or managing and maintaining the systems, these actions require…


What’s New in SharePoint 2010 for BI?

  I did a post on the new features in Excel / Excel Services 2010 from a BI point-of-view but notice that people also want to know this for SharePoint 2010.  So apart from the Excel Services improvements which are mentioned here let me try to give you an overview of the other additions. to…


First Microsoft Demo Day (June 2nd 2010) will keep its promise of offering a thrilling experience

Microsoft Belgium and Luxembourg proudly announces its first Microsoft Demo Day. Please join us on Wednesday, 2nd of June, 2010 at Microsoft Belux for a day packed with exclusive demo sessions on a wealth of Microsoft offerings. Forget about lengthy PowerPoint presentations – this is a No-Slides-Allowed Event. Instead, you will experience a series of…


Can I upgrade my SQL Server 2008 R2 Trial to a full version?

Now that the SQL Server 2008 R2 trial is available for download at, many people want to know whether the trial version can be upgraded to a full version once you have a key.  The answer is: yes!  It is actually very easy and can be done in two ways, through the GUI or…


What’s new in Excel 2010 for BI?

A very common question I get is “What is actually new in Excel 2010 for BI?”.  As you all know Excel is a wonderful BI client and many reports eventually end up in Excel.  As a result we obviously invest a lot in the BI capabilities of Excel and Excel 2010 is not an exception….


Twitter for the SQL Server professional

Twitter as it is described on their website: “Twitter is a real-time information network powered by people all around the world that lets you share and discover what’s happening now.”  If you want to know more about Twitter check out Twitter like any social network used for a lot of things, many of which are…



One of my colleagues, Rob Collie, has created a new FAQ for PowerPivot @ will try to answer as much of the questions on PowerPivot as possible.  This can only be achieved because of the great volunteers who moderate this list of course. More information can be found @ This also means that…