Tim Van Wassenhove

Passionate geek, interested in Technology. Proud father of two

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...
19 Aug 2011

Use SQL Server Profiler to see if a connection is pooled

It took me a couple of websearches to discover how i can see in SQL Server Profiler whether or not a connection is poole...
18 Aug 2011

SqlConnectionStringBuilder sets the Pooling property to true by default

Here is something that surprised me: SqlConnectionStringBuilder sets the Pooling property to true by default.
01 Aug 2011

Specialized solution for aggregate string concatenation

I have noticed that most people come up with the following solution to build a string in T-SQL: WITH [Numbers] AS ( SELE...
01 Aug 2011

TryGetResult

I think this entry has been in the pipeline for a couple of years now and today i have decided to finally post it 😉 I go...
15 Jul 2011

Launch DtExec from PowerShell

Running an SSIS package from PowerShell (using DTExec) can be as simple as: RunPackage -File 'C:\test.dtsx' -Dat...
13 Jul 2011

Building a Nums table (quickly)

A while ago i presented my approach to generate a nums table here. DECLARE @count INT = 1000; WITH [Nums1] AS ( SELECT 1...