Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

Autoscaling with Azure SQL Hyperscale
Autoscaling with Azure SQL Hyperscale
Avatar December 3, 2020 Dec 3, 2020 12/3/20
Azure SQL Hyperscale is the latest architectural evolution of Azure SQL, which has been natively designed to take advantage of the cloud. One of the main key features of this new architecture is the complete separation of Compute Nodes and Storage Nodes. This allows for the independent scale of each service, making Hyperscale more flexible and...
Seasons of Serverless Challenge 1: Azure Functions and Azure SQL Database serverless
Seasons of Serverless Challenge 1: Azure Functions and Azure SQL Database serverless
Drew Skwiers-Koballa November 30, 2020 Nov 30, 2020 11/30/20
Throughout the next seven weeks we'll be sharing a solution to the week's Seasons of Serverless challenge that integrates Azure SQL Database serverless with Azure serverless compute. Learn how to develop an Azure Function that leverages Azure SQL database serverless with Challenge 1 of the Seasons of Serverless challenge.
Testing performance of Azure SQL Database as a key-value store
Testing performance of Azure SQL Database as a key-value store
Dimitri Furman October 20, 2020 Oct 20, 2020 10/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
Serverless Streaming At Scale with Azure SQL
Avatar October 19, 2020 Oct 19, 2020 10/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 buildings during COVID times. It uses Azure SQL to store warm data, allowing it to be served and consumed to all downstream users, from analytical applications to mobile clients, dashboards, API, and...
Optimize storage usage for large volumes of IoT data with Azure SQL
Optimize storage usage for large volumes of IoT data with Azure SQL
Avatar October 12, 2020 Oct 12, 2020 10/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...
Build your full-PaaS IoT solution with Azure SQL Database
Build your full-PaaS IoT solution with Azure SQL Database
Avatar October 12, 2020 Oct 12, 2020 10/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.
Running 1M databases on Azure SQL for a large SaaS provider: Microsoft Dynamics 365 and Power Platform.
Avatar October 8, 2020 Oct 8, 2020 10/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...