Blog

May 16, 2014, 5:46 PM
At one of my clients, it is desired to create a snapshot of a virtual machine each day and to maintain only a certain number of them. This script was developed in order to manage those snapshots using a scheduled task on the Hyper-V host.
Nov 13, 2013, 5:39 PM
Had another project where I had to encode text as Base64 (in my case, it was to limit the character set used in the result). If you are adding this to a VBA project, place it in a module and add a reference to Microsoft XML 3.0
Nov 13, 2013, 5:22 PM
We had a need for a hashing function (mostly just to generate random looking data) in Excel. We ran across this one for SHA1 and though that it would be good to save it somewhere we could find it again.
Jun 7, 2013, 2:30 PM
As is often the case, especially with SCCM, version numbers of applications and files are stored as strings (i.e., '7.0.90'). Depending on the software publisher, the version number may or may not be easily sortable in SQL Server. I've created a function that can be used in an ORDER BY clause to facilitate sorting of version numbers.