Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
You Know when you've been Tanjayed
Eileen has kitted us out with the new Tanjay IP phones and I have just made room on my desk at home...
Author: Andrew.Fryer Date: 10/23/2007
Performance Point Server 2007 Performance
If you call your flagship business intelligence product Performance Point then it might be a good...
Author: Andrew.Fryer Date: 10/22/2007
Beer Locker
If you want to protect your data then the Bit Locker technology in Vista is a good way to go, and I...
Author: Andrew.Fryer Date: 10/19/2007
Education Education Education
In order to keep the spiraling costs of the education system to a minimum, parents seem to end up...
Author: Andrew.Fryer Date: 10/18/2007
Performance Point 2007 and ProClarity Licensing
As many of you know Whitehaven has gone digital today amongst quite a lot of confusion. I must admit...
Author: Andrew.Fryer Date: 10/17/2007
TechNet's on the Road Again
Following the resounding success of Jame's and Steve's virtualisation road shows the IT Pro...
Author: Andrew.Fryer Date: 10/16/2007
Guitar Heroes
I have noticed that there are a lot of IT People are guitarists out there. It might even be a...
Author: Andrew.Fryer Date: 10/15/2007
SQL Server backups and disaster recovery
DTI Survey 1000 selected companies every year about a wide range of topics. One interesting...
Author: Andrew.Fryer Date: 10/12/2007
TechNet on the Road
We will again be stepping away from PPT and concentrating on a demo-packed full day. We will be...
Author: Andrew.Fryer Date: 10/12/2007
SQL Server Reporting Services
Reporting Services can be a bit of a pain to configure so here's a top tip from Saleem Hakani who...
Author: Andrew.Fryer Date: 10/12/2007
New SQL Server Site
Microsoft has launched it's own SQL Community site, which will be a one stop shop for our product...
Author: Andrew.Fryer Date: 10/09/2007
What's New in SQL Server 2008
While we are all eagerly awaiting the latest CTP of SQL Server, it might be good to check out this...
Author: Andrew.Fryer Date: 10/08/2007
Forward the SQL Brigade
Into the Valley of Thames rode the three sixty ... I get to see all the statistics on how popular...
Author: Andrew.Fryer Date: 10/07/2007
SQL Server SOX Compliance
At the SQL Server community evening last week I was asked whether SQL Server is or is going to be...
Author: Andrew.Fryer Date: 10/04/2007
James O'Neill CIA
Many of you will know that James is a keen photographer, and one of the many reasons for this is...
Author: Andrew.Fryer Date: 10/03/2007
Microsoft Balanced Scorecard
James has now noticed I exist. I have also noticed he has a post about What You Measure is What You...
Author: Andrew.Fryer Date: 10/02/2007
SQL Server 2008 v WinFS
My colleague James has been hassling me for not posting anything of use to him... A long time ago in...
Author: Andrew.Fryer Date: 10/01/2007
Illicit Reporting
A big thanks to all the IT professionals out who spotted my poor English in the 27th Sep Technet...
Author: Andrew.Fryer Date: 09/28/2007
Pervasive Business Intelligence (BI)
I got to present to bunch of BI partners yesterday with Shailan Chadusama. Before our slot, There...
Author: Andrew.Fryer Date: 09/28/2007
Compression without Compression in SQL server 2005 sp2 fact tables
In case you weren't at the excellent SQL Community yesterday evening, I thought I would share a top...
Author: Andrew.Fryer Date: 09/27/2007
The Balanced Scorecard - Flying on Instruments
Flying as I mentioned in my last post is a difficult business, If you have ever seen the flight deck...
Author: Andrew.Fryer Date: 09/26/2007
Real Earth
Reading the Metro yesterday, I noticed a short article about virtual flying using Google and this...
Author: Andrew.Fryer Date: 09/25/2007
Certified Muppet
My post from yesterday got a comment which I sort of agree with along the lines of "My mate Nigel is...
Author: Andrew.Fryer Date: 09/20/2007
Certified Genius
I am not one but I would like to be. I do have the MCDBA qualification because in the days of SQL...
Author: Andrew.Fryer Date: 09/19/2007
Lean and Mean
When you build a cube in analysis services it is very easy to expose every attribute in every...
Author: Andrew.Fryer Date: 09/18/2007
Whatever happened to the Virtual Cube?
I got asked a very odd question today - "How do you use virtual cubes in Analaysis Services 2005?"....
Author: Andrew.Fryer Date: 09/17/2007
The Unified Dimensional Model (UDM)
It's coming up to London Fashion Week so I thought a post on models for all you dedicated followers...
Author: Andrew.Fryer Date: 09/14/2007
One Version of the Truth
One of the most over used phrases in Business Intelligence is "one version of the truth" so I...
Author: Andrew.Fryer Date: 09/13/2007
Cast and Convert
In SQL server the Cast and Convert functions change one type of data to another. A pod cast is the...
Author: Andrew.Fryer Date: 09/11/2007
Hierarchies avoid arguments
Just when you thought you had heard the last of hierarchies there's another post. This one is a...
Author: Andrew.Fryer Date: 09/10/2007
What are you doing with SQL Server 2008
I have heard SQL Server 2008 described as SQL Server 2005 sp4 implying that there isn't a...
Author: Andrew.Fryer Date: 09/07/2007
Making Hierarchies Natural
I though it might be worth another post on hierarchies in Analysis Services 2008 CTP4 to show some...
Author: Andrew.Fryer Date: 09/06/2007
Unnatural Hierarchies in Analysis Services 2008
Continuing on from my last post, I explained what Natural Hierarchies were but I thought it would...
Author: Andrew.Fryer Date: 09/05/2007
Hierarchies in Analysis Services
Looking at that product dimension for my last post, I noticed that there were five hierarchies...
Author: Andrew.Fryer Date: 09/04/2007
Mental Models - Attributes in Analysis Services
I had many happy debates with a business analyst on one of my recent projects because he was bought...
Author: Andrew.Fryer Date: 09/03/2007
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...
Author: Andrew.Fryer Date: 08/31/2007
Performance Point 2007
16 October will be the UK launch for Performance Point 2007 which is going to illicit three...
Author: Andrew.Fryer Date: 08/30/2007
New Kid on the Blog
Viral Tarpara our latest IT Pro Evangelist and ranking new guy has now blogged his way onto Technet....
Author: Andrew.Fryer Date: 08/29/2007
Are you Ready for Business Intelligence?
I have come across many occasions where IT Professionals have pushed really hard to use all of the...
Author: Andrew.Fryer Date: 08/24/2007
Grain - The devil is in the detail
Technorati Tags: BI, Business Intelligence, OLAP, SQL server 2008 Business Intelligence is just like...
Author: Andrew.Fryer Date: 08/23/2007
OLAP, Cubes and Multidimensional Analysis -
Hugh McLeod is quite correct, On-Line Analytical Processing (OLAP) is actually about business, it...
Author: Andrew.Fryer Date: 08/22/2007
Slowly Changing Dimensions and Surrogate Keys
You would expect there to be a record and hopefully only one record for each sales person in a...
Author: Andrew.Fryer Date: 08/21/2007
The Dimensional Model
What's different about a data warehouse is that all of the information from the line of business or...
Author: Andrew.Fryer Date: 08/17/2007
SQL Server 2008 CTP4
Just in case you don't get the technet flash from Georgina, SQL server 2008 CTP4 is out there for...
Author: Andrew.Fryer Date: 08/15/2007
SQL Saturday
I know that there are still a lot of organisations who are still on SQL server 2000 or who have not...
Author: Andrew.Fryer Date: 08/14/2007
Vista and NVIDIA SLI
When not in business intelligence mode, I am a PC gamer and being an old PC Gamer I never got the...
Author: Andrew.Fryer Date: 08/13/2007
Business Intelligence, Data Warehousing, and Data Marts
The terms Business Intelligence, Data Warehousing, and Data Marts are used interchangeably by many...
Author: Andrew.Fryer Date: 08/10/2007
Business Intelligence - Why Bother?
If you're staying with this Business Intelligence (BI) 101 discussion, you are probably wondering...
Author: Andrew.Fryer Date: 08/09/2007
Business Intelligence - What is it?
In the world of management speak it is common practice to re-brand an essentially old idea with a...
Author: Andrew.Fryer Date: 08/08/2007