Tim Sander

New ways to use composite indexes in Azure Cosmos DB

February 16th, 2021

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

January 21st, 2021

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

December 17th, 2020

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.

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

December 7th, 2020

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.

Understanding the difference between null and undefined in Azure Cosmos DB

November 25th, 2020

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.

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

October 22nd, 2020

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

New date and time system functions in Azure Cosmos DB

October 1st, 2020

Learn about new system functions for working with dates and times in Azure Cosmos DB

Wildcard indexes in Azure Cosmos DB’s API for MongoDB

June 24th, 2020

With our latest service update, you can now create wildcard indexes in accounts that use Azure Cosmos DB’s API for MongoDB. Wildcard indexes are a popular feature in MongoDB 4.2 that allow you to index many properties without enumerating each one.

New string function performance improvements and case-insensitive search

June 15th, 2020

Azure Cosmos DB now supports case-insensitive Contains, StartsWith, EndsWith, and StringEquals. Additionally, both Contains and EndsWith have had significant performance improvements. You can now store string data in Azure Cosmos DB without having to worry about matching the case in the query.

Using spatial geometry data in Azure Cosmos DB

May 7th, 2020

Support for two different types of spatial data has been added to Azure Cosmos DB. Using the SQL (Core) API: geography data (round-earth coordinate system), and two-dimensional geometry data.