Author: Phil Factor

Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 30 years of experience with database-intensive applications. Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career.

MongoDB find Method: Introduction & Examples

An introduction to the find() method along with query examples.

Posted on: 17/02/2020 (last updated: 16/10/2024) • Phil Factor • 4 minutes

Getting Data Masking and Anonymization Right

Data Masking. Data Obfuscation. Learn what these terms mean and the best practices to follow when making sensitive data, anonymous.

Posted on: 12/11/2019 (last updated: 04/08/2021) • Phil Factor • 8 minutes

SQL Server to MongoDB Data Transfer Using Extended JSON

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

Posted on: 07/03/2019 (last updated: 04/08/2021) • Phil Factor • 7 minutes

How to Create a MongoDB Collection Directly from SQL Server

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

Posted on: 07/03/2019 (last updated: 25/10/2021) • Phil Factor • 5 minutes

How to Create and Validate JSON Schema in MongoDB Collections

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

Posted on: 15/11/2018 (last updated: 28/05/2024) • Phil Factor • 12 minutes

Extending MongoDB Aggregation with the Bucket and Facet Stages

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

Posted on: 03/09/2018 (last updated: 04/08/2021) • Phil Factor • 6 minutes

Setting Up a MongoDB Service Under Windows via PowerShell

Learn how to use PowerShell to set up a MongoDB service on Windows.

Posted on: 27/07/2018 (last updated: 04/08/2021) • Phil Factor • 10 minutes

How to Create MongoDB Joins Using SQL

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

Posted on: 19/06/2018 (last updated: 09/03/2022) • Phil Factor • 13 minutes

Using Aggregation and Regex in MongoDB to Reduce Data in a Collection

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.

Posted on: 19/06/2018 (last updated: 04/08/2021) • Phil Factor • 9 minutes