Core (SQL) API Archives | Azure Cosmos DB Blog

New ways to use composite indexes in Azure Cosmos DB

Tim SanderFebruary 16, 2021Feb 16, 202102/16/21

You can now use composite indexes in Azure Cosmos DB to optimize additional cases of the most common inefficient queries! Anytime you have a slow or high RU query, you should first consider whether the query can be optimized with a composite index.

Introducing the LIKE keyword in Azure Cosmos DB

Tim SanderJanuary 21, 2021Jan 21, 202101/21/21

You can now use the LIKE keyword to do text searches in Azure Cosmos DB SQL (core) API! By including the LIKE keyword in a WHERE clause, you can search for specific string patterns.

Understanding how to query arrays in Azure Cosmos DB

Tim SanderDecember 17, 2020Dec 17, 202012/17/20

This blog is the final part of a series of blogs where we’ll demystify commonly confused concepts for developers learning how to query data using Azure Cosmos DB. Today, we’ll walk through tips and tricks for querying arrays.

New in documentation for December 2020

Nikisha Reyes-GrangeDecember 10, 2020Dec 10, 202012/10/20

A guide to the most recent Azure Cosmos DB technical documentation updates for December 2020.

Managing indexing through the Azure Portal in Azure Cosmos DB’s API for MongoDB

Tim SanderDecember 7, 2020Dec 7, 202012/7/20

In this blog, we’ll cover how to add and remove indexes using the new indexing policy editor. We’ll also highlight the differences in best practices for indexing in Azure Cosmos DB’s API for MongoDB and native MongoDB.

Long-term backup with Azure Synapse Link for Azure Cosmos DB

Emmanuel DeletangDecember 3, 2020Dec 3, 202012/3/20

Retain long-term backups or query backups using Azure Synapse Link for Azure Cosmos DB, with these step-by-step instructions.

Understanding the difference between null and undefined in Azure Cosmos DB

Tim SanderNovember 25, 2020Nov 25, 202011/25/20

This blog is part two of a series of three blogs where we’ll demystify commonly confused concepts for developers learning how to query in the SQL (core) API in Azure Cosmos DB. We’ll look at the difference between null and undefined values.

Creating Mobile Applications with Azure Cosmos DB and React Native

Jason AmosNovember 19, 2020Nov 19, 202011/19/20

A step-by-step guide to building a mobile application with Azure Cosmos DB and React Native.

Now in preview – Support for Synapse SQL serverless in Azure Synapse Link for Azure Cosmos DB

Ramnandan KrishnamurthyOctober 28, 2020Oct 28, 202010/28/20

Azure Synapse Link now supports querying Azure Cosmos DB data using Synapse SQL serverless. This capability, available in public preview, allows you to use familiar analytical T-SQL queries and build powerful near real-time BI dashboards on Azure Cosmos DB data.

Understanding the difference between point reads and queries in Azure Cosmos DB

Tim SanderOctober 22, 2020Oct 22, 202010/22/20

In this blog, we'll look at the differences between point reads and queries in Azure Cosmos DB.

Azure Cosmos DB Blog