Episode

Azure SQL and IoT

Data Exposed

IoT is almost always associated with NoSQL database. This is quite understandable as its flexibility and specialization are great for ingesting IoT data. But what if that flexibility and performance are also available in Azure SQL? That would make Azure SQL a perfect target for IoT data as along flexibility and performance you have security, manageability, analytics, and scalability. In this episode, Davide Mauri discusses all this and more - and shows you why Azure SQL is a great option for IoT and HTAP.

[01:14] IoT architecture
[02:15] Features
[02:35] Columnstore
[02:42] Rowstore
[02:55] Read-scale out
[03:40] Memory optimized (lock free) structures
[04:02] JSON support
[06:50] Create your own Lambda/Kappa architecture in Azure
[09:00] What you can do with the data at this scale

Additional Resources:
Azure IoT reference architecture
Streaming At Scale - Azure SQL
Ingesting 10K events/sec Video
JSON Performance in Azure SQL