Category Archives: Tutorials

Instructional articles

Downloading OneDrive documents as PDF

As part of automating a build process I needed a way to download the product documentation from OneDrive and save as PDF files for shipping with product. The result is this PowerShell script with two cmdlets, one that takes an … Continue reading

Posted in Development, Tutorials | Tagged , , , , , | Leave a comment

A drag-and-drop GUI made with PowerShell

The script below shows how to create a simple WinForms GUI in PowerShell, where you can drag and drop files and folders and then process these with PowerShell commands when you click the button. I’ve pieced this together using various … Continue reading

Posted in Development, Tutorials | Tagged , , , | Leave a comment

Working with enterprise custom fields in Project Online

I was tasked with with writing a utility for setting Enterprise Custom Fields on User Resources in Microsoft Project Online. The fields got their values from Lookup Tables. Since is was Project Online, the client side object model, CSOM, had … Continue reading

Posted in Development, Tutorials | Tagged , , , , | Leave a comment

Opening CSV files in Excel

CSV (Comma Separated Values) is a useful file format for tabular data that I often use. But every time I want to load a CSV file into Excel it does not seem to recognize the files. Usually it just loads … Continue reading

Posted in Tutorials | Tagged , , , , , , | 5 Comments

Method for normalizing a relation to BCNF based on functional dependencies

In the previous post I showed the method I use to determine the candidate keys and highest normal form of a relation. Now let’s break these large relations into smaller ones to make sure we achieve Boyce-Codd Normal Form (BCNF)! … Continue reading

Posted in Tutorials | Tagged , , , | 5 Comments

Method for determining candidate keys and highest normal form of a relation based on functional dependencies

For my advanced database systems course I needed to learn how to take a given relation and functional dependencies, tell the highest normal form and then normalize it up to BCNF. It’s actually not that hard, but there are a … Continue reading

Posted in Tutorials | Tagged , , , , | 63 Comments

Getting right click menus to work in 64-bit Windows Explorer

Shells extensions are components that extend the functionality of Windows. The most common type is contextual menus that appear when you right click on items in Windows Explorer. For example, an archive utility can add itself to the menu to … Continue reading

Posted in Tutorials | Tagged , , , , | Leave a comment

How to enable (or improve) two finger scrolling on your Windows laptop

This is a small guide on to how to get two finger scrolling and other multi touch gestures on your Windows laptop. Even if your laptop is already capable of scrolling using two fingers, this guide can still be worth … Continue reading

Posted in Tutorials | Tagged , , , , , , , , , , , | 24 Comments