Rob

Author's posts

File Hashing Is Built Into Windows

Note: This post was updated on 08/08/2021 to include instructions for PowerShell. I always used to download the md5sum.exe and sha1sum.exe files when I needed to generate a file’s hash in Windows. I just discovered that certutil.exe, included with Windows 7 and Windows Server 2008 R2 (and later), will do this for you (I’m not …

Continue reading

Making Image Backgrounds Transparent with Paint.Net

I found this solution on the getpaint.net web site: I use the Bucket (fill) with a full transparent color. Set the foreground to white and fully transparent, i.e. RGB all = 255, Transparency – Alpha = 0 Set the background to white and not transparent, i.e. RGB all = 255, Transparency – Alpha = 255 …

Continue reading

Visual Studio 2010 / SP1 / Windows SDK Install Order

When you plan to install the Windows 7/2008 R2 SDK, the SDK needs to be installed before VS2010 SP1.  Here is the recommended install order: 1. Visual Studio 2010 2. Windows SDK 7.1 3. Visual Studio 2010 SP1 4. Visual C++ 2010 SP1 Compiler Update for the Windows SDK 7.1 Here is the link to …

Continue reading

Unit Testing Private Static Methods in C#

I had never needed to unit test a private static class method in C# before, but it turns out that Microsoft created a special object type to handle just such a case. To test the private static method DetermineFilename (that takes filePath as a string parameter and returns a string) in the FileManager class, do …

Continue reading

Get SQL Server Version/Edition Information

Just connect to the database in which you are interested, open a new query window, and enter the following query:

For me, this produced the following:

Load more