Davide Mauri

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.

Architecting REST API with Python, Flask and Azure SQL

July 22nd, 2020

Creating REST API with Azure SQL is never been easier thanks to its native JSON support. Let's see how we can use Python and Flask to create an elegant and modern solution to serve REST API to the world

Querying and visualizing data using SQLPad

June 30th, 2020

SQLPad is an amazing free, open source, tool to run SQL Queries against a broad spectrum of popular databases, without the need to install and run something on-premises. It's lightweight, simple and just perfect if you need a no-frills tool to query and visualize data, to do some data exploration.

Microsoft.Data.SqlClient 2.0.0 is now available

June 19th, 2020

Microsoft.Data.SqlClient version 2.0.0 has been released, with several interesting features. Make sure you check it out if you are a .NET developer and you are using Azure SQL or SQL Server in your solutions. Microsoft.Data.SqlClient is the new, open source, official data access library that replaces System.Data.SqlClient

Join us: Azure SQL at Microsoft Build 2020

May 15th, 2020

Don't miss Microsoft Build 2020, this year delivered 100% online and 100% free. Make sure to attend to Azure SQL and SQL Server sessions, to see with your own eyes what you can do with all the features that we packed in these two amazing post-relational databases!