Azure Cosmos DB shares some optimization tips in this short video.

A well-planned partitioning strategy will optimize database reads and writes, enabling you to achieve great speed at any scale with Azure Cosmos DB. In under two minutes, you’ll gain an understanding of how partitioning works, why it’s critical to performance as your database scales, and how to select the best key for your database. 

Learn more about partitioning strategy:

Data modeling is the process of establishing patterns and rules for how data is stored in database documents and containers and how it is accessed.

You can significantly improve speed and performance of Azure Cosmos DB – especially for your most frequent queries – by choosing the data model that best fits the needs of your application.

In less than two minutes, learn about the key considerations for choosing the right data model, the differences between embedding and referencing data, and how the Azure Cosmos DB change feed can eliminate data duplication.

For more on data modeling, visit:

James Serra recently posted this article on some of the things to keep in mind when moving from a relational data model mindset to a NoSQL model.

A big difference with Cosmos DB compared to a relational database is you will create a denormalized data model.  Take a person record for example.  You will embed all the information related to a person, such as their contact details and addresses, into a single JSON document.  Retrieving a complete person record from the database is now a single read operation against a single container and for a single item.  Updating a person record, with their contact details and addresses, is also a single write operation against a single item.  By denormalizing data, your application typically will have better read performance and write performance and allow for a scale-out architecture since you don’t need to join tables.

Do you need to change a partition key you’ve already defined in a collection (or collections)?

Program manager Theo van Kraay shows how an account with Azure Cosmos DB Core (SQL) API can change partition keys using change feed.

If you’re new to partitioning, watch this video first: https://youtu.be/oqk41KY6rhA.

For more about partitioning with Azure Cosmos DB, visit: https://docs.microsoft.com/en-us/azure/cosmos-db/partition-data

Kirill Gavrylyuk joins Scott Hanselman to go over two important updates to Azure Cosmos DB: Free Tier and Autopilot.

Free Tier enables you to run small applications using Azure Cosmos DB free of charge for as long as you like. Autopilot enables developers to only pay for the Azure Cosmos DB usage they need and not worry about predicting throughput.

Related Links:

In this video, Jeremy Likness chats with software engineer Matías Quaranta about some of the lesser known features of the Cosmos DB SDK for .NET. Matias discusses some useful patterns for managing the lifetime of the client, implementing custom serializers and some other interesting features.

Useful Links

Matías Quaranta (@ealsur) shows Donovan Brown (@donovanbrown) how to do bulk operations with the Azure Cosmos DB .NET SDK to maximize throughput, and how to use the new Transactional Batch support to create atomic groups of operations.

Related Links:

Tim Sander joins Scott Hanselman to discuss composite indexes and correlated subqueries using the SQL API in Azure Cosmos DB.

A Request Unit, or RU, is the measure of throughput in Azure Cosmos DB. Learn how to optimize queries with a composite index to decrease the RUs needed for a given query.

They also showcase correlated subqueries and examples of how they can make it easier to query arrays in Azure Cosmos DB.

              Related Links:

              Watch this IoT Show to learn why Azure Cosmos DB (aka.ms/CosmosDB-IoT-Lab), Microsoft’s globally distributed multi-model database service, is frequently used in IoT scenarios.

              Cosmos DB can ingest semi-structured data at extremely high rates and serve indexed queries back out with extremely low latency.

              Andrew Liu, Program Manager, Cosmos DB team, steps through two popular IoT use cases and demos the four things IoT developers “must know” about Azure Cosmos DB. You will receive instructions on how to get started with a hands-on lab.

              Resources

              XTO Energy , a subsidiary of ExxonMobil, taps into IoT