Azure SQL Devs’ Corner

Connecting the Dots of Azure SQL CICD Part 1: Getting Started

October 24, 2022 Oct 24, 2022 10/24/22

Brian Spendolini

Azure SQL CICD Part 1: Getting Started Continuous Integration (CI) and Continuous Delivery/Deployment (CD) are a set of principles or methodologies that empower development teams to deliver code faster, more reliably, and with fewer bugs compared to traditional software development such as the waterfall model. Teams that use...

Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022

June 3, 2022 Jun 3, 2022 06/3/22

Umachandar Jayachandran (UC)

Azure SQL Database, Azure SQL Managed Instance and SQL Server currently support JSON text processing in T-SQL batches. This functionality allows you to store and manipulate JSON documents in the database. The JSON functions - ISJSON, JSON_VALUE, JSON_QUERY, JSON_MODIFY allows you to validate, query and modify JSON documents. The FOR JSON ...

Planning new scenarios and use cases for Azure SQL Database local development experience!

May 24, 2022 May 24, 2022 05/24/22

Silvano Coriani

At Microsoft Build 2022 we've announced the new Azure SQL Database local development experience to the world. The combination of Visual Studio Code and Azure Data Studio extensions in addition to the new Azure SQL Database emulator for local and offline database development are aimed to significantly improve developers' experience and boost ...

Welcome to the new Azure SQL Database local development experience!

May 24, 2022 May 24, 2022 05/24/22

Silvano Coriani

The “inner loop” in software development workflows is the process of writing, building, debugging and testing code, usually on a local workstation or development environment, before sharing it with someone else. In contrast, the “outer loop” kicks off as soon as that code is checked in a source control system from where CI/CD pipelines...

Announcing the “Azure SQL Database External REST Endpoints Integration” Early Adoption Program

May 24, 2022 May 24, 2022 05/24/22

Davide Mauri

A new, exciting capability for Azure SQL Database has been announced today at //Build: Azure SQL Database has a new built-in feature that allows native integration with external REST endpoints. This means that integration of Azure SQL Database with Azure Functions, Azure Logic Apps, Cognitive Services, Event Hubs, Event Grid, Azure ...

Azure SQL Database Change Stream with Debezium

May 19, 2022 May 19, 2022 05/19/22

Davide Mauri

Azure SQL Database and in general the SQL Server engine allows developers to easily get only the changed data from the last time they queried the database. More precisely, there are two features that allow us to do this and much more, providing capabilities to query for changes happened from and to any point in time. The two features are ...

Create and connect to an Azure SQL DB in 6 easy steps

May 9, 2022 May 9, 2022 05/9/22

Davide Mauri

There are many ways in which an Azure SQL database can be created, and if you are new to the development all those different options can be quite intimidating. Let me show you, in just a few steps, how easy it is instead. This is what we are going to do: I'll be using the Azure Shell portal, as it provides a ...

Announcing General Availability of Change Data Capture (CDC) on Azure SQL Database

April 27, 2022 Apr 27, 2022 04/27/22

Abhiman Tiwari

We are excited to announce the general availability (GA) of change data capture (CDC) in Azure SQL Database. What is Change data capture (CDC)? CDC provides historical change information for a user table by capturing both the fact that Data Manipulation Language (DML) changes (insert / update / delete) were made and the changed data. ...

Build GraphQL apps with Hasura and Azure SQL Database

March 15, 2022 Mar 15, 2022 03/15/22

Silvano Coriani

Hasura makes data access easy, by instantly composing a GraphQL API that is backed by databases and services so that the developer team (or API consumers) get productive immediately. The nature of GraphQL itself and Hasura’s dynamic approach makes integration and iteration easy.

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