Robert Vance

Author's posts

HOWTO: Find NAV user running long SQL queries

I was recently tasked with determining why a NAV 2018 installation was occasionally performing poorly.  I suspected that one or more users were running particular queries or functions but I needed to find a way to prove that.  The catch was I am not a SQL DBA and I know even less about NAV.  But …

Continue reading

HOWTO: Deploy Dynamics NAV Contact Insights Outlook Addin End to End

This HOWTO explains how to configure a completely fresh environment with Dynamics NAV 2018 and the Contact Insight Dynamics NAV Outlook Addin on-premises while using Azure AD for authentication. The reason this HOWTO was created is a customer wanted to use the Contact Insights NAV plugin for Outlook. It was determined that this plugin does …

Continue reading

2019 Okanagan Half Marathon Route Map

UPDATE:  Since I made the waypoints anyway, I thought it might be fun to make a video flythrough of the entire 21.1KM of the course.  It’s quick and dirty and more than a little silly but it does serve to demonstrate that this is not going to be easy.  Check out the video here:   I’m …

Continue reading

HOWTO: Microsoft Certification Exam Preparation Generator

If you’ve ever had to write a Microsoft certification exam, you know that the exam syllabus is available from a URL that looks like this: https://www.microsoft.com/en-us/learning/exam-##-###.aspx Where the ##-### is the specific exam you are writing.  You likely also know that  the way Microsoft presents this information is not ideal from a study guide perspective.  …

Continue reading

HOWTO: Build a Temperature Alert System using a Raspberry Pi

I recently had my furnace fail while I was away on business.  Fortunately there were no lasting consequences but it could have been a very bad day.  To try and minimize the risk of such issues in the future, I decided I wanted a temperature monitoring solution that would alert me if the temperature in …

Continue reading

HOWTO: Calculate Elapsed Business Hours Using PowerShell

Have you ever needed to calculate how many business hours / working hours have elapsed between a specific date and now?  For example, you may have some metric that says something needs to happen within 4 business hours.  We define business hours in this case as 8AM to 5PM Monday to Friday and does not …

Continue reading

HOWTO: Backup and View All Contents of an Android Device

This HOWTO is written primarily for my own future reference but hopefully it’ll help someone else too. Let’s say you want to back up the entire contents of your Android device.  How do you do that? 1) Download the Android Debug Bridge (ADB) tool that comes with the Android SDK Platform Tools.  The link of …

Continue reading

HOWTO: Generate a Microsoft Exam Checklist

Are you studying for a Microsoft certification exam?  If so, then you are probably familiar with the “Skills Measured” website that describes what will be covered on your exam.  If not, it looks something like this: I’m currently studying for my 70-347 – Enabling Office 365 Services exam.  The skills measured list above is a …

Continue reading

Is it just inflation?

I recently received a reminder to renew my AMA Plus membership.  2018 marks my 10th anniversary of having an AMA membership.  I pay in annual lump sum payments as it’s cheaper than the monthly option.  I was curious how much they’ve charged for the service over the last decade.  Have a look as I think …

Continue reading

HOWTO: Automate One-A-Day Photography

This will be a somewhat unusual HOWTO compared to those typically on this site.  In an effort to lose weight, I decided I wanted to take a photo of myself, once per day so I could track and further motivate the progress of regular exercise.  I then wanted to overlay the date each photo was …

Continue reading