Azure SQL Devs’ Corner

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

T-SQL - Azure SQL Devs’ Corner

Change Tracking in Azure SQL Database

May 1, 2023 May 1, 2023 05/1/23
Brian Spendolini
The Azure SQL Database has two main ways to track changes with data (rows/DML) as well as table changes. One of those methods is Change Tracking with the other being Change Data Capture. Today’s post will be going into depth on Change Tracking. Change Tracking and Change Data Capture So, what’s the difference between the two? Change Data...

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

Solving the River Crossing problem with SQL Graph

January 21, 2021 Jan 21, 2021 01/21/21
Arvind Shyamsundar
Graph theory and associated techniques are extremely powerful. Azure SQL allows native representation of graphs as node and edge tables, and provides breadth-first-search traversal for native path finding. This blog post demonstrates the ease of use, and great power of, these features by using them to solve the classic river crossing riddle!

Practical Azure SQL Database for Modern Developers

September 2, 2020 Sep 2, 2020 09/2/20
Davide Mauri
Practical Azure SQL Database for Modern Developers: a book to learn how to take advantage of the all the breakthrough technologies available in Azure SQL like columnstore, in-memory lock-free tables, row-level-security, graph and geospatial support to create modern, scalable and secure applications.

10 reasons to use Azure SQL in your next project

April 25, 2020 Apr 25, 2020 04/25/20
Davide Mauri
There are many database technologies available on Azure that you can choose from. Why would you use Azure SQL? Let me show you why, using just 10 simple points: from JSON support to ColumnStore, through Geospatial and Temporal queries, Non-Blocking transaction, Encryption and Row-Level Security and the amazing Intelligent Query Optimizer.