Tim Van Wassenhove

Passionate geek, interested in Technology. Proud father of two

11 Dec 2010

Techniques learned in SQLtopia: Look Ma, no loops!

I have been programming in c-based languages for more than 10 years now. Lately i have spent quite a bit of time in SQLt...
10 Dec 2010

Exploring window functions

Here is a sample query that allows you to explore the behavior of various aggregate window functions: WITH [Nums1] AS ( ...
20 Nov 2010

Convert AAC/M4A files to MP3 with VLC and PowerShell

Here is a way to convert your AAC/M4A files to MP3 using VLC media player: vlc.exe -I dummy old.m4a :sout=#transcode{aco...
17 Nov 2010

Configure Visual Studio 2010 environment in PowerShell

Instead of using the “Visual Studo Command Prompt (2010)” i wanted to use PowerShell instead. I found this p...
17 Nov 2010

Load all script files at PowerShell startup

These days i have quite some scripts files that i want to be loaded each time i launch PowerShell. Windows PowerShell Pr...
11 Nov 2010

Get variable value from variable with PowerShell

Sometimes you only know at runtime in which variable a certain value is stored. Let me clarify with an example: $tim = 3...
11 Nov 2010

Update ConfigurationStrings in SSIS package with PowerShell

Here are some functions that allow you to update ConfigurationStrings in a SSIS package (dtsx) using PowerShell: functio...
07 Nov 2010

Build your solution with Visual Studio from MSBuild

Unfortunately MSBuild and BIDS Helper are not able to build an .asdatabase from our Analysis Services project (.dwproj)....
07 Nov 2010

Invoke PowerShell script from MSBuild

Here is a small MSBuild target that allows you to invoke a PowerShell script, eg: powershell.exe & ‘script.ps1...
07 Nov 2010

Modify a text file with PowerShell

A while ago i wanted to update a connection string in a configuration file. My first attempt was the following: Get-Cont...