Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Application Lifecycle Management
Data Protection Manager
Essential Business Server
Full Text Search
Microsoft Security Essentials
Performance Point Server
Read Only Domain Controller
Remote DeskTop Services
Slowly Changing Dimensions
Software + Services
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server Express
TechNet Road Show
windows phone 7
Windows Server 2008
Windows Server 2008 r2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
Tagged Content List
Microsoft, and Hadoop for Big Data
Despite common misconceptions Microsoft now has extensive interoperability with open source technologies for example you can run a php application on Azure, get support from us to run RedHat, SUSE or CentOs on Hyper-V and manage your applications from System Center. , So extending this approach...
5 Jul 2012
SQL Relay 2012
Four cities, in four days makes for one tired evangelist, so why am I doing SQL Relay with the SQL community I hear you ask. Well that’s your answer really - I can’t hear you ask anything when I am sat in darkest Surrey blogging away so I am actually doing these events not so much to...
7 May 2012
Application Platform Knowledge Hub
Albert Einstein once remarked that you don’t need to remember everything, you just needed to remember where to look. When it comes to learning about Microsoft products this can sometimes be harder than it ought to be and what resources there are can be fragmented so you do have to remember where...
6 Feb 2012
NO SQL Server
I spent last Thursday at Black Marble’s Architect Forum and my slot was on SQL, NoSQL, some SQL. It went down very well but I used OneNote on my tablet not PowerPoint and like all modern art my drawing needs a bit of explaining.. Databases were originally used to store transactions which are highly...
10 Dec 2011
SQL Server HP Appliances & the modern data centre
There is a lot of advice on whether to virtualise SQL Server and many dbas are under pressure to do this. There’s good advice here from SQL CAT on best practice on hyper-V and if you are in the business of acquiring hardware to run SQL Server virtualised then there are two reference architectures...
17 Oct 2011
Does “self service BI” mean more or less work for IT?
Before I answer that question I want to be clear on what exactly self service BI means as you could argue that users have been doing BI for themselves since the spreadsheet was invented. In those early days users would often have to rekey data into whatever analysis tool they were using as the source...
5 Oct 2011
BI for small business
When I applied to join Microsoft nearly 4 years ago I had to give a presentation on olap for small business which now looks a little dated. So yesterday I got the chance to revisit my thoughts on this over espresso with BI Guru Rafal Luckaweiki from Project Botticelli who was over to...
3 Mar 2011
Looking backwards over a decade of Microsoft BI
It was in early 2000 if memory serves that I first used OLAP Services in SQL Server 7 and Cognos Novaview 1.0 and ten years later I wondered, as you do at this time of the year, what has changed and what will the future bring? and specifically is there a future for the BI professional with the dawn of...
5 Jan 2011
BI Masters Degree at Dundee University
Although I am a huge fan of Microsoft BI (which is why I work for Microsoft not because I work for Microsoft) I realise that many of the factors behind a successful BI project are nothing to do with the technology. Of course the technology decisions can make a BI project more effective, more affordable...
23 Feb 2010
Take a closer look at the Microsoft Application Platform
I like technology but it’s what you do with it that matters. Having said that if you don’t know what a piece of technology is capable of be it your home cinema system or SQL Server then you might not be making best use of it. One piece of technology from Microsoft that is little understood except by...
7 Jan 2010
SQL Server scalability?
Is SQL Server is only as good as the operating system – discuss The ability of SQL Server to make use of underlying hardware is often held up by the operating system, or to put it another way, pretty much as soon as there is support for some new thing the SQL Server team have a version that uses it. ...
9 Dec 2009
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...
7 Aug 2009
This simple design, popped up in my inbox today asking for advice… What you need to understand about this diagram is that there is a concatenated key (keys are in BOLD ) on each of the orange dimension tables, with one part of that key being CompanyID. The exception is dCompany which is just keyed...
21 Jul 2009
Changing Dimensions – Fast or Slow?
Many resources on data warehousing talk about slowly changing dimensions and how to deal with them but what happens when your dimensions change more quickly and what is does fast or quick mean in in this context? First let’s be clear on what is meant by slowly changing dimensions. Any change to...
3 Mar 2009
SQL Server Advent Calendar 19 – Data Collection
Day 19 of my virtual advent calendar, about stuff I like in SQL Server 2008.. I often get asked how much faster is SQL Server 2008 than SQL Server 2000, what impact will virtualisation have on my performance, and my answer in fine Microsoft tradition is it depends. So how can we begin to answer...
19 Dec 2008
SQL Server Advent Calendar 15 – Integration Services Profiling
Day 15 of my virtual advent calendar, about stuff I like in SQL Server 2008.. If there were no issues with data quality in data warehouses I would have completed many of my BI projects in a third of the time. The client would always insist they had good data, after all it would often be coming form...
15 Dec 2008
SQL Server Advent Calendar 14 – Integration Services Lookups
Day 14 of my virtual advent calendar, about stuff I like in SQL Server 2008.. If it aint broke don’t fix it, is probably best aimed at Integration Services in SQL Server 2008. So what was ‘fixed’? The most important thing was the performance of lookups, both in terms of speed and memory usage. ...
14 Dec 2008
SQL Server Advent Calendar 13 – Grouping Sets
Day 13 of my virtual advent calendar, about stuff I like in SQL Server 2008.. The SQL Group by clause has been around since I can remember, but in SQL Server 2008 we know have grouping sets. Imagine you wanted to sum sales amount from the adventure works reseller sales table by year, by Product...
13 Dec 2008
SQL Server Advent Calendar 2 – Time
Day 2 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Following on from my previous post, in some data warehouses there is a separate dimension for time of day, so that demand through a day can be modelled. Storing time in SQL server 2005 was a bit of a cludge typically involving...
2 Dec 2008
SQL Server Advent Calendar 1 – Dates
There is no possible connection between databases and Christmas, so I simply wanted to share 24 my favourite bits and bobs that are in SQL Server 2008…. The new date data types in SQL server crack a problem I have had since I started BI as there is (nearly) always a time dimension in every data warehouse...
1 Dec 2008
Talking about Business Intelligence to your FD part 1
As I have remarked before Business isn’t run by the IT Department it is run by the people who hire and fire the IT department i.e. the Finance Director (FD). Given the current economic climate now would be a perfect time to see what you can do to help, so I have spent the morning listening to my FD ...
17 Nov 2008
SQL Server 2008 Merge and Integration Services
The new Merge T-SQL command has great potential in a data warehouse scenario and Integration Services is the tool in SQL Server to load the data warehouse so how do they fit together in SQL Server 2008? The answer is not really and I am not sure they should, so let me explain why. Integration Services...
6 Oct 2008
Data Warehousing from the Experts.
If you glance to the side of this post you will see that one of the few books on my bookshelf is the Microsoft Data Warehouse Toolkit , and so I am annoyed that I can’t make the course of the book, presented by the authors, Joy Mundy and Warren Thornthwaite . For those not familiar with these two eminent...
2 Sep 2008
64 bit odbc connectivity to SQL Server
Working for Microsoft is strangely like working for the government, yu are essentially trying to please everyone, but there are significant minorities on any given issue who aren’t that satisfied. Let me explain with a real world example.. The lack of 64 bit jet and odbc drivers mean that anyone trying...
27 Aug 2008
Using TinyInt as keys in Analysis Services
Fact tables should be narrow and deep. If you are recording every debit card transaction for every customer across the fifteen retail banks you own, you end up with 15 million rows a day, so to save space they need to be as thin as possible. If one of your dimensions can only ever have a...
30 May 2008
Page 1 of 2 (34 items)
© 2013 Microsoft Corporation.
Privacy & Cookies
See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support by product
Forefront Edge Security
Forefront Server Security
Other support links
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums