Top Support Solutions for Microsoft Application Virtualization (App-V)

Posted on Updated on

By Mary Hutson

Here is a list of the top Microsoft Support solutions for the most common issues experienced when you use Microsoft Application Virtualization (App-V).

1. Solutions related to application does not function as expected:

2. Solutions related to application does not load or run:

3. Solutions related to App-V Sequencer setup, configuration, and use

4. Solutions related to application error, hang, or crash:

5. Solutions related to application publishing:

Advertisements

Power Query Super Charges the Internet

Posted on

by Matt Allington

I guess most of the readers of PowerPivotPro.com will already have a pretty good idea that Power Query is awesome.  I spent time recently thinking about how Power Query has really opened up the data on the Internet and made it more accessible to us all.  It reminded me of something I worked on a couple of years ago when I first discovered Power Query. I want to share my journey from back then to demonstrate the point about how Power Query really “Super Charges” the Internet – and because the example is just cool.

First the background

The long story short is that I was frustrated one day when SalesForce.com released its “Spring” release of its software.  Now as someone that lives in the southern hemisphere, giving a software release a “northern hemisphere” season for a name is totally meaningless – let alone completely confusing.  Anyway in my rage (and spare time), I set about trying to find out what percentage of the world population experiences “southern hemisphere” seasons (go figure why! – I’m just like that sometimes).

Anyway, in my journey I found a link to a NASA website that provided tables of data with the total population of the world at every 1 degree of longitude and every 2 degrees of latitude.  So basically it was just a big text file 360 columns wide and 180 rows long, with each number being the population in that 2 degree square surface area of the earth – just what I needed to check the population in each hemisphere.

The text file looks exactly like this (but bigger of course).

data

So using Power Query I converted the text file and parsed the awkward data into usable data in Excel.  Once I had the data into Excel, it was easy to write a couple of formulae to work out the answer.  For the record, the answer was “not many” – less than 6% actually vs 79% for the northern hemisphere seasons (I guess it is acceptable to name your software after a “northern hemisphere” season after all – by a factor of 13 to 1).  Note the balance making up 100% live in the tropics.

But then I had an idea – I wondered what this spreadsheet would look like if I applied conditional formatting over the top of the data. So I made the columns really narrow (about 2.0 wide) and then applied standard conditional formatting over the top, and to my pleasant surprise it looked like the image below.   This image is simply a spreadsheet of values converted with Power Query from the text file above with conditional formatting applied.

world

Now the reason the ocean is green is because each of these cells has a zero value – makes sense I guess – zero population in the sea.  So I decided to remove all those zeros and replace them with null (again using the transformation tools in Power Query) to see what that looked like, and I ended up with a more granular level of detail as shown in the image below.  Power Map eat your heart out!

world2

Here is the spreadsheet if you want to take a look for yourself.

So what sparks your interest to explore?

There are a couple of key points about all this.  Firstly there is a wealth of data available on the Internet.  I guess we all know this already.  But with the arrival of Power Query it has never been easier to get this data into Excel – from whatever format it is in (a TXT file in this case) – into something that you can actually use.

Hopefully this has inspired a few people to think about data they are interested in and do some recreational analysis.  I would love to hear of any interesting data sets other people find and have been able to use.  http://www.gapminder.org/ is one of my favourites.

ooops!

Posted on

totally misunderstood…

the availability of System Center 2012 R2 Configuration Manager SP1 and System Center 2012 Configuration Manager SP2

Posted on

http://blogs.technet.com/b/configmgrteam/archive/2015/05/14/announcing-the-availability-of-sysctr-2012-r2-configmgr-sp1-and-sysctr-2012-configmgr-sp2.aspx

below from MS:

System Center 2012 R2 Configuration Manager SP1 and System Center 2012 Configuration Manager SP2 are now generally available and can be downloaded on the Microsoft Evaluation Center. These service packs deliver full compatibility with existing features for Windows 10 deployment, upgrade, and management.

Also included in these service packs are new hybrid features for customers using System Center Configuration Manager integrated with Microsoft Intune to manage devices. Some of the hybrid features that you can expect to see are conditional access policy, mobile application management, and support for Apple Device Enrollment Program (DEP). You can view the full list of hybrid features included in these service packs here.

Below are a few additional links that you may find helpful as you begin to explore these new releases.

MSDN subscribers can expect these service pack downloads to be available next week.

We hope you enjoy these new releases!

Thanks,

The System Center Configuration Manager Team

Performance Series | EP1, The Basics: How IT Pros Troubleshoot Slow PC’s and Servers (or, how they SHOULD)

Posted on