Azure SQL Edge

What Is Azure SQL Database Edge

In this Azure tutorial, we will discuss all about Azure SQL Edge.

What Is Azure SQL Edge

Azure SQL Edge is an optimized relational database engine designed for IoT and IoT Edge deployments. With the help of the Azure SQL Edge database, you can create excellent data storage and processing layers for different IoT applications.

Nevertheless, the Azure SQL database edge also helps you with the capability to analyze, stream, and process-relational and non-relational data.

The exciting part is, that Azure SQL database Edge is built on the SQL server database engine that provides the query processing capabilities, and you can use the same T-SQL programming as SQL Server.

What are the available editions of Azure SQL Edge?

Two editions of Azure SQL Edge are available as of now. Below are those two editions of the Azure SQL Edge database

  • Azure SQL Edge: This is primarily for the production SKU, and the SQL edge container has 64 GB memory and is limited to 8 cores.
  • Azure SQL Edge Developer: As the name suggests, this is for the Development only SKU. Here, the SQL Edge container has 32 GB memory and is limited to 4 cores.

Azure SQL Edge Deployment Models

Azure SQL Edge supports two deployment models. Those are as below

  • Disconnected deployment: With the help of the Disconnected deployment, you can pull the Azure SQL edge container images from the docker hub, and then you can deploy as a standalone docker container or a Kubernetes cluster
  • Connected deployment through Azure IoT Edge: Note that you can find the Azure SQL edge in the Azure Marketplace, and for the Azure IoT Edge, you can deploy it as a module.

Features Of Azure SQL Edge

Azure SQL Edge provides us with many features. Let’s discuss a few key features of the Azure SQL Edge database.

  • The first thing is the Azure SQL Edge database is generally available now.
  • Azure SQL edge database has an inbuilt streaming capability that helps you with complex event processing and real-time analytics.
  • In the same way, Azure SQL Edge also provides you with the most demanding machine learning and artificial intelligence capabilities.

What are the tools can be used to work with Azure SQL Edge

Different tools can be used to work with the Azure SQL Edge. Below are a few key tools you can use to work with Azure SQL Edge.

Azure SQL Edge Pricing

The pricing structure for the Azure SQL Edge is as below

Details of ProductPer month1 Year3 Years
Azure SQL Database EdgeYou need to pay $10.001/device per monthYou need to pay $100 per device per yearYou need to pay $60 per device per year

How To Deploy Azure SQL Edge Using Azure Portal

Well, We can deploy Azure SQL Edge using Docker or Azure Portal. We will discuss here How to deploy Azure SQL Edge through Azure Portal. As part of the functionality, you must consider the prerequisites below.

Prerequisites

  • You must have an Azure subscription or Azure account. If you don’t have an Azure account till now, you can create an Azure Free account now.
  • You must create an Azure IoT Hub.
  • You need to create an Azure IoT Edge Device.

Creating An Azure IoT Hub

Follow the below steps to create an Azure IoT Hub in Azure Portal.

  1. Log in to the Azure Portal (https://portal.azure.com/).
  2. Once you have logged in to the Azure Portal, search for the IoT Hub. Click on the Search result IoT Hub as highlighted below.
azure sql edge vs sql server

3. On the IoT Hub page, click the + Create button to create the IoT hub.

what is azure sql edge

4. Provide the below details on the IoT hub page.

  • Subscription: Select a valid subscription that you want to use here to create an Azure IoT Hub.
  • Resource Group: You can select an existing resource group, or if you don’t have a resource group created now, you can click on the Create new link to create a new resource group.
  • Region: Provide the region.
  • IoT hub name: Provide a unique name for the IoT hub.

Click the Next: Networking > button to go to the Networking tab.

azure sql edge

5. On the Networking tab, choose the default Public endpoint (all networks) or Private endpoint based on your requirements. Click the Next: Management > button to go to the Management tab.

sql edge vs sql server

6. On the management tab, provide the below details.

  • Pricing and scale tier: Choose the pricing tier based on your requirements.
  • Number of S1 IoT hub units: Choose this option based on your need.
  • Defender for IoT: You can enable this option to enable extra protection for your IoT Hub.

Click the Next: Tags> button to go to the Tags tab.

edge database

On the Tags tab, you can mention the name and value pairs to tag the resources, or you can leave the option as it is and then click on the Review + Create button.

Now, it will validate all the options provided by you, and then the Create button will be enabled. You can click the Create button on the next screen to create the IoT hub.

It will take a few seconds to show you that Your deployment is complete. Click on the Go to Resource button to navigate to the IoT hub we created just before.

sql edge

Creating An Azure IoT Edge Device

You can easily create an Azure IoT Edge device now.

We have created the Azure IoT Hub and the Azure IoT Edge Device. Now is the time to create the Target Devices for IoT Edge Module. Follow the below steps

Creating Azure SQL Edge

  • Log in to the Azure Portal (https://portal.azure.com/).
  • Search for the Azure SQL Edge and then click on the search result Azure SQL Edge.
How to create Azure SQL Database Edge

On the Target Devices for IoT Edge Module page, Provide the below details

  • Subscription: Provide a valid subscription.
  • IoT Hub: Select the name of the IoT Hub we created above.
  • Deploy to a device: Select the option to deploy to a device.
  • IoT Edge Device Name: Provide the name of the IoT Edge device we created just above. Then, you can click on the Find Device button.

Finally, click on the Create button.

docker hub azure sql edge

You may also like following the articles below

Wrapping Up

In this article, we have discussed all about Azure SQL Edge. I hope you have enjoyed this article !!!