Skip to content
Koen Aerts
  • Home
  • .NET
  • Java
  • Database
  • Scripting
  • Windows
  • UNIX/Linux
  • Hacks
  • About

Tag: Database

Compile and install MongoDB on Raspberry PI

March 10, 2017 Koen 24 Comments

A 32 bit version of Raspbian is currently the most common OS that runs on a Raspberry PI. RPI 3…

Continue Reading →

Posted in: Database, Hacks, MongoDB, UNIX/Linux Filed under: Database, Errors, Hacks, MongoDB, UNIX/Linux

Join Array in MongoDB

April 18, 2016 Koen Leave a comment

Since version 3.2 you can use the $lookup to perform the equivalent of left outer joins in MongoDB. While you…

Continue Reading →

Posted in: Database, MongoDB Filed under: Database, MongoDB

When to use MongoDB $and Operator

January 25, 2016 Koen Leave a comment

On the surface, it seems like the $and operator is useless because it is implicitly applied when MongoDB processes each…

Continue Reading →

Posted in: Database, MongoDB Filed under: Database, MongoDB

MongoDB Aggregation to Custom Sort

January 21, 2016 Koen 2 Comments

While the MongoDB Aggregation Pipeline can be used to aggregate your data, it is definitely not limited to that and…

Continue Reading →

Posted in: Database, MongoDB Filed under: Database, MongoDB

MongoDB ClassCastException with new GridFS API

January 20, 2016 Koen Leave a comment

Starting with the MongoDB Java API 3.1 a new GridFS API has been added. It is available under the com.mongodb.client.gridfs…

Continue Reading →

Posted in: Database, Java, MongoDB Filed under: Database, Errors, Java, MongoDB

Join Query in MongoDB

September 21, 2015 Koen Leave a comment

As a general rule, you should try to avoid joining as much as possible in MongoDB. While in traditional relational…

Continue Reading →

Posted in: Database, MongoDB Filed under: Database, MongoDB

How to achieve the LIKE IN effect in SQL Server

January 20, 2014 Koen Leave a comment

SQL Server does not natively support a “LIKE IN” clause. For instance the following example is not valid: Luckily there…

Continue Reading →

Posted in: Database, SQL, SQL Server Filed under: Database, SQL, SQL Server

Remove leading zeroes from varchar

November 30, 2012 Koen Leave a comment

The following example shows one way how you can remove leading zeroes from a varchar column in SQL Server: Returns:

Continue Reading →

Posted in: SQL, SQL Server Filed under: Database, SQL, SQL Server

Concatenate Strings from a Column Into a Single Row

December 20, 2011 Koen Leave a comment

Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a…

Continue Reading →

Posted in: Database, DB2, Oracle, SQL Filed under: Database, DB2, Oracle, SQL

Count Word Occurrences in Oracle String

November 17, 2011 Koen Leave a comment

As of Oracle 11 you can use the REGEXP_COUNT function to count the number of occurrences of a word or…

Continue Reading →

Posted in: Database, Oracle, Regular Expression, SQL Filed under: Database, Oracle, Regular Expression, SQL

Post navigation

Page 1 of 2
1 2 Next →

Tags

.NET Artifactory AutoIt Avatar C# Cloud Container Crystal Reports Database DB2 Docker Electronics Errors Firmware GCR Google Container Repository Groovy Hacks HTML Java Javascript Jenkins JSP Machine Learning Media MongoDB OpenShift Oracle PHP Python Regular Expression Scripting Security Servlet SQL SQL Server UNIX/Linux Virtualization VMware WebSphere Windows WordPress

Links

  • JavaRanch
  • LinkedIn Profile
  • WordPress

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Copyright © 2019 Koen Aerts — Escapade WordPress theme by GoDaddy