Azure SQL Devs’ Corner

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

Create REST API in Python with Django, using the Django REST Framework and Azure SQL

March 2, 2022 Mar 2, 2022 03/2/22

Abhiman Tiwari

Django is a Python-based open-source web framework. It is a popular and well-liked web framework among developers all around the world. But wouldn't it be amazing to build a website with Django while also taking advantage of Azure SQL database's security, performance, high availability, and other great capabilities? In this article, we will...

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.

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.

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!

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

December 11, 2020 Dec 11, 2020 12/11/20

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

December 10, 2020 Dec 10, 2020 12/10/20

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.

Continuous Delivery for Azure SQL DB using Azure DevOps Multi-stage Pipelines

October 28, 2020 Oct 28, 2020 10/28/20

Arvind Shyamsundar

Multi-stage pipelines in Azure DevOps offer a rich, declarative, YAML-based mechanism to implement and customize Continuous Delivery for Azure SQL.

Testing performance of Azure SQL Database as a key-value store

October 20, 2020 Oct 20, 2020 10/20/20

Dimitri Furman

Executive summary Our testing shows that Azure SQL Database can be used as a highly scalable low latency key-value store. Starting with a cost-efficient 4-core General Purpose database, we see an order of magnitude increase in workload throughput as we increase dataset size by 100x and scale across the spectrum of database SKUs to a Business ...

Running 1M databases on Azure SQL for a large SaaS provider: Microsoft Dynamics 365 and Power Platform.

October 8, 2020 Oct 8, 2020 10/8/20

Silvano Coriani

Thriving on Azure SQL Many thanks to our colleagues Mahesh Sreenivas, Pranab Mazumdar, Karthick Pakirisamy Krishnamurthy, Mayank Mehta and Shovan Kar from Microsoft Dynamics team for their contribution to this article. Overview Dynamics 365 is a set of intelligent SaaS business applications that helps companies...

Azure SQL Devs’ Corner

azuresql - Azure SQL Devs’ Corner