SQL Bits UK

This summer I am attending and speaking at several conferences. Most of them are internal to Microsoft such as TechReady which is similar to TechEd but only for the Microsoft field. However one of them is external and that is SQLBits on the 17th – 19th July 2014 at The International Centre, Telford, UK. You…


Creating a BI test machine in the cloud and allowing anonymous access to it

I got a question from a colleague that wanted to know how he could create and connect anonymously to a BI machine in the cloud. There are several whitepapers available but they can be hard to follow if you never have done it before so I thought that I would write a small simple instruction…


New book, new job

The reason that this blog has been awfully quite for the past months is that I have written a book on Analysis Services cube development. This book targets new SSAS developers or people wanting to become one. Readers of this blog will recognize the style of the book, it takes a step-by-step approach and contains…


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…

30

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…

2

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…

4

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: http://www.microsoft.com/en-us/download/details.aspx?id=34598 I…


BI data on maps in SQL Server 2012 part 2

In my previous post http://blogs.msdn.com/b/querysimon/archive/2012/06/17/bi-data-on-maps-in-sql-server-2012.aspx I described how to create a Reporting Services report that contains custom map data. One of the drawbacks with the mapping component in SSRS is that you cannot zoom interactively in your reports. One way to solve this shortcoming is to use linked reports that uses parameters to drill down…

8

BI data on maps in SQL Server 2012 part 1

I often get questions around how to show business intelligence data on maps in the Microsoft BI stack. Some people thinks that we do not support this for the entire world but only for US. I think that this misunderstanding comes from the fact that the map gallery in Reporting Services only shows data from…

2

SQL Server 2012 has been released

More information can be found on http://www.microsoft.com/presspass/presskits/sqlserver/

1