Posts

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