Posts

• 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...
• ← Prev page
• Next page →