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
Matt Hilbert Does NoSQL = NoDBA? There's a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave... 21 October 2014 9 min read
Jeremy Jarrell MongoDB Basics for .NET by Example MongoDB is one of the more intriguing 'NoSQL' databases to emerge from 'Cloud' computing. Sometimes, the best way of understanding... 26 March 2012 11 min read
