Top
Authors
Updated
1 Dec 2021Form Number
LP1531PDF size
27 pages, 885 KBSubscribed to LP1531.
Thank you for your feedback.
Abstract
Microsoft Azure SQL Edge is a very small footprint and robust IoT database product from Microsoft that runs on Lenovo Edge servers to process the data locally for increased security and reduced latency. The combination of Azure SQL Edge and Lenovo’s innovative ThinkSystem SE350 Edge Server provides the ideal Edge gateway solution for processing data aggregated from scores of IoT devices.
Azure SQL Edge is a fully containerized solution compatible with most docker container engines. It can run on any Intel, AMD, or ARM64 device and includes native support for data streaming (the same engine that powers Azure Stream Analytics). It has many security features like data encryption, classification, and access controls. Azure SQL Edge also has Time Series Processing and ML inferencing capabilities. ML Models can be trained on premises and deployed to the edge where inferencing can be done on data that is being collected.
This paper describes the steps required to set up and run Azure SQL Edge on the SE350. It also provides some performance data with Azure SQL Edge running on the SE350. The intended audience is IT professionals, solution architects, sales engineers, and consultants to assist in planning, designing, and implementing Microsoft SQL Server at the Edge. Some general knowledge about data center and edge scenarios, and about Microsoft SQL Server is expected to get the most benefit out of this paper.
Table of Contents
Introduction
Business value
Architectural overview
Deployment prerequisites
IOT Edge device setup
Azure SQL Edge - Azure IoT Edge method
Azure SQL Edge - Docker method
Connecting to the SQL Edge container
Add data volumes to SQL Edge container
Performance Data
Appendix: Bill of Materials
Conclusion
Resources
To view the document, click the Download PDF button.
Change History
Changes in the December 1, 2021 update:
- Added use case for Azure SQL Edge on ThinkSystem SE350
- Added a section on adding data volumes to SQL Edge containers
Configure and Buy
Please select a locale
Full Change History
Course Detail
Employees Only Content
The content in this document with a is only visible to employees who are logged in. Logon using your Lenovo ITcode and password via Lenovo single-signon (SSO).
The author of the document has determined that this content is classified as Lenovo Internal and should not be normally be made available to people who are not employees or contractors. This includes partners, customers, and competitors. The reasons may vary and you should reach out to the authors of the document for clarification, if needed. Be cautious about sharing this content with others as it may contain sensitive information.
Any visitor to the Lenovo Press web site who is not logged on will not be able to see this employee-only content. This content is excluded from search engine indexes and will not appear in any search results.
For all users, including logged-in employees, this employee-only content does not appear in the PDF version of this document.
This functionality is cookie based. The web site will normally remember your login state between browser sessions, however, if you clear cookies at the end of a session or work in an Incognito/Private browser window, then you will need to log in each time.
If you have any questions about this feature of the Lenovo Press web, please email David Watts at dwatts@lenovo.com.
