Bringing Microsoft SQL to the IoT Edge

Published 09-22-2020 09:00 AM 4,285 Views
Microsoft

Today, we are pleased to announce the general availability of Microsoft Azure SQL Edge, a small footprint database engine optimized for IoT workloads. Built on the same engine the powers Microsoft SQL server and Azure SQL, this containerized solution provides the same industry leading security, familiar developer experience, and tooling that many teams already know and trust.

 

Azure SQL Edge with its many features enables affordable edge solutions for even the most demanding architectures:

 

  • Built-in time series and streaming support for analyzing data while it’s being streamed using time-windowing, aggregation, and filtering capabilities, and achieve deeper insights by combining data types such as time-series and graph.
  • Built in ML and AI capabilities by having ONNX runtime support for operationalizing the mL models and providing additional capabilities to run native scoring closest to where the data is generated.
  • Your choice of platform. Run SQL on ARM 64 and x64 architectures. A small footprint under 500mb means you can deploy on IoT devices as small as a Raspberry Pi.
  • Develop once, deploy anywhere from edge to cloud. Consistent app development, security, and management from Azure SQL to SQL Server to the IoT edge.
  • Native integration with Azure products and services. Simplify and strengthen your cloud-to-edge architecture with native integration to Azure products and services such as Azure IoT Edge and Azure Stack Edge.

 

Picture1.png

 

HOW IT WORKS

 

Millions of messages (or events) are generated by the IoT devices and sensors. By capturing and analyzing these messages, edge applications built using Azure SQL Edge as the data engine can decipher valuable insights and immediately trigger appropriate actions in a wide range of locations, regardless of whether an internet connection is available.

 

Events/data generated from the IoT data sources are sent to an instance of IoT Edge including the Azure SQL Edge module, the IoT application module, and other optional modules. Azure SQL Edge provides the application with local storage of time-series and other data, streaming analytics, real-time scoring of data based on ML models, data protection, and real time visibility to stored data.

 

Data stored in Azure SQL Edge can be sent from IoT Hub to any of the long-term storage services in Azure, such as Azure Cosmos DB or SQL Database. From storage services, data can be sent to Azure Machine Learning for retraining of models. These updated models can then be sent back to Azure SQL Edge to improve AI performance for the IoT application.

 

Even with its powerful and rich feature set, the startup memory footprint for Azure SQL Edge is less than 500 MB. This small footprint gives teams the freedom to design and build applications that run on a nearly unlimited range of IoT devices, including on simple battery-powered or solar-powered devices deployed in remote areas with limited connectivity. Azure SQL Edge is a containerized Linux application that runs on either an ARM64-based or an x64-based processor.

 

In addition, Azure SQL Edge offers platform consistency with SQL Server and SQL Database, allowing developers to build apps once and then deploy them anywhere, whether at the edge, on-premises, or in the cloud.

 

CUSTOMER FEEDBACK

 

"Traditionally, it took two weeks to prep each client's monthly data, to verify the report, and for the client to receive it. Now we deliver the first draft of that report in eight minutes. This is a game changer, it massively simplifies everything we do.”  

 Richard Corless, Lead Cloud Architect, Fugro 

 

“Before edge computing, by the time cloud analysis noted a problem, we had lost response time and sometimes wasted product. With SQL Edge, we reduce both our reaction time and the number of cycles needed.“

Jochen Scheuerer: Head of Connected Smart Factory. Zeiss

 

WANT MORE? KEEP LEARNING

 

Get more details on Azure SQL Edge

Dig into the Azure SQL Edge Whitepaper

Access tutorials, demos and documentation 

 

Join us on Sept 28 as we interview Vasiya Krishnan, PM - Azure SQL Edge to learn more.  

 

