Cosmos DB is a multi-model NoSQL database. However, one of the models it handles – the document database – can be queried using SQL. This is the complete multi-series guide to SQL in Cosmos DB, covering everything you need to know.

CosmosDB

Adam Aspin in CosmosDB

Cosmos DB SQL: Querying Complex JSON – Arrays, Schema on Read, and Subqueries

Query complex JSON in Azure Cosmos DB SQL: access subnodes and arrays, handle schema-on-read inconsistencies, detect missing attributes, check data…

13 May 2019 16 min read

CosmosDB

Adam Aspin in CosmosDB

Cosmos DB SQL Workarounds: LEFT, RIGHT, YEAR, MONTH, DAY, and Wildcard Search via SUBSTRING and String Functions

Practical workarounds for common T-SQL idioms in Azure Cosmos DB SQL API – wildcard searches using CONTAINS and STARTSWITH, null…

03 April 2019 10 min read

CosmosDB

Adam Aspin in CosmosDB

Introduction to SQL for Cosmos DB

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer….

06 March 2019 22 min read