Darren Gosbell

The next version of DAX Studio has just been released. You can download this release and read the release notes here

A few days ago the BIDS Helper team released of v1.7.0 which you can download from here: https://bidshelper.codeplex.com/releases

Looking at a typical Power Query query you will noticed that it's made up of a number of small steps. As an example take a look at the query I did in my.…

Chris Webb and Matt Mason have both blogged about formulas for generating a date table using PowerQuery, but both of these posts focus on the standard…

Recently one of our production Tabular servers was being hit with a number of extremely large queries that were causing excessive load and impacting the…

Do you create foreign key constraints between dimensions and facts in your relational star schemas? I don't want to bias the results in any way, so I…

I've been meaning to post this for a little while, and a recent post on the SSAS forum at ssas-info.com prompted me to finally get around to it.

There was a thread last year on the SSAS MSDN forum SSAS 2008 -- Why is metadata so slow??? in relation to slow metadata queries on a cube with 250+…

A few weeks ago I did a post introduced the ExecuteSQL.net stored procedure for SSAS. asked if this function can be called from Excel 2007 when it is set…

I had a question a little while ago via my blog about possibly using a rowset action to execute a SQL query against a specified table. Although a rowset…

A friend of mine was looking for a tool today to extract a list of names and email addresses from a folder in outlook. I know that Outlook has a…

Does that title make sense? I don't know if it does, but I can't think of another description for this problem. If anyone can think of a better title I…

You have designed Aggregations for your cube, but how do you know that they are currently processed? Hopefully you have your processing routines setup in…

Every now and then on the SSAS MSDN forum, the issue of doing a generic "ratio to parent" calculation comes up. Unfortunately there are a number of…

\via [EXEC dbo.LongTermMemory\\Archive\] Apparently SQL Server now has a new logo. It's interesting... I think they felt left out at the launch events…

The BIDS Helper team are please to announce the release of v1.2. You can get it here BIDSHelper\DownloadSmall And just to give you an idea of what BIDS…

Microsoft has a couple of articles on how to set up HTTP connectivity for SSAS, one for Win XP http://www.microsoft.com/technet/prodtechnol/sql/2005/httpss…

\Via [Vidas Matelis\] Vidas recently did a post about a couple of new features that will be available in SSAS 2008 (but that are not in the July CTP). One…

I am speaking tomorrow night at the Melbourne SQL Server User Group. The presentation will be based on the excellent white paper that Marco Russo produced…

I am pleased to announce that we have just launched the first public release of BIDSHelper. It is an Add-in for the BI Development Studio (BIDS) for SQL…

Here is something interesting that came up a newsgroup thread a little while ago, that I though merited some more explanation.

I've been in the "5 things that people don't know about me" meme that is going around So here is a random 5 things that most people that read this blog…

Jamie Thomson has an interesting post here http://blogs.conchango.com/jamiethomson/archive/2006/06/20/4106.aspx about some of his recent experiences with…

I have been experimenting a bit more recently to see what I can do with Powershell and Analysis Services. The following small script executes an MDX query…

The more I play with PowerShell the more I like it. And now that I have a provider working that allows me to link in an Analysis Services server and…

There was a question recently on the Analysis Services newsgroup asking how to process an Analysis Services 2005 cube using XMLA from the command line.…

Soon after installing Analysis Services 2005 I upgraded the Foodmart 2000 sample database from Analysis Services 2000. Foodmart is kind of the equivalent…

There was an interesting thread on the SQLDownUnder mailing list last week about the use of Key Value Pairs in database design. One of the Guru's on the…

This script will backup and Analysis Services 2000 database and timestamp the .cab file with the date of the backup.