Creating a Backup Solution for Cosmos DB using change feed

Cosmos DB is Azure native NoSQL database. It has awesome capabilities such as global-distribution, exceptionally high availability, throughput scalability, and much, much more. As with most NoSQL horizontally scalable databases it doesn’t have the same backup capabilities as mainstream RDBMS systems. Cosmos DB has an automated backup capability. It is always there and doesn’t affect … More Creating a Backup Solution for Cosmos DB using change feed

Cosmos DB Stored Procedures – handling continuation

I’ve recently did some work involving Stored Procedures in Cosmos DB. There are a few techniques to learn when our stored procedures handle large data sets.  It is all about continuation. In this article, we’ll look at how to build a robust and scalable stored procedure. We’ll start with a naïve approach and then get … More Cosmos DB Stored Procedures – handling continuation

Cosmos DB Configuration Management

I often found the need to automate Cosmos DB deployments. I like to have users run an ARM template and be ready to go.  Automation is key component to repeatability.  It enables automated testing and increase agility in many other ways. ARM Templates don’t go beyond a database account. Take the article Setup for populating … More Cosmos DB Configuration Management

Setup for populating Cosmos DB with random data using Logic Apps

We recently published an article about Cosmos DB Performance with Geospatial Data. In this article, we’re going to explain how to setup the environment in order to run those performance test. More importantly, we believe this article is interesting on its own as it shows how to use Logic Apps to populate a Cosmos DB … More Setup for populating Cosmos DB with random data using Logic Apps

Cosmos DB Performance with Geospatial Data

Time for some performance tests on Cosmos DB around Geospatial coordinates! Let’s hurt the service and see where it shines, where it has a hard time and how scaling it (i.e. increasing Request Units or RUs) helps. We’ll publish an how-to create the same setup in a future article so tests can be reproduced.  In … More Cosmos DB Performance with Geospatial Data

Hacking: changing Cosmos DB Portal experience from Graph to SQL

In the last article, we looked at how we could access a graph using the SQL (aka DocumentDB) API. Here we’ll explore how we can switch the Portal experience from one to the other. Portal Experience The Portal Experience refers to the way the portal lets us interact with Cosmos DB Data.  It’s basically the … More Hacking: changing Cosmos DB Portal experience from Graph to SQL

Hacking: accessing a graph in Cosmos DB with SQL / DocumentDB API

Azure Cosmos DB is Microsoft’s globally distributed multi-model database service. At this point in time (August 2017) there are four supported models:  DocumentDB (also named SQL because the query language is similar to T-SQL), MongoDB, Tabular & Gremlin. We’ve seen how to use Cosmos DB with Gremlin in a past article. Now here’s a little … More Hacking: accessing a graph in Cosmos DB with SQL / DocumentDB API

Cosmos DB & Graph with Gremlin – Getting Started

Azure Cosmos DB is Microsoft’s globally distributed multi-model database service. One of the paradigm it supports is Graph:  Cosmos DB can be used to store and query graphs. At the time of this writing, it supports one interface, Gremlin, which is part of the Apache TinkerPop project. This means we can use any Gremlin Console … More Cosmos DB & Graph with Gremlin – Getting Started