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

Tag: Database

Parse delimited string into rows

June 29, 2020 Koen Leave a comment

Some time ago I had to build an integration app that would on occasion query from a SQL Server 2012…

Continue Reading →

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

Compile and install MongoDB on Raspberry PI

March 10, 2017 Koen 38 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

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 feed
  • Comments feed
  • WordPress.org
Copyright © 2021 Koen Aerts — Escapade WordPress theme by GoDaddy