Posts

• 27 Apr 2013

  The curious case of trailing spaces in SQL

  A while ago I was quite surprised to see that the following query returns 1 instead of 0: SELECT COUNT(*) WHERE N'Ti...
• 18 Oct 2012

  Sample query to demonstrate influence of collation in Sql Server

  Lately I had the pleasure to investigate collations and here is a sample query that demonstrates how a collation impacts...
• 22 Sep 2012

  Copy all mp3 files in Music folder to USB dribe

  Copying all mp3 files from my Music folder to a USB drive is pretty easy on my Macbook: find Music -name *.mp3 -exec cp {} /Volumes/SANDISK \;
• 06 Aug 2012

  Using eID on OS X Mountain Lion

  Last week or so I got myself a MacBook Air and I am really loving it so far. Today I needed to use my eID so I installed...
• 20 May 2012

  Add missing books to iTunes

  These days i read most books on my ipad. The problem is that iTunes does not seem to add pdf files when i choose ‘...
• 26 Apr 2012

  Multiclean solution

  One of my favorite powershell commands when cleaning up: $RootFolder = 'C:\tfs' Get-ChildItem $RootFolder bin -R...
• 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...
• ← Prev page
• Next page →