Category Archives: Solutions

Setting up Power BI Preview for MSDN developers when own email address does not work

Update- our IT department have now got this working internally, so we no longer need the workaround below. Power BI is currently in preview, and has just been made available worldwide. Many developers have been champing at the bit to … Continue reading

Posted in Solutions | Tagged , , | Leave a comment

Upgrading from SQL Server 2012 RC0 to RTM

If you installed SQL Server 2012 RC0, your evaluation may have expired, or may be doing so shortly. So you’ll likely be wanting to upgrade to RTM- and you might run into a few problems along the way. That was … Continue reading

Posted in Solutions | Tagged , , , , , , | 4 Comments

Unsupported data format : application/vnd.ms-excel.12

If you’re anything like me, you’ve been making use of the lovely new features in SQL Server 2012 alongside SharePoint 2010 SP1- such as using PerformancePoint to report on PowerPivot or SSAS BISM Tabular cubes. If that’s the case, you’ve … Continue reading

Posted in Solutions | Tagged , , | Leave a comment

Project Crescent in Denali CTP3: bugs and features

As I’ve blogged before, we’re currently working with Denali CTP3, particularly making use of Project Crescent (alongside stalwarts such as SSRS, PowerPivot and PerformancePoint). Its a fantastic little tool that really gives the wow factor to any reporting demo. Its … Continue reading

Posted in Solutions | Tagged , , , | Leave a comment

SSRS Tips for Beginners No.1: know your source data

  So, you’ve written a query that gets the data you need, and throws it onto a table. All fine so far, except when you preview the report, you end up with something like this: The users are unhappy- they … Continue reading

Posted in Solutions | Tagged , | Leave a comment

MSSQLServerOLAPService start request failed

Ever had one of those frustrating problems that eats up days of your time? This is one such nasty. On a Windows XP laptop here at IPL, we installed SQL Server 2008 R2 Developer Edition. All was fine, until we … Continue reading

Posted in Solutions | Tagged , , , | 15 Comments

Optimising a complex query in MySQL: avoid derived tables!

Recently I had to optimise a query that was part of some slow-running ETL: it was taking longer than its allocated load window, and when run it would bring the source systems to their knees. Here’s how I solved it- … Continue reading

Posted in Solutions | Tagged , , , , | 2 Comments