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, Analytics & AI

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…
Data, Analytics & AI

Modern Data Platform in Azure

Are you using your data as an asset to make predictions about your business? Some challenges that many businesses face are, large volumes of incoming…
Application Modernization

Azure Spring Cloud

Have you heard of Azure Spring Cloud? Azure Spring Cloud is a fully managed service for Spring Boot apps that allows you to focus on…
Data, Analytics & 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 Capture (CDC). A common use case for Change Data Capture…
Data, Analytics & AI

Databricks and Azure Key Vault

In our ongoing Azure Databricks series within Azure Every Day, I’d like to discuss connecting Databricks to Azure Key Vault. If you’re unfamiliar, Azure Key…
Data, Analytics & AI|DevOps

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 within Azure Databricks. Databricks connects easily with DevOps and requires…
Data, Analytics & AI

Why Use Azure Databricks?

There are many good reasons to use Azure Databricks. In this session of our mini-series on Azure Databricks, I’ll dig deeper into why you should…
Data, Analytics & 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 some key topics within Databricks such as Azure Key Vault,…
Data, Analytics & 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 cover the topics of master data management, data quality and…
Data, Analytics & 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 governance policies. In an introduction to data governance, there’s…
Data, Analytics & AI

Using PowerShell in the Azure Portal

Did you know that the Azure Portal has a feature to connect using PowerShell in the cloud? With this there’s no need to connect using…
Data, Analytics & AI

Getting Started with Azure Analysis Services

If you’re working with Azure, hopefully you’re already taking advantage of Azure Analysis Services. There are many benefits here including; scale resources to match your…