We introduce the idea of MongoDB views - what they are, why they’re useful, when to use them, and how they relate to data aggregations - and walk you through how to create a view in Studio 3T using a small practice database courtesy of the UK’s Met Office.

Learn about the profiler and the explain() method: two MongoDB features you can use to investigate and optimize query performance.

Learn how to use regex to transform an external data set to JSON or export it to CSV for later import, and run aggregation queries to reduce the data before creating a MongoDB collection.

Learn how to write SQL join queries to generate MongoDB joins in the form of aggregation queries.

Learn how to create a MongoDB index and modify existing ones using Studio 3T's Index Manager.

Learn how to handle cases where MongoDB arrays impact query and update operations.

Get a close, real-time look at your MongoDB server status with Studio 3T's Server Status Charts.

Discover how MongoDB handles UUID data & learn a few best practices when working with such data.

A short post on how to avoid a common gotcha when querying replica set secondary members (secondaries).

Learn how to set up a user administrator and enable user authentication on your MongoDB server.

Learn about LDAP and Kerberos, the two authentication methods supported by the MongoDB Enterprise server.

Learn how to query the MongoDB aggregation pipeline more efficiently with the $bucket and $facet stages.

Part 2 of our MongoDB Users & Roles Explained series walks you through how to enable access control on a three data-bearing node replica set, create the first user making use of the localhost exception, and grant the needed MongoDB roles.

Learn how you can create and validate JSON schema in MongoDB, using third-party JSON schema validation tools and Studio 3T's Schema Explorer.

We demonstrate how to set up a simple REST service that you can use to communicate between MongoDB and SQL Server.

Learn how you can paste the output of a SQL Server query straight into a MongoDB collection with Studio 3T.

Learn how to transfer databases from SQL Server to MongoDB (and vice versa) using Extended JSON.

Here's how you can use Studio 3T's SQL Migration feature to merge multiple SQL tables during import to create a new MongoDB collection.

The quickest way to import an entire SQL database to MongoDB.

Learn how to use indexes to speed up both simple and complex queries, which in turn will help you build and develop an effective indexing strategy.

Learn how to build aggregation queries that reduce the data in your collections to exactly just what you need.

Learn how to filter elements from arrays in MongoDB by using the $elemMatch operator alongside find(), $match, and the $project and $filter functions.