Data API builder for Azure SQL Databases – Public Preview

March 15, 2023 Mar 15, 2023 03/15/23
Davide Mauri
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?

January 20, 2023 Jan 20, 2023 01/20/23
Davide Mauri
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

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