Use Azure IoT Edge and SQL Server to store and query data at the edge. By incorporating local databases, your IoT Edge devices can perform more complex computing without having to maintain a connection to IoT Hub. For example, a field technician can visualize the last few days of sensor data on a machine locally, even though that data is only uploaded to the cloud once a month to help improve a machine learning model.

Minimum hardware requirements: Linux containers (see this tutorial for a windows containers version), x64, 2Gb of disk space, 2Gb of RAM