Azure SQL Azure SQL Devs’ Corner

Testing performance of Azure SQL Database as a key-value store

Dimitri FurmanOctober 20, 2020Oct 20, 202010/20/20

Executive summary Our testing shows that Azure SQL Database can be used as a highly scalable low latency key-value store. Starting with a cost-efficient 4-core General Purpose database, we see an order of magnitude increase in workload throughput as we increase dataset size by 100x and scale across the spectrum of database SKUs to a Business ...

Serverless Streaming At Scale with Azure SQL

Davide MauriOctober 19, 2020Oct 19, 202010/19/20

Just before Ignite, a very interesting case study done with RXR has been released, where they showcased their IoT solution to bring safety in building during COVID times. It uses Azure SQL to store warm data, allowing it to be served and consumed to all downstream users, from analytical application to mobile clients, dashboards, API and ...

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

Silvano CorianiOctober 12, 2020Oct 12, 202010/12/20

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

Silvano CorianiOctober 12, 2020Oct 12, 202010/12/20

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

Silvano CorianiOctober 12, 2020Oct 12, 202010/12/20

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...

Running 1M databases on Azure SQL for a large SaaS provider: Microsoft Dynamics 365 and Power Platform.

Silvano CorianiOctober 8, 2020Oct 8, 202010/8/20

Thriving on Azure SQL Many thanks to our colleagues Mahesh Sreenivas, Pranab Mazumdar, Karthick Pakirisamy Krishnamurthy, Mayank Mehta and Shovan Kar from Microsoft Dynamics team for their contribution to this article. Overview Dynamics 365 is a set of intelligent SaaS business applications that helps companies...

Resources to become a Well-Rounded Full-Stack Developer

Davide MauriOctober 8, 2020Oct 8, 202010/8/20

If you want to start coding and create your own solutions - be it an App, a Website or something else - or if you want to start a career as developer, you're in luck! There has never been so many and so good training material around, and - even better - available for free. Last addition to the amazing long list of videos and ...

Promises, Node, Tedious, Azure SQL. Oh My!

Davide MauriOctober 4, 2020Oct 4, 202010/4/20

If you are new to Node.js like I am, using Tedious to access Azure SQL can be challenging at the beginning. My understanding is that Tedious, while being fully asynchronous, doesn't support nor Promises nor the more modern async/await pattern. Tedious, in fact, uses events to execute asynchronous code and so a bit of work is needed ...

TodoMVC Full Stack with Azure Static Web Apps, Node and Azure SQL

Davide MauriSeptember 21, 2020Sep 21, 202009/21/20

TodoMVC is a very well known (like ~27K GitHub stars known) application among developers as it is a really great way to start to learn a new Model-View-Something framework. It has plenty of samples done with different frameworks, all implementing exactly the same solution. This way is very easy to compare them against each other and see ...

Fast loading data into Azure SQL: a lesson learned.

Davide MauriSeptember 14, 2020Sep 14, 202009/14/20

I'm preparing a series of post and samples on how to properly load data into Azure SQL using Azure Databricks / Apache Spark that I will start to publish very soon, but I realized today that there is a pre-requisite that in many cases, especially by developers new to the data space, is overlooked: good table design. Wait! If you're not a...

Azure SQL Devs’ Corner