Installing the BI features of SharePoint 2013

Now that SharePoint 2013 and SQL Server 2012 SP1 have been released I thought about revisiting my post on how to install the BI features of SharePoint 2013. As in the previous post I am installing the bits on a fully updated Windows Server 2008 R2 machine, I have added the Web role as well…


Running SQL Server 2012 and earlier versions on Windows Server 2012

I have got a lot of questions on how to install and run SQL Server on Windows Server 2012. Now we have released a knowledge base article that outlines the required software prerequisites for running SQL Server on Windows Server 2012. The article talks about all versions of SQL Server 2005, 2008, 2008 R2 and…


SQL 2012 Service Pack 1 is released

Now during SQL PASS they have announced the availability of SQL Server 2012 Service Pack 1 (SP1). You can find the download here. There are two options for the download either a slipstream package or a standalone installation package.   As part of the SP1 release we also released the Microsoft® SQL Server® 2012 SP1…


Using the Bing API to geocode data in SSIS

During my talk at SQLRally Nordic Bringing maps to SQL Server I showed how to geocode data in SSIS. The way I did this was to create a custom component in SSIS. In this post I will show how this was done.   The first thing that I did was to create a new project…


Running SharePoint and BI services in the cloud

I have been thinking about writing a post about this for a long time. However now a new whitepaper was released that explains how to configure a BI environment in Azure. It is called SharePoint Deployment on Windows Azure Virtual Machines and describes the steps in detail. You can find the paper here: I…


PASS SQLRally 2012 Nordic here we come

Be sure to attend the PASS SQLRally 2012 in Copenhagen. You have the opportunity to listen to the best speakers in the industry, see for a list of speakers. I got my session called B(r)inging Maps to SQL Server accepted, the session will be jointly presented together with my colleague Mikael Colliander. We will…


PPS future in SharePoint 2013

The development team have released a new blog post outlining the improvements that have been made for PPS in SharePoint 2013 and is asking for feedback on what other priorities they should focus on. Read more at What improvements would you like to see for PerformancePoint Services in Office 2013?


Installing the BI features of SharePoint 2013 Preview

I have now added a new post on how to install the BI features in the released version of SharePoint 2013 you can find it here  Since the release of SharePoint 2013 Preview I have tried to get a working demo environment up and working on my system. I have tried a lot of different…


Working with map data in Power View in Excel 2013 Preview

  One of the new options that you have in Excel 2013 and Power View is to show data on maps. This is a feature that is awaited for, most data in the BI world contains some sort of geographical information.   This could be sales territories, customer locations or production plants, etc. When I first…


Creating your first PowerPivot Workbook in Excel 2013 Preview

Please note I am not a member of the Dev team. My posts are just things that I have found when playing with the new Office bits. My findings may be inaccurate or an error on my part. After installing Excel 2013 you may would like to create a new workbook containing PowerPivot data. After…