Tim Van Wassenhove

Passionate geek, interested in Technology. Proud father of two

27 Apr 2013

The curious case of trailing spaces in SQL

A while ago I was quite surprised to see that the following query returns 1 instead of 0: SELECT COUNT(*) WHERE N'Ti...
18 Oct 2012

Sample query to demonstrate influence of collation in Sql Server

Lately I had the pleasure to investigate collations and here is a sample query that demonstrates how a collation impacts...
22 Sep 2012

Copy all mp3 files in Music folder to USB dribe

Copying all mp3 files from my Music folder to a USB drive is pretty easy on my Macbook: find Music -name *.mp3 -exec cp {} /Volumes/SANDISK \;
06 Aug 2012

Using eID on OS X Mountain Lion

Last week or so I got myself a MacBook Air and I am really loving it so far. Today I needed to use my eID so I installed...
20 May 2012

Add missing books to iTunes

These days i read most books on my ipad. The problem is that iTunes does not seem to add pdf files when i choose ‘...
26 Apr 2012

Multiclean solution

One of my favorite powershell commands when cleaning up: $RootFolder = 'C:\tfs' Get-ChildItem $RootFolder bin -R...
27 Mar 2012

An example of Common Table Expression and Window function usage...

Earlier this week some colleague had been assigned a maintenance task and asked me how I would solve it. Every customer ...
28 Oct 2011

Say no to primitives in your API.. and make your software more explicit

A while ago I wrote some code like this: public interface ICanBroadcast { public void Broadcast(string message) { ... } ...
18 Oct 2011

Force the removal of a file with PowerShell

Last couple of weeks I have been generating a lot of files (and restricting their ACLs) and today I decided to remove al...
22 Sep 2011

Remove all access rules from a directory

A while ago i needed to write some code that removes all (existing/inherited) access rules from a given directory. It wa...