Azure SQL Database Devs’ Corner

Optimize storage usage for large volumes of IoT data with Azure SQL

October 12, 2020 Oct 12, 2020 10/12/20

Silvano Coriani

IoT with Azure SQL IoT solutions are generally producing large data volumes, from device to cloud messages in telemetry scenarios to device twins or commands that need to be persisted and retrieved from users and applications. Whether we need to store data in “raw” formats (like JSON messages emitted by different devices), to preserve and...

Ingest millions of events per second on Azure SQL leveraging Shock Absorber pattern

October 12, 2020 Oct 12, 2020 10/12/20

Silvano Coriani

IoT with Azure SQL IoT workloads can be characterized by high rates of input data, on both steady and burst streams, to be ingested from devices. A common design pattern for relational database systems involves a “landing zone” (or staging area) which is optimized for “absorbing the shock” of this high and spikey input rate, before ...

Build your full-PaaS IoT solution with Azure SQL Database

October 12, 2020 Oct 12, 2020 10/12/20

Silvano Coriani

IoT with Azure SQL IoT solutions usually include several components that spans from device communication and management to event processing and data ingestion and analysis. Deploying all these components independently on compute, network and storage based infrastructures can be a complex and time consuming task, but nothing compared to manage...