Davide Mauri

Dev life is easy with node-mssql

March 24th, 2021

The node-mssql package simplify a lot the process of connecting and using Azure SQL with Node

The “insert if not exists” challenge: a solution

February 16th, 2021

How to solve the common problem of "insert-if-not-exists" in a very elegant, clever and scalable way.

Modern development: creating a REST API, via CI/CD and back

January 4th, 2021

Video and sample code to create a end-to-end REST solution with Azure SQL, from zero to the CI/CD pipeline, with Unit Testing too!

Using an Azure Container Instance to convert a BAK to BACPAC for Import into Azure SQL Database

December 9th, 2020

Importing a SQL Server backup into an Azure SQL Database is not a trivial task. Here's how to automate the process of converting a .bak to .bacpac file using Docker Containers, Powershell and some automation.

Autoscaling with Azure SQL Hyperscale

December 3rd, 2020

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

Serverless Streaming At Scale with Azure SQL

October 19th, 2020

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

Resources to become a Well-Rounded Full-Stack Developer

October 8th, 2020

  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!

October 4th, 2020

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

September 21st, 2020

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.

September 14th, 2020

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