Cloud Price Calculator Azure vs AWS vs Google

Came across this amazing website which provides a price calculator to estimate the cost of workloads on different public clouds. You need to fill the online form with different parameters like number of instances, their specs (RAM, CPU, DISK etc), geographic location, duration etc. After submitting the form, it gives a detailed report suggesting which VM template to use in the cloud and how much it will cost in different time durations. By default it gives pricing for Azure, AWS and Google public cloud , but you can add more cloud providers a well.

A must have resource for cloud professionals: https://calculator.unigma.com

EntityException: The underlying provider failed on Open

 Issue: When you try to launch a local ASP.NET MVC web application on Azure you receive following error:

[EntityException: The underlying provider failed on Open.]
   …http://System.Data.Entity.Core.EntityClient.EntityConnection.Open () +324
   http://ASP.NET _MVC5_Bootstrap_3._3._4_LESS1.Controllers.farmersController.Index(String sortOrder, String searchString, Nullable`1 page, String currentFilter) +99
SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)

Cause: Most probably this issue occurs when web application is attempts to reference a local database, which it wouldn't find which is causing that error.

Solution: To resolve above issue follow these steps:
1. Go to Azure Portal > Web App > settings > Application Settings.
2. Under connection strings verify that the connection string was correctly deployed.