T-SQL Azure SQL Devs’ Corner

The “insert if not exists” challenge: a solution

Davide Mauri February 16, 2021 Feb 16, 2021 02/16/21

How to solve the common problem of "insert-if-not-exists" in a very elegant, clever and scalable way.

Solving the River Crossing problem with SQL Graph

Arvind Shyamsundar January 21, 2021 Jan 21, 2021 01/21/21

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!

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser

Arvind Shyamsundar December 11, 2020 Dec 11, 2020 12/11/20

Azure SQL developers have access to a full-fidelity, highly accurate, and easy-to-use client-side parser for T-SQL statements: the TransactSql.ScriptDom parser. This blog post walks through basic usage, and links to a number of resources for digging deeper.

Practical Azure SQL Database for Modern Developers

Davide Mauri September 2, 2020 Sep 2, 2020 09/2/20

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

Davide Mauri April 25, 2020 Apr 25, 2020 04/25/20

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.

Azure SQL Devs’ Corner

T-SQL Azure SQL Devs’ Corner

The “insert if not exists” challenge: a solution

Solving the River Crossing problem with SQL Graph

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser

Practical Azure SQL Database for Modern Developers

10 reasons to use Azure SQL in your next project

Topics

Top Bloggers

Archive