Daniel Adam Durrans, Web Systems Developer

Daniel Durrans is a 30 year old web systems developer from England.

Currently on durrans.com...

bcp BULK INSERT a quote escaped csv file in SQL Server 2005

I was having trouble trying to import a quote escaped CSV file into SQL Server 2005 using BULK INSERT. It kept giving me an unexpected EOF error until I used a format file where I created a dummy start and end column to pick up the initial " and final ...

Installing irssi using macports

To install irssi using macports issue the command: sudo port install irssi +perl This will ensure that you get the necessary perl scripting support. Most people using irssi are going to want this. Note that if you use scriptassist to help you load irssi scripts then you will want some extra perl stuff: sudo ...

Migrating reporting server database with SQL Server 2005 Standard

If you are moving reporting services to a brand new SQL Server machine (such as setting up a UAT environment or test server) then you may backup and restore the reporting server database from your production machine. You will probably then backup and restore the encryption keys. However you will ...

Previously on durrans.com...