Some time ago I had to build an integration app that would on occasion query from a SQL Server 2012…
A 32 bit version of Raspbian is currently the most common OS that runs on a Raspberry PI. RPI 3…
Since version 3.2 you can use the $lookup to perform the equivalent of left outer joins in MongoDB. While you…
On the surface, it seems like the $and operator is useless because it is implicitly applied when MongoDB processes each…
While the MongoDB Aggregation Pipeline can be used to aggregate your data, it is definitely not limited to that and…
Starting with the MongoDB Java API 3.1 a new GridFS API has been added. It is available under the com.mongodb.client.gridfs…
As a general rule, you should try to avoid joining as much as possible in MongoDB. While in traditional relational…
SQL Server does not natively support a “LIKE IN” clause. For instance the following example is not valid: Luckily there…
The following example shows one way how you can remove leading zeroes from a varchar column in SQL Server: Returns:
Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a…