Azure SQL Devs’ Corner

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

Optimize storage usage for large volumes of IoT data with Azure SQL
Optimize storage usage for large volumes of IoT data with Azure SQL
AvatarOctober 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...
Build your full-PaaS IoT solution with Azure SQL Database
Build your full-PaaS IoT solution with Azure SQL Database
AvatarOctober 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.
Running 1M databases on Azure SQL for a large SaaS provider: Microsoft Dynamics 365 and Power Platform.
AvatarOctober 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
Resources to become a Well-Rounded Full-Stack Developer
AvatarOctober 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!
Promises, Node, Tedious, Azure SQL. Oh My!
AvatarOctober 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 ...
Fast loading data into Azure SQL: a lesson learned.
Fast loading data into Azure SQL: a lesson learned.
AvatarSeptember 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...
Serverless REST API with Azure Functions, Node, JSON and Azure SQL
Serverless REST API with Azure Functions, Node, JSON and Azure SQL
AvatarSeptember 8, 2020Sep 8, 202009/8/20
Javascript / Typescript (and thus Node) are, among Full-Stack and Back-End developers, one of the most common choices to create scalable, elegant, high-performance, REST API to be used by the most diverse clients. Azure Functions are another pretty popular solution that developers use to create scalable solution without having to deal with all...
Practical Azure SQL Database for Modern Developers
Practical Azure SQL Database for Modern Developers
AvatarSeptember 2, 2020Sep 2, 202009/2/20
Practical Azure SQL Database for Modern Developers: a book to learn how to take advantage of the all the breakthrough technologies available in Azure SQL like columnstore, in-memory lock-free tables, row-level-security, graph and geospatial support to create modern, scalable and secure applications.