Davide Mauri

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

Serverless REST API with Azure Functions, Node, JSON and Azure SQL

September 8th, 2020

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

September 2nd, 2020

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.

Azure SQL & .bacpac the easy way

August 31st, 2020

Restoring an Azure SQL database in one - well three - simple scripts: one with Powershell, one with AZ CLI + Bash and one using the ubiquitous SqlPackage

Azure SQL for Beginners – Video Playlist

August 13th, 2020

Easily translate your SQL Server skills and experience to Azure SQL - using familiar tools and techniques. Insiders Bob Ward and Anna Hoffman walk you through configuring, monitoring, and troubleshooting database security, performance, and availability in this Azure SQL video series on more than 60 topics.