Azure SQL Devs’ Corner

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

Latest posts

Introducing Configurable Retry Logic in Microsoft.Data.SqlClient v3.0.0-Preview1
Mar 16, 2021
11
2

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

Silvano Coriani
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
Mar 2, 2021
0
0

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

Sumit
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
Feb 16, 2021
7
1

The “insert if not exists” challenge: a solution

Davide Mauri
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
Feb 8, 2021
1
0

The Positive Impact of Intelligent Query Processing

Kate Smith
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
Jan 21, 2021
3
0

Solving the River Crossing problem with SQL Graph

Arvind Shyamsundar
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
Jan 4, 2021
0
0

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

Davide Mauri
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!

Seasons of Serverless Challenge 3: Azure TypeScript Functions and Azure SQL Database serverless
Dec 14, 2020
0
0

Seasons of Serverless Challenge 3: Azure TypeScript Functions and Azure SQL Database serverless

Drew Skwiers-Koballa
Drew Skwiers-Koballa

Throughout the next seven weeks we'll be sharing a solution to the week's Seasons of Serverless challenge that integrates Azure SQL Database serverless with Azure serverless compute. Learn how to develop an Azure Function that leverages Azure SQL database serverless and TypeScript with Challenge 3 of the Seasons of Serverless challenge.

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser
Dec 11, 2020
1
4

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser

Arvind Shyamsundar
Arvind Shyamsundar

Azure SQL developers have access to a full-fidelity, highly accurate, and easy-to-use client-side parser for T-SQL statements: the TransactSql.ScriptDom parser. This blog post walks through basic usage, and links to a number of resources for digging deeper.

Azure SQL can read Azure Data Lake storage files using Synapse SQL external tables
Dec 10, 2020
2
0

Azure SQL can read Azure Data Lake storage files using Synapse SQL external tables

Jovan Popovic
Jovan Popovic

Serverless Synapse SQL pool in Azure Synapse Analytics is a T-SQL query engine that enables you to read the files placed on Azure storage. You can easily integrate your Azure SQL engine with Synapse SQL to delegate big data analytics and analyze large amounts of data placed on Azure.