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 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 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.
- 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.