Microsoft Azure Essentials: Azure Web Apps for Developers – Free ebook

Microsoft Azure brings so many services to your fingertips in a reliable, secure, and environmentally sustainable way. You can do immense things with Azure, such as create a single VM with 32TB of storage driving more than 50,000 IOPS or utilize hundreds of thousands of CPU cores to solve your most difficult computational problems.


Posted in .Net, Community | Tagged , | Leave a comment

Linking Excel Cell to another Excel file in OneDrive

This short article shows you to link 2 Excel workbooks in OneDrive is feasible.

I created 2 Excel files in OneDrive one named Book1Linked.xlsx and another named Book1Linking.xlsx.


I then linked a cell B3 in Book1Linking.xlsx to B5 cell in Book1Linked.xlsx without any issue.


The only condition is that you need to use OneDrive app There may be other alternatives that I am not aware of.

Posted in Community, Microsoft Office | Tagged , , | 2 Comments

Access OneDrive from Windows Explorer in Windows 8.1

This short article shows you how to access OneDrive from Windows Explorer in Windows 8.1.

When you want to download the OneDrive app from the Internet,, you will the site written OneDrive comes preinstalled on Windows 8.1.  OneDrive is not supported on Windows XP.


Somehow you cannot see the OneDrive in your Windows Explorer.

In order to see OneDrive in Windows Explorer, you need to Connect to a Microsoft Account by Change PC Settings.


Posted in .Net, Community, Operating System | Tagged , , , , | Leave a comment

Cannot find Windows Update in Windows 10

This short article shows you where to find Windows Update in Windows 10.

Open Windows Explorer, make sure you select your computer, and click on Open Settings.


In the Settings Window click Update and Recovery.


Posted in .Net, Community, Operating System | Tagged , , , , , , , | Leave a comment

401 Unauthorized when using Self-Signed certificate in SharePoint 2013

This short article is showing you how to configure SharePoint Site to support SSL.

If you create a Self-Signed Certificate from IIS and bind directly to the SharePoint site then you will get 401 Unauthorized error like me.

You need to performance all the steps following this article

Below are the summary without graphic. 

Step 1 Create Self Signed Certificate on IIS 8

Open IIS Manager and then go to Server name and choose IIS Section “Server Certificates”

Click on Create Self-Signed Certificate… on Actions pane

Specify a name like “SharePointSelfSignedCert” and click Ok

Double click on this created Certificate and go to details Tab and click Copy to File…

Click Next (Welcome…),

Select No, do not export the private key and click Next ,

Select DER encoded binary and click Next,

Specify the location for the certificate and Click Next and then finish (Imported).

Step 2: Import Self Signed Certificate to SharePoint Certificate store

Open Manage Compute Certificate on Windows Server 2012 and go to SharePoint node and then right click All tasks >> import 

Click Next and then specify the location of exported certificate in previous step and then Click Next,

Make sure Certificate store is SharePoint and Click Next and then finish (Exported)

Step 3: Add Self Signed Certificate to trust management in Central Administration

Go to Central Administration >> Security >> Manage Trust (to inform SharePoint to trust this certificate also).

And Click New

And a name and specify the location for the certificate and Click Ok.

Step 4: Configure IIS Binding

Go to IIS Manager and choose your web application and then click on Binding in Actions pane

Click Add..

Type: Https

SSL Certificate: SharePointSlefSignedCert (which created previously).

Click Ok.

Step 5: Configure AAM

Go Central Administration >> Alternate Access Mapping and Choose your web application

And click on Edit Public URLs and then add HTTPS URL

And Click Save.

Now try to brows your site with HTTPS URL

Posted in .Net, Community | Tagged , , | Leave a comment

Sideloading of apps is not enabled on this site – SharePoint Online

This short article shows how to resolve the error “Sideloading of apps is not enabled on this site”.

When you can Start to run in your App for SharePoint then you might get the error “Sideloading of apps is not enabled on this site”.

You will find few links for this solution but some of them when you copy and paste the code into your notepad then it becomes a nightmare. The one that copy and paste and will run straightaway is this one

After run the PowerShell Script you should be able to run your app.


You can also download a single solution from The sample file name is sideload.ps1. My MSN ID is

Posted in .Net, Community | Tagged , , , | Leave a comment

Free ebook: Microsoft System Center Data Protection for the Hybrid Cloud

If you are responsible for architecting and designing the backup strategy for your organization, especially if you’re looking for ways to incorporate cloud backup into your business continuity scenarios, this book is for you. With the increasing trends in virtualization as well as the move to the pubic cloud, IT organizations are headed toward a world where data and applications run in on-premises private clouds as well as in the public cloud. This has key implications for data protection strategy, and it is important to choose the solution that provides the same level of data protection you have afforded so far while allowing you to harness the power of the public cloud.

Posted in .Net, Community | Tagged , | Leave a comment