Azure SQL Devs’ Corner

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

Data API builder for Azure SQL Databases – Public Preview

I am extremely happy and excited to announce the public preview of Data API builder for Azure SQL Databases. Data API builder is a new product that we are adding to the developer’s toolset to help every developer to be more efficient and effective, by instantly and securely turning Azure SQL Databases into a modern REST and GraphQL API....

CTEs, Views or Temp Tables?

I've just finished watching the video from the @GuyInACube about Common Table Expressionsand 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

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

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

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

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

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