In this Azure tutorial, we will discuss the What Is Azure SQL Edge. Apart from this, we will also discuss on few other topics like What are the available editions of Azure SQL Edge, Azure SQL Edge Deployment Models, Features Of Azure SQL Edge, What are tools can be used to work with Azure SQL Edge, Azure SQL Database Edge Pricing, How To Deploy Azure SQL Edge Using Azure Portal, Creating Azure SQL Database Edge.
Table of Contents
What Is Azure SQL Edge
Azure SQL Edge is nothing but an optimized relational database engine that is specially designed for IoT and IoT Edge deployments. With the help of the Azure SQL Edge database, you can able to create excellent data storage and processing layer for different IoT applications.
- How To Stop Azure SQL Database
- How To Change User Id And Password For Azure SQL Server Database
- How To Deploy SQL Database To Azure
- Azure SQL Edge VS SQL Server
Nevertheless, the Azure SQL database edge also helps you with the capability to analyze, stream, and process-relational and non-relational data.
The interesting part is, 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
Basically, there are two editions of Azure SQL Edge that are available as of now. Below are those two editions of the Azure SQL Edge database
- Azure SQL Edge: This is especially for the production SKU and the SQL edge container is 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 is 32 GB memory and is limited to 4 cores.
Azure SQL Edge Deployment Models
There are two deployment models that are supported by Azure SQL Edge. 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 able to 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 actually helps you with complex event processing and real-time analytics.
- 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
There are different tools that can be used to work with the Azure SQL Edge. Below are the lists of a few key tools that you can use to work with Azure SQL Edge.
- Azure Portal
- Visual Studio Code
- Azure Data Studio
- SQL Server Management Studio(SSMS)
- Visual Studio
Azure SQL Edge Pricing
The pricing structure for the Azure SQL Edge is as below
| Details of Product | Per month | 1 Year | 3 Years |
| 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 need to consider the below as the Prerequisites.
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.
- 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 on 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 created as of 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 on the Next: Networking > button to go to the Networking tab.
5. On the Networking tab, You can choose the default Public endpoint (all networks) or Private endpoint based on your requirement. Click on 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 requirement.
- Number of S1 IoT hub units: Choose this option based on your need.
- Defender for IoT: You can enable this option if you want to enable extra protection for your IoT Hub.
You can click on 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 on the Create button on the next screen to create the IoT hub.
It will take a few seconds and will show you that Your deployment is complete. Click on the Go to Resource button to navigate to the IoT hub that we have just created just before.
Creating An Azure IoT Edge Device
You can easily create an Azure IoT Edge device now.
Now, we have created the Azure IoT Hub and the Azure IoT Edge Device. Now, 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 that we have created above.
- Deploy to a device: Select the option if you want to deploy to a device.
- IoT Edge Device Name: Provide the name of the IoT Edge device that we have created just above. Then you can click on the Find Device button.
Finally, click on the Create button.
You may also like following the below articles
Wrapping Up
In this article, we have discussed, What Is Azure SQL Edge, What are the available editions of Azure SQL Edge, Azure SQL Edge Deployment Models, and Features Of Azure SQL Edge. Along with this, we have also discussed What are tools can be used to work with Azure SQL Edge, Azure SQL Edge Pricing, How To Deploy Azure SQL Edge Using Azure Portal, and Creating Azure SQL Edge. Hope you have enjoyed this article !!!