Skype for Business
See all products »
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
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
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
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
Azure Machine Learning
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 Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
Data, no use at all without a catalog
About a decade a go I went on a Microsoft BI boot camp which was also attended by Microsoft staff specifically Matthew Stephen and Rob Gray who inspired me to work towards joining Microsoft myself. Two years later I got in and haven’t looked back and I still track Matt on LinkedIn, so I was very interested...
6 Oct 2015
Cortana - Remembering the Future
If you have ever watched the Star Trek First Contact film the crew allude to the fact that the star ship Enterprise is named after the first space shuttle, when actually it’s the other way around the first space shuttle was so named because over 2 million star trek fans lobbied NASA to call it Enterprise...
2 Sep 2015
Azure Data Services for (near) Real Time Scenarios
Light takes about 8 and half minutes to get from the surface sun to the earth and it can actually take a photon 20,000 years to get form the core of the sun to the surface. On earth that means that if the sun stops shining we wont know about it until eight and a half minutes after and begs the question...
16 Jul 2015
Azure Data Services–what are they?
This might be a recurring theme but worth mentioning again - Azure continues to change and expand at an alarming rate. On the one hand this is simply scale, for example we now have access to bigger compute resources like the G class virtual machines, ever cheaper storage, and higher and higher limits...
9 Apr 2015
Machine Learning for the Business Intelligence developer
Amy (the other half of the data duo in our team) and I have been gate crashing the Data Culture series and other events recently to see who’s interested in Azure Machine Learning (MAML) . It turns out that data scientists are pretty comfortable using their own tools and scripts be that in R and Python...
26 Feb 2015
Azure Machine Learning – General Availability
Today Microsoft Azure Machine Learning (MAML)goes from preview to general availability and it’s also undergone quite a few changes on the way. Before I get into what’s new (and there is quite a lot) I do occasionally get feedback that Azure services are evolving too quickly for everyone to keep up. I...
16 Feb 2015
How to train your MAML–Redux
Since I wrote this series we have taken on two computer science graduates in the evangelism team in the UK, Amy Nicholson and Bianca Furtuna. Both studied machine learning as part of their courses so I introduced them to this series on Azure ML to get them up to speed. They have taken this series apart...
12 Dec 2014
How to train your maml – Publishing your work
Before I get into my next post you may have noticed that ML has changed compared with a few weeks ago -the main page previews experiments differently, and the visualization of data has also changed.. One other problem hit me and that was some of the parts of my demo experiment didn’t work or ran really...
10 Nov 2014
Future Decoded – with Data Science
If you have been following my posts on Microsoft’s approach to data science with things like Machine Learning you’ll realise that it’s capable of making predictions. However to be honest it’s not going to tell you what devices and career you’ll have in five years time. To do that you need expert humans...
6 Oct 2014
How to train your MAML
In this fourth post in my Azure Machine Learning series we are actually going to do the training itself. I have tidied up my experiment from last time to get rid of the modules to export data to SQL Azure as that has now served it’s purpose .. Before we get stuck into training there’s still a bit more...
1 Oct 2014
How to train your MAML – Looking at the data in SQL Azure
In my last post we saw how to clean, transform and join datasets. I also mentioned I had trouble doing the join at all and even now it’s not quite right so how can we look at the data and find out what’s going on. The visualisation option only shows a few rows of the 2 million in the dataset and there...
25 Sep 2014
How to Train your MAML–Refining the data
In my last post we looked at how to load data into Microsoft Azure Machine Learning using the browser based ML Studio. We also started to look at the data around predicting delayed flights and identified some problems with it and this post is all about getting the data into the right shape to ensure...
19 Sep 2014
How to train your MAML – Importing data
In my last post I split the process of using Microsoft Azure Machine Learning (MAML) down to four steps: Import the data Refine the data Build a model Put the model into production. Now I want to go deeper into each of these steps so that you can start to explore and evaluate how this might be useful...
26 Aug 2014
My title for this post is a pun on the Adventure Works databases, and samples that have been in SQL Server since I can remember. There were also some data mining examples ( as referenced in this old post ) but this has not really moved on since 2011 when I last wrote about it so you might be forgiven...
1 Aug 2014
Cast and Convert
In SQL server the Cast and Convert functions change one type of data to another. A pod cast is the art of converting knowledge into sounds so that's the tenuous link for this post. Pod casting is not something I have ever tried, but the security expert on our team, Steve Lamb sees himself as the next...
11 Sep 2007
Integration, Integration, Integration
Microsoft is all about choice, so instead of having one way of shifting data between two different platforms we have three. I get asked about two of these a lot but I also wanted to discuss the latest tool in this space to make sense of all them and understand when to use what: Integration Services...
14 Jul 2010
Are we spending too much time with Excel?
Despite my love of SQL Server and my respect for Oracle, and MySQL the worlds number one database is excel. I know that many purists and DBA’s will shudder at me grouping a spreadsheet with a database, but look at this form the perspective of number of hours of users using excel and the volume...
15 May 2008
Lean and Mean
When you build a cube in analysis services it is very easy to expose every attribute in every dimension to the user. You can also add-in every measure and if you don't feel that's enough then you can create your own calculated members to add to the users' fun. Once you have given the users every thing...
18 Sep 2007
Grain - The devil is in the detail
Technorati Tags: BI , Business Intelligence , OLAP , SQL server 2008 Business Intelligence is just like digital photography, the more detail you want the more space you are going to use and in both cases we talk about grain and granularity. If you have ever worked with RAW files on a 'Prosumer' (an IT...
23 Aug 2007
One Version of the Truth
One of the most over used phrases in Business Intelligence is "one version of the truth" so I thought it would be good to discuss why it's important and what IT professionals can do to achieve it. In an imaginary organisation like adventure works there would be several line of business systems such as...
13 Sep 2007
Performance Point Server - Counting the Cost
I am ploughing through my inbox now I am not on the road anymore, and I have picked up quite a lot of flak around the costs of Performance Point. I have passed specific queries on to the licensing guys, but the sort of thing I was getting both on-line and off-line form the TechNet road shows was...
12 Dec 2007
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...
7 Feb 2012
Business Intelligence for the Private Cloud part 1
If you have looked at any of the new components of System Center 2012 you may have noticed that everyone seems to have a bunch of reports, some of them have data marts or data warehouses and some of them have analytics in the form of analysis services cubes. Apart from the confusion over when to...
30 Apr 2012
Using Hyper-V to make a demo sandbox part 2
Continuing from my last post about using Hyper-V for demos, I recognise that many people try and just create one VM with everything Microsoft BI rammed into it. Ram being the operative word as it’s RAM your most likely to be short of particularly on a laptop. If you want to run SQL Server (with all the...
15 Mar 2010
Performance Point 2007
16 October will be the UK launch for Performance Point 2007 which is going to illicit three reactions: Fantabidozoo it's out at last! Oh oh Microsoft have released another thingy that costs half as much as our whatsit so let's get marketing to tell everyone that it doesn't scale for the enterprise and...
30 Aug 2007
© 2015 Microsoft Corporation.
Privacy & Cookies