MSMDPump.dll connection to SSAS

I was asked recently if it is possible to create HTTP msmdpump.dll (Per user identity) connection to an SSAS cube.

Microsoft have produced a White Paper by Edward Melomed, which covers the topic in SQL Server version 2005. However, the architecture is the same in SQL Server 2008, and you should be able to extrapolate from one version to the other.

I won’t repeat Edward’s excellent paper; instead, I’d like to refer you to his White Paper, which you can find here.

Data Visualisation Sample Slide Deck

If you attended the fantastic SQL Saturday 105 in Dublin, you might be interested in these slides.

We’ve presented on Data Visualisation in the UK, Europe and in the US. Here is a sample slide deck. As always, these are subject to change as we develop our presentations in response to community requests for a different perspective, or in response to an update in technology, for example.

Here is an example of one of my Data Visualisation presentations:

Data Visualisation Course with SQL Server 2012 Tabular Models, Power View and Excel

I’m excited to announce that I’ll be teaching a course on Data Visualisation on 30th May 2012 in London, in partnership with Technitrain, the UK’s foremost Microsoft training organisation. 
If you are looking to understand more about Microsoft’s latest Business Intelligence data visualisation offering, then this one-day course is for you! We’ll learn about SQL Server 2012 Power View and Excel, using SQL Server 2012 Tabular Models as a data source. 
Although this course focuses in technology, we will also be covering aspects of perception, cognitive psychology and data visualisation debate over what makes a good data visualisation. Understanding the ‘why’ of data visualisation can help you to see ‘how’ to produce better visualisations. We’ll be using Microsoft Power View and Excel in order to apply this knowledge to practical applications, thereby helping you to get the ‘message’ of the data across to your business users. Here are some of the topics we will cover:
  • Data Visualisation – Theory and Practice
  • Finding Patterns in Data
  • Getting to Know your Data using Power View and Excel
  • Power View in Depth
  • Dashboards – putting it all together

Please join myself and other ‘data vizzers’ for this one day course, and you can find more details, including Registration, by clicking here.
I look forward to seeing you there, and please do give me a shout if you’re coming along!

SQL Server 2012 Virtual Launch Event and Download Info

The SQL Server 2012 Virtual Launch Event is starting on 7th March! As part of a global team on March 7th, I’m answering questions on the SQL Server 2012 Virtual Launch Event, which is being held online. Register here:  If you’re not sure what the fuss is about, take a look at the video here:



In the meantime, if you can’t wait that long, you can download an evaluation of SQL Server 2012 – not RC0! – then please visit this link. If you’re interested in a preview about SQL Server 2012 and private cloud, please visit Ross Mistry’s article here

The Virtual Event is a global, online SQL Server Virtual Launch Event event will allow you to get the latest information on Microsoft SQL Server 2012. You can interact directly with:

  • Microsoft Product Teams
  • Select customers who are part of the SQL Server 2012 story
  • Microsoft Partners
  • Microsoft Most Valuable Professionals 


There are over thirty separate sessions which focus on new mission-critical capabilities, data visualisations and performance benefits. For example, here are some of the sample sessions where you can learn:

  • Why Oracle DBAs should learn about SQL Server
  • Performance Increases with the Column Store Index
  • Unstructured Data search
  • Unlock the value of Big Data with SQL Server
  • Self-Service Analysis with Power View


Best of all, since this is a community virtual launch, you’ll get to meet, online, the people behind SQL Server 2012. In my opinion, you should take advantage of this unique opportunity to interact with Microsoft Product team, and other experts who want to share their enthusiasm with you.

The SQL Server 2012 Virtual Launch event is global, and lasts for 24 hours. I’ll be online to help answer your questions and chat between 2200 and 2400 UK Time, which is 2PM PST (UTC -8 hours) or 5PM EST (UTC -5 hours) but I’ll be participating throughout the day too. I cannot wait!

I look forward to meeting you in the Virtual Lounges or online on Twitter. Come and join in the fun, you never know whom you might meet! See you there!