Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Relay

I am in the middle of SQL relay this week, but I just realised that you might like to have a copy of my Denali slide deck, which I have now posted to SkyDrive. You are welcome to have a look at it even if you couldn’t make one of the four venues I am… Read more

Query Across the Mersey

SQL Bits 9, Adelphi Hotel Liverpool 29th September to 1 October 2011, what else do you need to know? Well possibly a few things if you are now reading the second line of this post or you haven’t been to them before.. It’s the biggest and best SQL event in Europe, I know this because… Read more

Making MDX interesting

Chris Webb MVP can, to quote a friend of mine can, “Make MDX sound interesting”.  I have to say when I first when on a course on MDX the tutor went for the “Make MDX confusing and boring” approach. Chris has recently coauthored a book on Expert Cube Development with Microsoft SQL Server 2008 Analysis… Read more

Excel add ins for Analysis Services

Excel and analysis services are pretty open technologies so it’s very easier for anyone to grow their own stuff in for a richer experience, and even Microsoft provide things like the data mining add-ins which follow this principle. These add-ins are not confined to Microsoft and they are not always free.  What caught my eye… Read more

MDX Analyzer

Compared to T-SQL and the database engine , MDX and analysis services is a somewhat poor relation and is usually catching up. There’s no resource governor in SQL Server 2008 or intellisense for MDX in management studio.  I expect this is because while T-SQL is used by far more people than those using MDX. However… Read more

Open Business Intelligence, spoilt for choice

Let me start with a little history of Microsoft BI. Microsoft acquired an OLAP tool from a company called Panorama, project name Plato, which was bundled in with SQL Server 7.0 and from this grew the present incarnation of Analysis Services which IMHO is the crown jewel in the company’s BI armory, it has allowed… Read more

Excel OLAP add-in

Excel already has always had excellent support for analysis services, but to get the best form it you need to use a version of office later than than the version of SQL Server you are connecting to.  So for analysis services 2000 excel 2003 is OK but if you connect to analysis services 2005 then… Read more

SQL Server 2008 Samples

If like me, you are trying out the new stuff in SQL server 2008 you might need some data to work with.  The standard Adventure Works sample databases for OLTP and data warehousing are not in the CTP nor is the the analysis services project.  So you’ll need to get them from Codeplex  which not only has these but some useful… Read more

OLAP, Cubes and Multidimensional Analysis –

 Hugh McLeod is quite correct, On-Line Analytical Processing (OLAP) is actually about business, it just sounds like a science project.         Basically OLAP is an awful name, Nigel Pendse, author of the OLAP report calls the same thing FASMI, which I think is a far better term : Fast – 90% of queries back… Read more