SharePoint document cache

If you are opening SharePoint document from Office App, it may open the file from cache and miss to get the updated version document from SharePoint, this is due to the fact Microsoft cache the SharePoint documents.

You can see icon in system tray

In the Upload Center, you can select Settings, Click on Delete cached files to remove the cached files.

More information here.

Self Service BI–Excel Rocks!!

Microsoft is coming with lot of Self Service BI tools the recent addition is Data Explorer.

In Excel now you have the following component for Data Analysis

• PowerView: You can same experience as SharePoint integrated PowerView inside excel for the data in Excel Sheet
• PowerPivot with powerful DAX Support: There are lot of content on Web on this.
• Data Explorer Download

Data Explorer try to standardize and customize data consumption experience.  There are many new data sources added, For example “Folder”, SharePoint List, Hadoop file, SQL Azure, Facebook.

Query on Active Directory are really an interesting new way of getting data

Facebook Graph API support

• GeoFlow Download | Getting Started Document.

7 years back I have worked on POC called Mappy with HCL Technologies, the fundamentals are exactly same.  Great to see it is a product now from Microsoft.

Azure Training

There are really rick training material in Channel9 to ramp up in Azure.

Introduction Trainings

1. Windows Azure Overview
2. Introduction to Compute
3. Windows Azure Lifecycle, Part 1
4. Windows Azure Lifecycle, Part 2
5. Windows Azure Storage, Part 1
6. Windows Azure Storage, Part 2
7. Introduction to SQL Azure
8. Windows Azure Diagnostics
9. Windows Azure Security, Part 1
10. Windows Azure Security, Part 2
11. Scalability, Caching & Elasticity, Part 1
12. Scalability, Caching & Elasticity, Part 2, and Q&A

Intermediate Trainings

• SharePoint on Windows Azure
• Azure Service Bus
• Mobile Services (27 Parts)
• Web Sites (7 Parts)
• Windows Azure Active Directory (4 parts)
• Getting Started with HDInsight (3 Parts)
• Media Services (4 Parts)
• Cloud Services (8 parts)
• Storage and SQL DB (9 Parts)

Advanced Trainings

• Cloud Patterns (3 Parts)
• VM & Networking (4 parts)
• Customer Success Stories (4 Parts)

Visual Studio 2012 Treasures

Recently got an opportunity to talk about Visual Studio 2012 features to one of the reputed IT division head.  The wealth of features VS2012 provides are amazing, making use of the at right time helps the organization and individuals.  Here is quick summary.

• TFS Features
  • Agile Template: One of the must try feature, helps to manage product backlog, capacity planning, Employee Task list view, Drag & drop status update.

• Code Review: A productive, quality improvement which nice code review workflow, contextual comment, tight integration with TFS.  Amazing feature.

• My Workspace

• VS2012
• IDE Search capabilities

• Code Visualization

• Code Analysis

• IntelliTrace

To get the complete list of new feature check out the Visual Studio Ultimate 2012 Overview videos.