SSL Connection Error with Azure Hybrid Connection

When we added a hybrid connection to our Azure App Service using an Azure Resource Manager (ARM) template, we were greeted by a very difficult to solve error message, “The SSL connection could not be established.”

The architecture of the application is very similar to the diagram depicted by Microsoft’s documentation on Azure App Service Hybrid Connections. There is a web API hosted in Azure App Service that uses a relay hybrid connection to call an on-premise API.

Read more

Using Azure Cloud Shell

The Azure Cloud Shell allows you to run commands in Azure without installing any additional software on your computer. All that you need is a web browser. If you have the Azure mobile app, then you can run commands in Azure directly from your phone.

For instance, let’s say that you’re waiting for your flight at the airport while traveling to a conference showcasing the latest Azure features when you realize that you forgot to create a virtual machine (VM) as part of your task on a user story. You already have the command saved in a file on your laptop from creating the same VM a week ago, so you pull out your laptop, boot it up, log in to the Azure Portal, then execute the command in Azure Cloud Shell. After that, you close your laptop and board the plane.

Let’s do a walk-through of these steps using Azure Cloud Shell to create a VM. If this is the first time that you’ve used Azure Cloud Shell, then there are some prompts that you need to get through. So, let’s get to it.

Read more

Quicksteps to Profiling Entity Framework Queries in SQL Server

When creating an application with an ORM framework, such as Entity Framework, it’s a good idea to look at the SQL that’s actually being sent to the server. This is a critical step that can be easily overlooked.

Why is it important to look at the SQL? Well, if we don’t look at the SQL, then we can end up with queries that join ten different tables and return rows with more than 100 columns. Unless your machine has unlimited resources, then we should strive to keep our queries resource-friendly.

Read more