CosmosDB: Stored Procedure (sproc) to update a document

The CosmosDB SQL is very flexible in returning objects and view projections, but it cannot Update documents via its SQL dialect.

May 12, 2020 · 4 min · Aaron Held

CosmosDB: A Stored Procedure to merge documents on read

The CosmosDB SQL API is very flexible in returning objects and view projections, but it cannot merge documents via its SQL dialect.

April 28, 2020 · 7 min · Aaron Held

CosmosDB: Hello Stored Procedures (sproc)

CosmosDB Stored Procedures Why stored procedures? Stored Procedures (sprocs) are functions that run on the server-side of a database. In particular, we will be talking about sprocs in CosmosDB. The main reasons for using CosmosDB Sprocs are atomic transactions and performance. All database operations completed in a single sproc call will be atomic. Since the Sproc runs on the server the network latency for loading and saving documents will be considerably less than running the same operations from a remote server or laptop....

April 26, 2020 · 5 min · Aaron Held