Author's posts
Jan 13 2012
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 …
Dec 05 2011
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 …
Nov 26 2011
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 …
Nov 21 2011
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 …
Nov 17 2011
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:
1 2 3 4 5 |
[sourcecode language="sql"] SELECT SERVERPROPERTY('ProductVersion') as 'Product Version', SERVERPROPERTY('ProductLevel') as 'Product Level', SERVERPROPERTY('Edition') as 'Edition' [/sourcecode] |
For me, this produced the following:
1 2 |
Product Version Product Level Edition 10.50.1600.1 RTM Enterprise Edition (64-bit) |