Azure SQL Edge

What do you know about Azure SQL Edge? This relational database engine has all the goodness we’re used to in SQL Server but is geared for IoT and IoT Edge deployments. It gives you the capabilities to create a high-performance data storage and processing layer for IoT applications and apps.
Data is constantly being captured by IoT devices. Many industries, including oil and gas, mining, and even farming, are adopting massive, complex machines with tons of sensors that collect data. That data is collected, sorted through, and used in a variety of ways to assist them in their operations. This is all IoT in action.

However, there are issues: asynchronous communications are required due to intermittent network access, gaps in time, missing values with IoT time series data, data retention, and management (small devices = little storage).
In this video, I dive into more about Azure SQL Edge and how it can help with common challenges. Topics I cover are:
• Typical Azure SQL Edge Workloads – Data, Machine Learning, and Analytics
• Data Lifecycle in the Edge
• Benefits of SQL Edge including near real-time response and reduced IoT costs
• I’ll also discuss how Azure SQL Edge is NOT SQL Server – I point out the things you won’t get but you’re used to in SQL Server, as well as tell you what you do get from SQL Edge for your IoT data.
The last part of my video is spent on a demo of Azure SQL Edge, so be sure to check that out.

In summary, Azure SQL Edge is built for IoT workloads directly on the device and it runs on Linux. There are many good resources out there to help you get started, and although it’s not the same as SQL Server, it is very comfortable and familiar to those of us who have been on SQL Server. I suggest you give it a try for your IoT solutions and apps.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or [email protected].

Data & AI

Azure SQL Edge

What do you know about Azure SQL Edge? This relational database engine has all the…
Data & AI

Modern Data Platform in Azure

Are you using your data as an asset to make predictions about your business? Some…
App Innovation|Enterprise Apps

Azure Spring Cloud

Have you heard of Azure Spring Cloud? Azure Spring Cloud is a fully managed service…
OpenAI
Data & AI

How to Merge Data Using Change Data Capture in Databricks

My post today in our Azure Every Day Databricks mini-series is about Databricks Change Data…
Data & AI

Databricks and Azure Key Vault

In our ongoing Azure Databricks series within Azure Every Day, I’d like to discuss connecting…
App operations datasheet
App Experience|App Innovation

How to Integrate Azure DevOps within Azure Databricks

In this post in our Databricks mini-series, I’d like to talk about integrating Azure DevOps…
Business Intelligence
Data & AI

Why Use Azure Databricks?

There are many good reasons to use Azure Databricks. In this session of our mini-series…
Data & AI

How to Connect Azure Databricks to an Azure Storage Account

In continuation with our Azure Every Day mini-series on Azure Databricks, I will be covering…
Data & AI

An Introduction to Data Governance (Part 2 of 2)

Welcome back to part 2 of my mini-series on data governance.  In part 2, I’ll…
Data & AI

An Introduction to Data Governance (Part 1 of 2)

Data security is of utmost importance for all organizations, and can be ensured with proper…
Data & AI

Using PowerShell in the Azure Portal

Did you know that the Azure Portal has a feature to connect using PowerShell in…
Data & AI

Getting Started with Azure Analysis Services

If you’re working with Azure, hopefully you’re already taking advantage of Azure Analysis Services. There…