Blog Post

Azure SQL Blog
4 MIN READ

Working with Azure IoT data in Azure SQL Database

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Mar 24, 2019
First published on MSDN on Jan 23, 2018 IoT use cases commonly share some patterns in how they ingest, process, and store data. First, these systems need to ingest bursts of dat...
Updated Nov 09, 2020
Version 5.0
azure sql
ChandanJha's avatar
ChandanJha
Copper Contributor
May 27, 2021

SQL is indeed very powerful and with JSON support it is great but Azure SQL still has size limitations and this really defeats the purpose of using it for IOT data.

 

Even if I consider example from this case, I will consume all 25 TB in a columnstored indexed table and then I might have needs to have few more tables where some aggregated data is stored.

 

Azure SQL size limitation is currently a big pain as we do not want to purge any data. Any solutions to this problem?