Azure SQL Devs’ Corner

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

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