November 2009 Entries

SQLBulkCopy versus standard INSERT statements

Part of my current project involves several batch processes that are run after normal working hours. Most of these jobs are doing either one of two things: importing data from a text file or exporting data to a text file. (Since my project is replacing an existing set of applications, we were required to maintain compatibility with the other systems that are sending or receiving data to or from us.) Our data is stored in a typical SQL Server 2005 database. We decided to use .Net based console applications ......

SharePoint ALCM: A real world example

For the past year, I’ve been working with a client that is in a very unusual position, at least one that has been rare in my career. My client is an established business being spun off from their corporate parent, so they are starting up their IT department from scratch. I had a similar experience almost a decade ago, when I joined an IT department right before a huge growth spurt in staff and responsibilities. I was brought on board to help with their SharePoint portal initiative. This included ......