I have a background in SQL, and sometimes in Microsoft Excel i need to perform a simple inner join on two datasets. In this blog I explain how we can perform inner joins with Microsoft Excel relatively quickly. Set up … Continue reading
This blog explains how to use Visual Studio to publish an unreferenced assembly to the Bin Folder. There are lots of examples on Google that provide explanations on how to copy unreferenced assemblies (DLL files) to the bin folder at … Continue reading
$packageRoot = Get-AppvClientConfiguration | where Name -eq PackageInstallationRoot | Select -ExpandProperty Value $packageRoot = [System.Environment]::ExpandEnvironmentVariables($packageRoot) $jarFiles = gci ($packageRoot) -rec -force -filter *.jar -ea 0 | where Name -like “*log4j*” | select -ExpandProperty FullName foreach ($jarfile in $jarFiles) { $PackageId … Continue reading
When organisations redirected their documents folder in Windows 7, it often led to administrators seeing a redirected Homeshare folders displaying as Documents on the network share. Microsoft documented the issue here. Administrators could simply display the ‘Filename’ column as in … Continue reading
An organisation we work with have removed Microsoft QuickAssist from their corporate build – presumably they saw this as a potential security risk. Here we explain how to avoid error 0x800f0906 by Bypassing the Windows Updates Server. We had an … Continue reading
IR35 is a set of tax laws in the UK designed to combat tax avoidance by hiring companies and the workers that they hire. Here we explain how Alkane Solutions can assist hiring companies with compliance issues related to IR35 … Continue reading
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