Azure SQL Database Devs’ Corner

Automatic GraphQL and REST endpoint for Azure SQL with Directus

January 18, 2022 Jan 18, 2022 01/18/22

Davide Mauri

Extremely performant and built entirely on Node.js, Directus is an open-source Data Platform that installs as a layer on top of your existing SQL database, so that you can you instantly get a dynamic API (REST and GraphQL) to your database

Modern application development with Prisma, GraphQL (or REST) and Azure SQL

October 11, 2021 Oct 11, 2021 10/11/21

Davide Mauri

Prisma is an open-source next-generation ORM for Node.js and TypeScript that eliminates many of the usual challenges that developers face, making you more productive and confident when building data-intensive applications. You can use it as an alternative to traditional ORMs and SQL query builders to read and write data to your database.

LAUNCH: Build serverless, full stack applications in Azure

May 25, 2021 May 25, 2021 05/25/21

Anna Hoffman

Whether you’re new or seasoned to cloud, development, and SQL, building and architecting applications in the cloud has become a required skill for many roles. Today, we’re excited to announce a new learning path to help developers of all skill levels learn how to create applications quickly and effectively with Azure.

Dev life is easy with node-mssql

March 24, 2021 Mar 24, 2021 03/24/21

Davide Mauri

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

Introducing Configurable Retry Logic in Microsoft.Data.SqlClient v3.0.0-Preview1

March 16, 2021 Mar 16, 2021 03/16/21

Silvano Coriani

Over the last few years, we provided guidance on how customers could create their own retry logic or reuse existing libraries aimed to simplify this task for them, We decided to provide a better experience incorporating configurable retry logic capabilities in our client drivers portfolio starting with Microsoft.Data.SqlClient v3.0.0-Preview1.

Considerations of Data Partitioning on Spark during Data Loading on Clustered Columnstore Index

March 2, 2021 Mar 2, 2021 03/2/21

Sumit

This article showcases how to take advantage of a highly distributed framework provided by spark engine, to load data into a Clustered Columnstore Index of a relational database like SQL Server or Azure SQL Database, by carefully partitioning the data before insertion.

The “insert if not exists” challenge: a solution

February 16, 2021 Feb 16, 2021 02/16/21

Davide Mauri

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

The Positive Impact of Intelligent Query Processing

February 8, 2021 Feb 8, 2021 02/8/21

Kate Smith

An overview of Azure SQL and SQL Server's Intelligent Query Processing and how it positively impacts developers.

Solving the River Crossing problem with SQL Graph

January 21, 2021 Jan 21, 2021 01/21/21

Arvind Shyamsundar

Graph theory and associated techniques are extremely powerful. Azure SQL allows native representation of graphs as node and edge tables, and provides breadth-first-search traversal for native path finding. This blog post demonstrates the ease of use, and great power of, these features by using them to solve the classic river crossing riddle!

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

January 4, 2021 Jan 4, 2021 01/4/21

Davide Mauri

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!