Tim Van Wassenhove

Passionate geek, interested in Technology. Proud father of two

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...
13 Jul 2011

Using User-Defined Table Type with Identity column in ADO.NET

A while ago i wanted to use a User-Defined Table Type to pass in a set of records. Nothing special about this except tha...
19 May 2011

Set variables in SSIS package at runtime

The documentation on dtexec Utility (SSIS Tool) says the following: /Set propertyPath;value (Optional). Overrides the co...
09 May 2011

How to handle (short) bursts of work

Here is a summary of how businesses around me handle short bursts of work: When i go to the doctor: find an empty seat i...
21 Mar 2011

Invoke parameterized stored procedure with PowerShell

Here is a quick snippet that demonstrates how you can invoke a parametrized stored procedure with PowerShell: $CreateTra...