Azure SQL Devs’ Corner

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

Build your APIs with DAB using Containers – Part 1

Are you tired of spending countless hours building APIs from scratch? With Data API Builder (DAB), you can create your API in just minutes! All you need to do is create a JSON configuration file to describe your database entities (tables, views, stored procedures, or collections) from your Azure SQL Database, SQL Server, Cosmos DB, PostgreSQL...

CTEs, Views or Temp Tables?

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