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: ```sql SELECT COUNT(*) WHERE ...
18 Oct 2012

Sample query to demonstrate influence of collation in Sql Server

Lately I had the pleasure to investigate [collations](http://technet.microsoft.com/en-us/library/aa174903(v=sql.80).aspx...
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: ```bash find Music -name *.mp3 ...
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](http://eid.b...
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 'Add Fo...
26 Apr 2012

Multiclean solution

One of my favorite powershell commands when cleaning up: ```powershell $RootFolder = 'C:\tfs' Get-ChildItem $RootFolder...
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: ```csharp public interface ICanBroadcast { public void Broadcast(string mes...
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...