%3CLINGO-SUB%20id%3D%22lingo-sub-1694409%22%20slang%3D%22en-US%22%3EBringing%20Microsoft%20SQL%20to%20the%20IoT%20Edge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1694409%22%20slang%3D%22en-US%22%3E%3CP%3EToday%2C%20we%20are%20pleased%20to%20announce%20the%20general%20availability%20of%20Microsoft%20Azure%20SQL%20Edge%3CSPAN%3E%2C%20a%20%3C%2FSPAN%3Esmall%20footprint%20database%20engine%20optimized%20for%20IoT%20workloads.%20Built%20on%20the%20same%20engine%20the%20powers%20Microsoft%20SQL%20server%20and%20Azure%20SQL%2C%20this%20containerized%20solution%20%3CSPAN%3Eprovides%20the%20same%20industry%20leading%20security%2C%20familiar%20developer%20experience%2C%20and%20tooling%20that%20many%20teams%20already%20know%26nbsp%3Band%26nbsp%3Btrust.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAzure%20SQL%20Edge%20with%20its%20many%20features%20enables%20affordable%20edge%20solutions%20for%20even%20the%20most%20demanding%20architectures%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EBuilt-in%20time%20series%20and%20streaming%20support%3C%2FSTRONG%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3Efor%20analyzing%20data%20while%20it%E2%80%99s%20being%20streamed%20using%20time-windowing%2C%20aggregation%2C%20and%20filtering%20capabilities%2C%20and%20achieve%20deeper%20insights%20by%20combining%20data%20types%20such%20as%20time-series%20and%20graph.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EBuilt%20in%20ML%20and%20AI%20capabilities%3C%2FSTRONG%3E%20by%20having%20ONNX%20runtime%20support%20for%20operationalizing%20the%20mL%20models%20and%20providing%20additional%20capabilities%20to%20run%20native%20scoring%20closest%20to%20where%20the%20data%20is%20generated.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EYour%20choice%20of%20platform.%3C%2FSTRONG%3E%20Run%20SQL%20on%20ARM%2064%20and%20x64%20architectures.%20A%20small%20footprint%20under%20500mb%20means%20you%20can%20deploy%20on%20IoT%20devices%20as%20small%20as%20a%20Raspberry%20Pi.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EDevelop%20once%2C%20deploy%20anywhere%20from%20edge%20to%20cloud.%3C%2FSTRONG%3E%20Consistent%20app%20development%2C%20security%2C%20and%20management%20from%20Azure%20SQL%20to%20SQL%20Server%20to%20the%20IoT%20edge.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3ENative%20integration%20with%20Azure%20products%20and%20services.%3C%2FSTRONG%3E%20Simplify%20and%20strengthen%20your%20cloud-to-edge%20architecture%20with%20native%20integration%20to%20Azure%20products%20and%20services%20such%20as%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fiot-edge%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20IoT%20Edge%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fproducts%2Fazure-stack%2Fedge%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Stack%20Edge%3C%2FA%3E.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20align%3D%22center%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F220484i377B2AA62213B218%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Picture1.png%22%20alt%3D%22Picture1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EHOW%20IT%20WORKS%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMillions%20of%20messages%20(or%20events)%20are%20generated%20by%20the%20IoT%20devices%20and%20sensors.%20By%20capturing%20and%20analyzing%20these%20messages%2C%20edge%20applications%20built%20using%20Azure%20SQL%20Edge%20as%20the%20data%20engine%20can%20decipher%20valuable%20insights%20and%20immediately%20trigger%20appropriate%20actions%20in%20a%20wide%20range%20of%20locations%2C%20regardless%20of%20whether%20an%20internet%20connection%20is%20available.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEvents%2Fdata%20generated%20from%20the%20IoT%20data%20sources%20are%20sent%20to%20an%20instance%20of%20IoT%20Edge%20including%20the%20Azure%20SQL%20Edge%20module%2C%20the%20IoT%20application%20module%2C%20and%20other%20optional%20modules.%20Azure%20SQL%20Edge%20provides%20the%20application%20with%20local%20storage%20of%20time-series%20and%20other%20data%2C%20streaming%20analytics%2C%20real-time%20scoring%20of%20data%20based%20on%20ML%20models%2C%20data%20protection%2C%20and%20real%20time%20visibility%20to%20stored%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EData%20stored%20in%20Azure%20SQL%20Edge%20can%20be%20sent%20from%20IoT%20Hub%20to%20any%20of%20the%20long-term%20storage%20services%20in%20Azure%2C%20such%20as%20Azure%20Cosmos%20DB%20or%20SQL%20Database.%20From%20storage%20services%2C%20data%20can%20be%20sent%20to%20Azure%20Machine%20Learning%20for%20retraining%20of%20models.%20These%20updated%20models%20can%20then%20be%20sent%20back%20to%20Azure%20SQL%20Edge%20to%20improve%20AI%20performance%20for%20the%20IoT%20application.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEven%20with%20its%20powerful%20and%20rich%20feature%20set%2C%20the%20startup%20memory%20footprint%20for%20Azure%20SQL%20Edge%20is%20less%20than%20500%20MB.%20This%20small%20footprint%20gives%20teams%20the%20freedom%20to%20design%20and%20build%20applications%20that%20run%20on%20a%20nearly%20unlimited%20range%20of%20IoT%20devices%2C%20including%20on%20simple%20battery-powered%20or%20solar-powered%20devices%20deployed%20in%20remote%20areas%20with%20limited%20connectivity.%20Azure%20SQL%20Edge%20is%20a%20containerized%20Linux%20application%20that%20runs%20on%20either%20an%20ARM64-based%20or%20an%20x64-based%20processor.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20addition%2C%20Azure%20SQL%20Edge%20offers%20platform%20consistency%20with%20SQL%20Server%20and%20SQL%20Database%2C%20allowing%20developers%20to%20build%20apps%20once%20and%20then%20deploy%20them%20anywhere%2C%20whether%20at%20the%20edge%2C%20on-premises%2C%20or%20in%20the%20cloud.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ECUSTOMER%20FEEDBACK%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3E%22Traditionally%2C%20it%20took%20two%20weeks%20to%20prep%20each%20client's%20monthly%20data%2C%20to%20verify%20the%20report%2C%20and%20for%20the%20client%20to%20receive%20it.%20Now%20we%20deliver%20the%20first%20draft%20of%20that%20report%20in%20eight%20minutes.%20This%20is%20a%20game%26nbsp%3Bchanger%2C%26nbsp%3Bit%20massively%20simplifies%20everything%20we%20do.%E2%80%9D%26nbsp%3B%3C%2FEM%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-right%22%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3CEM%3ERichard%20Corless%2C%20Lead%20Cloud%20Architect%2C%20Fugro%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3E%E2%80%9CBefore%20edge%20computing%2C%20by%20the%20time%20cloud%20analysis%20noted%20a%20problem%2C%20we%20had%20lost%20response%20time%20and%20sometimes%20wasted%20product.%20With%20SQL%20Edge%2C%20we%20reduce%20both%20our%20reaction%20time%20and%20the%20number%20of%20cycles%20needed.%E2%80%9C%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-right%22%3E%3CEM%3EJochen%20Scheuerer%3A%20Head%20of%20Connected%20Smart%20Factory.%20Zeiss%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EWANT%20MORE%3F%20KEEP%20LEARNING%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fsql-edge%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGet%20more%20details%20on%20Azure%20SQL%20Edge%3C%2FA%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fresources%2Fazure-sql-edge-whitepaper%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EDig%20into%20the%20Azure%20SQL%20Edge%20Whitepaper%3C%2FA%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql-edge%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAccess%20tutorials%2C%20demos%20and%20documentation%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EJoin%20us%20on%20Sept%20%3C%2FSTRONG%3E%3CSTRONG%3E28%26nbsp%3B%3C%2FSTRONG%3Eas%20we%26nbsp%3Binterview%26nbsp%3BVasiya%20Krishnan%2C%20PM%20-%20Azure%20SQL%20Edge%20to%20learn%20more.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1694409%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EOptimized%20for%20IoT%20gateways%20and%20devices%2C%20Azure%20SQL%20Edge%20extends%20the%20industry-leading%20performance%20and%20security%20of%20Microsoft%20SQL%20engine%20to%20the%20intelligent%20edge.%26nbsp%3BMicrosoft%20Azure%20SQL%20Edge%20is%20now%20generally%20available.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SQL%20Edge%20social%20banner%201920x1080%20300dpi.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F220593iAEB3FF35AA1A17F2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22SQL%20Edge%20social%20banner%201920x1080%20300dpi.jpg%22%20alt%3D%22SQL%20Edge%20social%20banner%201920x1080%20300dpi.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Sep 22 2020 08:07 AM
Updated by: