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