Azure SQL Database Devs’ Corner

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

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

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!

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

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

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

Azure SQL Database Change Stream with Debezium

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

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

Build GraphQL apps with Hasura and Azure SQL Database

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

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

Saving Bot Activities in Azure SQL Database

In this blog post, we’ll walkthrough of how to integrate Bot Framework v4 SDK with Azure SQL Database and save Bot activities/ conversations into the database. We’ll leverage Bot.Builder.Community.Storage.EntityFramework package to save conversations using EntityFrameworkTranscriptStore with TranscriptLoggerMiddleware into Azure SQL...