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.

Working with MongoDB Data? Use These Data Masking Techniques

Data masking must be part of the developer’s toolkit when dealing with data. In this article, we cover techniques you can use to protect sensitive data in MongoDB.

Posted on: 15/01/2021 (last updated: 06/08/2021) • Phil Factor • 7 minutes

SQL Migration: MongoDB and SQL, Coexistence Made Easy

In the past five years, the relational ‘big beasts’ such as SQL Server, MySQL, PostgreSQL, and Informix have mostly added JSON as a data transfer medium. This doesn’t just mean that the relational database will import tables, views, or queries in JSON format, but also that it will, if necessary, accept and shred JSON as […]

Posted on: 13/11/2020 (last updated: 15/03/2023) • Phil Factor • 4 minutes

MongoDB DevOps Checklist: 3 Steps to Secure Your Database

Nowadays, any organization is likely to be running their affairs on an estate of databases of mixed parentage. In such a context, what factors need to be considered when adding MongoDB to the mix? A survey of over 18,000 DevOps professionals working with MongoDB (2020, Studio 3T) revealed that 79% of respondents are working with […]

Posted on: 13/11/2020 (last updated: 04/08/2021) • Phil Factor • 4 minutes

MongoDB and SQL Server: Communicating via REST Service

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

Posted on: 28/07/2020 (last updated: 31/08/2021) • Phil Factor • 4 minutes

MongoDB, A Database with Porpoise – When You Have a Whale of a Performance Problem

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

Posted on: 25/06/2020 (last updated: 04/08/2021) • Phil Factor • 11 minutes

MongoDB Indexes | A Complete Guide and Tutorial

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.

Posted on: 08/06/2020 (last updated: 12/02/2024) • Phil Factor • 20 minutes

UAT, Unit, Integration & Regression Testing – Database Testing Types

Database testing is one of the most challenging aspects of database development. Here we look at four types: UAT, regression, integration, and unit testing.

Posted on: 08/06/2020 (last updated: 04/08/2021) • Phil Factor • 6 minutes

Detecting COVID-19 Trends Using MongoDB Atlas Data

Here’s how we used the publicly-available COVID-19 data on MongoDB Atlas to find trends and calculate statistics like death rate as a percentage of population.

Posted on: 30/04/2020 (last updated: 04/08/2021) • Phil Factor • 8 minutes

MongoDB Monitoring, Auditing & Authentication: 3 Steps to Secure Your Database

Security in MongoDB starts with ticking the boxes across key categories, which include monitoring, auditing, and authentication.

Posted on: 17/03/2020 (last updated: 04/08/2021) • Phil Factor • 4 minutes