Tim Van Wassenhove

Passionate geek, interested in Technology. Proud father of two

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...
01 Nov 2010

Deploying a Database Project does not create artefacts for custom schemas

Last week we noticed that the artefacts for a custom schema in our Database Project were not created (or updated). It to...
25 Oct 2010

Update all repositories with Powershell

I typically store the repositories i am working on under D:\Code. Each morning i had to right click on each of those fol...
07 Sep 2010

T-SQL: Remove all rows from all tables in your schema

Sometimes i want to quickly clean up a database and start from fresh. Here is a small script that does exactly that.. (I...
07 Sep 2010

WIF: whr parameter is a hint for user Home Realm

Yesterday i was reading the Claims Based Identity & Access Control Guide and learned that the whr parameter is a hin...