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
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...
30 Jun 2009
The Office Ribbon
Why are people in this country so glued to the imperial system of measurement? are they easier to use compared to metric (SI) units? e.g. How many cubic inches/ pints quarts does the engine in your car have? How heavy is a gallon of water? How many cubic yards of gravel do I need for my drive...
19 Jan 2010
Five New Year’s Resolutions for 2011
I think a lot of people, IT Professionals included are worried about the year ahead, so here are some likely problems and my new year resolutions: Energy prices are spiralling This means the cost of moving whole atoms rather than just electrons is even more pronounced than ever, so moving data...
4 Jan 2011
I hope my PowerPivot posts and videos are proving useful, and continuing this them I want to cover off installation. PowerPivot for Excel is a free download for Excel 2010 and simply doesn’t need any edition of SQL Server behind it. It comes in 32 bit and 64 bit depending on which variant of Excel...
5 Feb 2010
A lot of people who use facebook also use Office so Microsoft Fuse labs have used Azure to provide Office document sharing between facebook users in much the same way as facebook users can now share pictures and videos. I Simply went to http://docs.com and signed in with my facebook account to get started...
28 Jul 2010
Microsoft Free Software – a personal top ten
You might think this will would make for a really short article post but actually there’s a huge amount of free tools and resource out there and I have had to restrict myself to a top ten across the server and client, based on what Simon and I have used. So please feel free to...
22 May 2013
A lot of teenagers are on work experience at the moment, and as I don’t have any of my own children I got to be cool uncle for a week and took my nephew Harry to spend a week inside Microsoft. We run a full week course of lectures and practical exercises along the lines of the apprentice, to teach...
14 Jul 2009
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
PowerPivot is Integration Services sort of
One of the key problems in BI is getting your data together and cleaning it, and one of the best tools for doing this at scale would be integration services in SQL Server. However integration services is too complicated for the average business user but these users do need something to load and prepare...
20 Jan 2010
PowerPivot is Analysis Services, sort of
PowerPivot is essentially a way of making an analysis services cube using excel as the design tool. When you use the PowerPivot for Excel add-in, then there no backend dependency, but if you want to save a PowerPivot to SharePoint 2010, there has to be a special installation of SQL Server 2008 R2 analysis...
21 Jan 2010
Education education education at BETT 2010
I have spent the last four days on the Microsoft stand at a huge education show (BETT 2010) to field technical questions on Windows 7 and Office 2010. I take my hat off to the IT Pro’s working in schools as they have to cope with all kinds of applications and hardware and usually there are only one or...
18 Jan 2010
The most important thing about PowerPivot is the ability to share users analysis into SharePoint so that these other users can slice and data form within a browser. As I’ve said before this uses SQL Server analysis services behind the scenes, albeit as part of a special install option. I...
22 Jan 2010
Access - Office angel or spawn of satan
My first introduction to Access was a painful experience, not because of the product itself but the way it was used, so it was mixed feelings that I read up on the official Access blog what it will look like in Office 2010. Yippee it’s going to be 64 bit , so it will be easy load data form it and...
30 Jul 2009
Work Life Balance in Office
For me the office is Microsoft Office as my litmus test for whether I am working or not is what I am doing not where I am. The final bit of Office 2010 is still in beta – Office Communicator 2010 and I have been pestering the development team to get on the internal dogfood to...
16 Aug 2010
© 2015 Microsoft Corporation.
Privacy & Cookies