configuring the BLOB cache SharePoint Performance

BLOB cache needs to be enabled in the front end web server(IIS) and once configured; the frequent files used in sharepoint will be retrieved from the database and stored in a directory under Front end web server (IIS). This reduces the network traffic/load on the database server as the frequent files will be stored into disk .Got to WebApplication web.config file search for <BlobCache>

<BlobCache location="C:\BlobCache\14" path="\.(gif|jpg|jpeg|jpe|jfif|bmp|dib|tif|tiff|themedbmp|themedcss|themedgif|themedjpg|
themedpng|ico|png|wdp|hdp|css|js|asf|avi|flv|m4v|mov|mp3|mp4|mpeg|mpg|rm|rmvb|wma
|wmv|ogg|ogv|oga|webm|xap)$" maxSize="100" enabled="false" />

Sql Command to find product version and Edition

I was goggling for to find the current product version of Sql server several times in my environment .And I was the forget the query several times being human. So decided to save on web
SELECT
            SERVERPROPERTY('ProductVersion') AS ProductVersion,
            SERVERPROPERTY('ProductLevel') AS ProductLevel,
            SERVERPROPERTY('Edition') AS Edition,
            SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
            SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion' 
GO

Never expires Password in cloud identities with Windows PowerShell

After importing the user from  Azure Active Directory I had written the below command for making the user password gets never expired.

Never expires password: 
Get-MsolUser | Set-MsolUser –PasswordNeverExpires $true

Changing Password in cloud identities with Windows PowerShell

I had come ac-crossed to the accounts which are stored within Azure Active Directory and they need to be integrated in office 365.I imported bulk users specially formatted CSV file into Office 365.After importing the user I had changed the password for the particular user with below command

Changing Password: 

Set-MsolUserPassword –UserPrincipalName sid.ali@spadministration.onmicrosoft.com

–NewPassword Pa$$w0rd –ForceChangePassword $true

Unable To Locate Package Source

Recently while installing visual studio 2012 ultimate I had come ac crossed to the error
"Unable To Locate Package Source" .

Solution:  Install latest update version of Visual Studio 2012  . Then run the visual studio 2012 with admin privileges  and select modify option to resume the installation

Microsoft SharePoint Development Reference and code practices

https://msdn.microsoft.com/en-US/library/office/dn833469

Microsoft Power Query & Power Map for Excel 2013 add-on

Microsoft Power Query for Excel 2013 add-on:

http://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=5b29a047-9a4d-41ff-a961-39f0979eca7a

Power Map Preview for Excel 2013 add-on:

http://www.microsoft.com/en-in/download/details.aspx?id=38395