Category Archives: Utilities

Deduplicating files with LogParser and SQL Server

Posted on 14. April 2011 by admin

Perhaps this should be categorized as a stupid people trick. On the other hand, it’s a good, cheap way to deduplicate files assuming you’re running SQL Server and LogParser. This post assumes at least a basic knowledge of T-SQL and … Continue reading →

Posted in T-SQL, Utilities, Windows OS | Comments Off on Deduplicating files with LogParser and SQL Server

PowerShell Script to Clean Up Old Files Based on Age

Posted on 20. January 2010 by admin

Here’s an extremely simple PowerShell script to remove old files based on age. You could use it to enforce a policy that keeps 90 days of ETL input files on a server. Files older than that would purged with this … Continue reading →

Posted in Utilities, Windows OS | 3 Comments

Converting an existing Perfmon .BLG file to CSV

Posted on 17. December 2008 by Bennett

You may run across the situation where you need to import an existing Perfmon (or System Monitor) binary log file into and Excel spreadsheet or SQL database.  The obvious first step is to convert it to CSV format.  It took … Continue reading →

Posted in Uncategorized, Utilities, Windows OS | Comments Off on Converting an existing Perfmon .BLG file to CSV

MD5 Hash Utilities

Posted on 30. March 2008 by Bennett

FCIV.EXE is a handy little utility to snap a MD5 hash of a single file or multiple files. Optionally it can recurse directories and produce XML output. http://support.microsoft.com/kb/841290 MD5SUM.EXE is a more commonly used utility that runs on a number … Continue reading →

Posted in Utilities | Comments Off on MD5 Hash Utilities

Open Source Diff Tool

Posted on 3. September 2007 by Bennett

Interesting tool: http://winmerge.org/ To quote the authors: WinMerge is an Open Source visual text file differencing and merging tool for Win32 platforms. It is highly useful for determing what has changed between project versions, and then merging changes between versions. … Continue reading →

Posted in Open Source, Utilities | Comments Off on Open Source Diff Tool