Core (SQL) API Archives | Page 2 of 3

New date and time system functions in Azure Cosmos DB

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

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

Optimizing bandwidth in the Azure Cosmos DB .NET SDK

Matias QuarantaSeptember 24, 2020Sep 24, 202009/24/20

Learn how to optimize the network bandwidth usage in your application by taking advantage of EnableContentResponseOnWrite to avoid getting unneeded content as part of your operations with the Azure Cosmos DB .NET SDK

Bulk Updates with Optimistic Concurrency Control

Theo van KraaySeptember 15, 2020Sep 15, 202009/15/20

How to support bulk updates in Azure Cosmos DB with Optimistic concurrency control. In this sample, we use Core (SQL) API to bulk update vertices in a graph hosted in Gremlin API!

Azure Cosmos DB for the SQL Professional – Referencing Tables

James SerraAugust 24, 2020Aug 24, 202008/24/20

How should you handle reference tables that are common in the relational database world when working in Azure Cosmos DB? This post walks through some of the differences SQL professionals will encounter, and how developing in a Azure Cosmos DB environment compares to a relational database management service (RDBMS).

HttpClientFactory in the Azure Cosmos DB .NET SDK

Matias QuarantaAugust 19, 2020Aug 19, 202008/19/20

In this post, learn about HTTPClientFactory and how you can use it to pool HTTP connections with Azure Cosmos DB clients.

Data Modeling and Partitioning for Relational Workloads

Lenni LobelJune 30, 2020Jun 30, 202006/30/20

As a NoSQL database, Azure Cosmos DB requires you think about data modeling in new ways. In this post, we’ll use a familiar real-world relational data model and refactor it as a non-relational data model for Azure Cosmos DB.

New string function performance improvements and case-insensitive search

Tim SanderJune 15, 2020Jun 15, 202006/15/20

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.

Azure Cosmos DB Blog