There are multiple ways of using Excel to check if a value exists in another column such as manually using the ribbon, using a MATCH formula or using a VLOOKUP formula. Additionally there are clever things we can do to … Continue reading
This post contains lots of useful Windows run commands and shortcuts! These commands are really handy for when these shortcuts are hidden or disabled by group policy. Windows Run Commands and Shortcuts Have you ever tried to launch a control … Continue reading
Removing duplicate rows in Excel is something that we use regularly to verify the data in our business intelligence-led migration projects. Luckily for us it can be done in a few trivial steps. Removing Duplicate Rows in Excel First we … Continue reading
Using Excel to find duplicates in a column is a simple task that can often add huge value to the accuracy of our data. We typically use Microsoft Power BI to spin data and drive our migration projects. But in … Continue reading
I was setting up a web application recently, and was getting an error stating that the specified password is invalid for the application pool identity. It was suffering from the ‘double hop‘ issue whereby the windows authenticated NTLM credentials couldn’t … Continue reading
I was writing a simple PowerShell script to automate parts of a Microsoft Word document, and bizarrely the output error was telling me that you cannot call a method on a null-valued expression. But the confusing thing was that the … Continue reading
Recently I spent a few days creating and compiling a Java Deployment Rule Set and signing it with an Active Directory certificate. After much stress it worked like a charm on my development machine, but wasn’t working in production! And … Continue reading
When I set about signing a Java deployment rule set with a code signing certificate, I noticed that my certificate had an expiry date of 1 year from the current date. My initial thoughts were that I didn’t want all … Continue reading
I needed to add a new rule to AppSense recently on process start. I wanted the rule to only run when a Microsoft Office application was run. We required an AppSense regular expression for Microsoft Office since there are multiple … Continue reading
Ok, this post is shameless plagiarism from this post. But I couldn’t risk losing sight of good content. Thanks (and apologies) go to David Barrett! Here we discuss how to create a code signing certificate using Active Directory certificate services. … Continue reading