Azure SQL Devs’ Corner

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

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...
Resources to become a Well-Rounded Full-Stack Developer
Resources to become a Well-Rounded Full-Stack Developer
Avatar October 8, 2020 Oct 8, 2020 10/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!
Avatar October 4, 2020 Oct 4, 2020 10/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
TodoMVC Full Stack with Azure Static Web Apps, Node and Azure SQL
Avatar September 21, 2020 Sep 21, 2020 09/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.
Fast loading data into Azure SQL: a lesson learned.
Avatar September 14, 2020 Sep 14, 2020 09/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
Avatar September 8, 2020 Sep 8, 2020 09/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
Avatar September 2, 2020 Sep 2, 2020 09/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.
Developing in the cloud with SQL Server Big Data Clusters: Run and Monitor Apps
Developing in the cloud with SQL Server Big Data Clusters: Run and Monitor Apps
Melony Qin August 21, 2020 Aug 21, 2020 08/21/20
As the last part of the series of working with big data analytics solutions in Kubernetes, we learned about how to work with cloud-native applications with BDC. Operating and testing are also essential parts as an enterprise-grade solution. This article will walk you through how to run and monitoring apps to SQL Server Big Data Clusters (...
Developing in the cloud with SQL Server Big Data Clusters: Develop and Deploy Apps
Developing in the cloud with SQL Server Big Data Clusters: Develop and Deploy Apps
Melony Qin August 14, 2020 Aug 14, 2020 08/14/20
Kubernetes is designed to support an open platform to support a diverse variety of containerized workloads including both stateless and stateful and data-processing workloads. Technically any application can be containerized, it can be up and running in Kubernetes. As a cloud-native platform, Kubernetes is available to deploy cloud-native ...