Robert Sheldon in MongoDB How to move from SQL to MongoDB (MQL syntax comparison guide) SQL and MongoDB's MQL compared side by side — CREATE, SELECT/find, JOIN, GROUP BY, UPDATE, DELETE, and indexes — with... 30 May 2025 27 min read
Robert Sheldon in MongoDB How to create MongoDB time series collections (setup and granularity guide) How to create MongoDB time series collections — timeField, metaField, granularity options, automatic expiration, and querying, with worked examples.… 27 January 2025 15 min read 2
Robert Sheldon in MongoDB How to connect to MongoDB with Python (PyMongo CRUD guide) How to connect to MongoDB from Python using the PyMongo driver, and perform create, read, update, and delete operations —... 05 November 2024 19 min read
Robert Sheldon in MongoDB How to get started with MongoDB: Atlas, Compass, and your first collection How to set up MongoDB Atlas, connect with MongoDB Compass, and create your first database, collection, and documents — a... 13 November 2023 18 min read
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
