Speed up SSIS by using a slower query
This isn’t a technical blog post of my own, but a shout out to Rob Farley and an excellent blog post explaining how to use SQL’s OPTION (FAST x) […] Continue Reading…
Debug MDX queries using Drillthrough in SSMS
One of the great features of using Excel to browse an SSAS OLAP cube is the drillthrough ability. If you double click on any cell of an OLAP pivot […] Continue Reading…
How to add calculations in SSAS cubes
One of the most useful aspects of a Business Intelligence system is the ability to add calculations to create new measures. This centralises the logic of the calculation into […] Continue Reading…
Forecasting the Performance of SSIS packages
SQL Server Integration Services (SSIS) packages are used in numerous scenarios for moving data from A to B. Often they are developed and tested against a cutdown, often static, […] Continue Reading…
Deploying MDX calculation scripts with xmla
If you’re a Business Intelligence developer I assume you have BIDS Helper installed. If not then stop reading this post and go and install it. Now. It adds a […] Continue Reading…
Business Intelligence in the Cloud
The Cloud is pretty much top of the list of the corporate buzzword bingo phrases at the moment. It’s clear what the benefits are from a SAAS perspective, but […] Continue Reading…
OLAP Cube Documentation in SSRS part 3
This is the 3rd and final post in this series of blog posts, showing how you can use SQL Server Reporting Services (SSRS), DMVs and spatial data to generate […] Continue Reading…
OLAP Cube Documentation in SSRS part 2
In my previous post I described how to create a number of stored procedures that use Dynamic Management Views (DMVs) to return the metadata structure of an SSAS 2008 […] Continue Reading…
OLAP Cube Documentation in SSRS part 1
Being a business intelligence consultant, I like to spend my time designing data warehouses, ETL scripts and OLAP cubes. An unfortunate consequence of this is having to write the […] Continue Reading…
BCS talk on Business Intelligence – Slides
Thank you to the BCS Shropshire branch for opening your doors to the Purple Frog team. We’re delighted to be given any chance to talk about Business Intelligence, and […] Continue Reading…