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
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 Phone 7
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
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
Reporting Services - Nothing to see please move along
Sometimes when you run a report it’s not going to return any rows, perhaps because the user selected a filter for which there is no data, and that needs to be handled properly. Fortunately there’s a simple way to control the messaging when this occurs to ensure your users know what’s happened and...
16 Apr 2009
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
the BI Sematic Model in SQL Server Denali ctp3
Some sort of semantic model is needed in every BI solution but what is it and why do I need one? It’s a view of the data store(s) you want to work on for business intelligence which adds additional information that can be stored in the individual tables themselves. For example how are the...
25 Jul 2011
SQL Bits 11 - Notes & Queries
If you didn’t manage to fight your fight your way through the Everton & Liverpool fans to SQL Bits I thought you might like to see some of the random questions I got asked.. How do I manage SQL Azure? I think the key thing about developing for the cloud is to ensure that your application can handle...
3 Oct 2011
I am a pretty good cook (not as good as our chef in residence Marc ) but I don’t practice enough so I wanted to get back up to speed to help out while my wife works on her OU degree and to explain PowerPivot. I have posted this video on YouTube.. ";" mce_src="http://blogs.technet.com...
25 Jan 2010
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 up an an early olap product called HOLOS and he couldn't see how the dimensional model I was presenting was ever going to work. If we had been using HOLOS, and pretty well any other OLAP engine including...
3 Sep 2007
Analysis Services Backup
Backing up a cube is not an ideal experience in SQL Server 2005 for two reasons, it’s a manual process to schedule a backup and as the size of the cube grows the backup time increases exponentially i.e double the size of the cube and the backup time and size will increase by a factor of four. Curiously...
20 Aug 2008
A big thanks to all the IT professionals out who spotted my poor English in the 27 th Sep Technet flash from George and in this post . Intelli-sense is still no substitute for intelligence, but I do quite like the idea of Illicit feedback rather than elicit feedback! I also got an e-mail questioning...
28 Sep 2007
Business Intelligence for Small Business – Analysis
If you have been following this blog over the last few days, then we are at the stage we know what we want to measure to get the pulse of our business and we have all of that on a scorecard. However just because we are measuring performance doesn’t mean our work is done. What do we do when we notice...
9 Sep 2008
Oh no it’s the BI Acquisition..
My first experience of ‘proper’ databases was using Ingres back in 1994 while working for an obscure part of Customs & Excise (as it was). We could get a soundex person search from Inverness to return probable matches in under 8 secs from the central server in Southend which had 48 million...
28 Jul 2008
Business Intelligence - Why Bother?
If you're staying with this Business Intelligence (BI) 101 discussion, you are probably wondering why bother? No that doesn't mean why bother with this blog but why bother with BI at all. Businesses need reliable information in order to survive and thrive, and business users need this when they want...
9 Aug 2007
SQL Server 2012 editions and dependencies
You may have seen that there are going to be some changes to the way SQL Server 2012 is licensed and the editions available, if you haven’t then the detail is here . What I want to cover off in this post is what the various new features depend on so you are clear on what else you need besides the...
8 Nov 2011
Microsoft BI and Kerberos
I was briefing a bunch of partners the other day, and during coffee I went off piste and did a short overview of my presentation “It’s not about the Technology” to the BI MSc course at Dundee University. However sometimes technology does get in the way especially when it comes to implementation...
5 Dec 2010
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
SQL Server Reporting Services–if it’s important look after it
Before I can commit funds to a new project be it at work or at home I need to know I can afford it; specifically is there enough money in the budget and to find that out I need to run a report. This is what’s meant by operational reporting and this distinction means that this report can be considered...
24 Aug 2011
Microsoft Business Intelligence without SharePoint
This might be a strange topic given that the release of SharePoint 2010 is just around the corner, but I wanted to respond to a couple of questions and debates I have been involved with in my temporary role in the partner team. I would like to start by going back to the early days of Microsoft BI, analysis...
12 Apr 2010
© 2014 Microsoft Corporation.
Privacy & Cookies