Azure SQL Devs’ Corner

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

Azure SQL - Azure SQL Devs’ Corner

CTEs, Views or Temp Tables?

January 20, 2023 Jan 20, 2023 01/20/23
Davide Mauri
I've just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several comments there was the request to explain what is the difference between Common Table Expressions, Views and Temp Tables. This is quite a common question, and it is time to give it a simple, concise, and clear answer...

Development with SQL in containers on macOS

January 13, 2023 Jan 13, 2023 01/13/23
Drew Skwiers-Koballa
There are a bunch of tools available for developing with SQL on macOS, including the mssql extension for VS Code and the standalone yet-comfortably-familiar Azure Data Studio. As a developer, you might have heard about the Azure SQL Database emulator and you've most certainly heard about deploying SQL in containers. Most recently, a new option...

Developing with Azure SQL bindings and Azure SQL trigger for Azure Functions

December 13, 2022 Dec 13, 2022 12/13/22
Drew Skwiers-Koballa
The Azure Functions SQL trigger will invoke an Azure Function when data is changed in a SQL database table, enabling new event-driven scenarios with SQL database. Accessing data in a SQL database with Azure Functions can be accomplished more quickly with the Azure SQL bindings for Azure Functions integration.  Azure SQL bindings for Azure ...

Azure SQL Database External REST Endpoints Integration Public Preview

November 16, 2022 Nov 16, 2022 11/16/22
Davide Mauri
The ability to call a REST endpoint natively from Azure SQL Database, which was made available via an Early Adopter Preview in May, is now moving to Public Preview. I'm extremely happy that as of today the new system stored procedure sp_invoke_external_rest_endpoint is available to everyone, automatically and transparently: you can use it ...

Maximizing Azure SQL Database performance with a globally distributed Redis write-behind cache

November 14, 2022 Nov 14, 2022 11/14/22
authorsShreya Verma, Abhiman Tiwari
Azure SQL Database is a fully managed platform as a service (PaaS) relational database service. With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure. SQL Database can be the right choice for a variety of modern cloud applications because it enables you to...

Connecting the Dots of Azure SQL CICD Part 2: Local Development

November 7, 2022 Nov 7, 2022 11/7/22
Brian Spendolini
Join us for part two of our Azure SQL database change management (CICD) series. This post covers local development environments with Visual Studio Code. Prerequisites Check For Database Projects to deploy correctly, we need to have the .NET Core SDK installed. You can get it here with a direct link for windows x64 here. You can also ...

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