De-Duping Files With Powershell

I often have to do little one-off tasks that could be manually, but almost always are better done with a small utility application or script. I don’t have a very strong scripting background, so I’ve been trying to force myself to use (and therefore get more comfortable with) Powershell whenever […]

Many files

spreadsheet

Simple Excel Export with EPPlus

Anyone I’ve ever met who works with an application that sits in front of a lot of data loves it when they can get that data exported to an Excel file for them to mess around with offline. As both developer and end user of a little website project that […]


Ignoring Your Test Suite

If you practice any form of test-driven development or automated testing you’ve likely come across some kind of test framework. If you work with .NET you might have used nUnit, MSTest, or xUnit. These are all great tools that let you decorate classes and methods with attributes to define a […]

file0001745118034

Capture

Extending CLAP For Larger Applications

If you’ve been reading my recent posts you’ve probably noticed that I’ve been working a lot with the CLAP project lately. For anyone who is not familiar with that project, its name is an acronym that stands for Command Line Auto Parser. It lets you quickly and easily take an […]


A Simple Approach For Presenting With Code Samples

I’ve been getting ready for a presentation and have been struggling a bit with the best way to show and execute code samples. I don’t present often (hardly ever), but when I do I like the presentation to have a lot of succinct and executable code snippets to help illustrate […]

code on a screen

command line

Making a Case For The Command Line

I have had an idea percolating in the back of my mind for over a year now that I’ve just recently started to implement. This idea relates to building out “internal tools” to ease the maintenance and on-going support of a software system. The system that I currently work on […]


Tweaking sp_foreachdb’s database_list Parameter Handling

Aaron Bertrand wrote a great article over at MSSQLTips.com titled, “Making a more reliable and flexible sp_MSforeachdb”. In that article he eschews the use of relying on the undocumented (and unsupported) sp_MSforeachdb system stored procedure that can be found in SQL Server’s master system database. As Aaron points out in […]


Extending sp_WhoIsActive With context_info

If you work with SQL Server you should be familiar with Adam Machanic’s fantastic sp_WhoIsActive stored procedure. This procedure provides high levels of detail about all commands that are currently being executed on a SQL Server instance. I’ve found it immensely helpful for troubleshooting long-running queries and locking/contention issues in […]


Memory Leak in CFClientBase<T> Service Proxy for Compact Framework .NET

Version 3.5 of the .NET Compact Framework didn’t initially ship with any direct support for calling remote WCF services. Technically all of the network-related components necessary were there, but getting a working WCF client stood up without something like the full .NET framework’s ServiceModel Metadata Utility Tool (svcutil.exe) would be […]


SQL Server Identity Quirks

If you’ve worked with SQL Server for any length of time odds are that you’ve used the IDENTITY property to create a surrogate key for a table. These auto-incrementing primary keys can be very handy, but they have a couple of quirks that have bitten me enough in the past […]