Insufficient data from Andrew Fryer

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

Browse by Tags

Related Posts
  • Blog Post: 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 we get people coming...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 presenting at this week, but there isn’t a lot of...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 in...