In this Azure tutorial, we will discuss all about Azure SQL Edge.
Table of Contents
- What Is Azure SQL Edge
- What are the available editions of Azure SQL Edge?
- Azure SQL Edge Deployment Models
- Features Of Azure SQL Edge
- What are the tools can be used to work with Azure SQL Edge
- Azure SQL Edge Pricing
- How To Deploy Azure SQL Edge Using Azure Portal
- Creating Azure SQL Edge
- Wrapping Up
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 Product
|Azure SQL Database Edge
|You need to pay $10.001/device per month
|You need to pay $100 per device per year
|You 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.
- 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.
- Log in to the Azure Portal (https://portal.azure.com/).
- Once you have logged in to the Azure Portal, search for the IoT Hub. Click on the Search result IoT Hub as highlighted below.
3. On the IoT Hub page, click the + Create button to create the IoT hub.
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.
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.
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.
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.
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.
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.
You may also like following the articles below
In this article, we have discussed all about Azure SQL Edge. I hope you have enjoyed this article !!!
I am Rajkishore, and I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machine, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.