Monthly Archives: January 2011

Bulk Copy between Microsoft Access Databases using ADO.NET

When copying data to an SQL Server database, the SQLBulkCopy class gets the data there efficiently. When you have Access databases at both ends of the copy you don’t have a bulk copy option. The alternatives are passing the data

Tagged with:
Posted in Development

Determining unique file extensions recursively using Powershell

I thought that this would be an easy task for Powershell: definitely a one-liner. How would I do it though? I’d start with Get-ChildItem, expose an extension property, do some piping, no problem. Yet I drew a blank on the

Tagged with:
Posted in Development

Time Billing to the Tenth

I encountered a time billing application used to bill hours with single decimal precision. Initially that seemed innocuous enough until I realized that the culture that we live in naturally deals with fractional hours in 5 minute increments. How common

Tagged with:
Posted in Uncategorized