Shane Bartholomeusz

Technical Solutions Consultant

Category: Miscellaneous (page 1 of 2)

Solved: Excel 256 Row Limit in MS Flow

Problem

When processing Excel files containing over within Microsoft Flow, you might notice that only the first 256 rows will be returned …

What The? What’s Going On Here?

Microsoft Flow and Excel Logos
Continue reading

Handling Excel Dates in Microsoft Flow

Problem

Dealing with dates can be a real pain in the proverbial sometimes … and Microsoft Flow is no exception.

I recently had to bulk load some records from an Excel file into SharePoint Online using Microsoft Flow … you’d be forgiven to think that this would be a trivial task … WRONG!

Microsoft Flow and Excel Logos
Continue reading

How To: Backup Synology NAS to Azure Cloud

Overview

In this article we’ll look at how to configure your Synology NAS to backup your data to the Microsoft Azure cloud.

Backup Synology to Azure diagram
Continue reading

Solved: Samsung Wireless Fast Charging Paused

Problem

I’ve been using a Samsung Fast Charge wireless charger with my Samsung Galaxy S8 for a while now, and really love the convenience of it.

After using the wireless charger for several months, all of a sudden, one day it stopped working …

I put my phone down on the wireless charger and it would start charging for a few seconds and then stop with the message “paused” on the screen. This cycle would repeat endlessly and the phone would never charge.

Samsung Wireless Fast Charging Paused Screenshot
Continue reading

How to: Repair Hard Disk Health

Some Background …

All modern spinning hard disks and SSD drives contain S.M.A.R.T technology which enables the monitoring of various hard drive parameters, as a means of checking drive health and predicting failure.

Ordinarily, this information isn’t visible to most end users through the OS, you can however access the S.M.A.R.T metrics of your drive using a tool such as SmartMonTools.

SmartMonTools can be used to monitor hard drive health and also to run various built-in hard drive self-test operations…

Hard Drive Image
Continue reading

CLOC – Count Lines of Code

Overview

I recently had the requirement to count the number of lines of code for each application that we maintain.

Obviously I didn’t want to do this manually … it would have been way to time consuming … so I began searching for solutions.

While looking around I came across a fantastic command line tool called CLOC (Count Lines of Code) on github. This utility does exactly what it says on the tin – it parses your code file to counts the lines of code.

CLOC Screenshot
Continue reading

ITIL Foundation Exam Study Guide

ITIL Foundations Logo

ITIL is a well-known and established framework that provides a set of best practices for managing IT services. The ITIL Foundations exam is the entry level exam which aims to provide a general overview of key concepts and terminology of the ITIL framework.

Having just passed the ITIL Foundations Exam I wanted to share my thoughts and tips in this ITIL Foundation exam study guide to help you pass the exam.

Continue reading

“We cannot discover your Chromecast on the network”

Problem

While recently setting up a Google Chromecast (2nd generation) I was unable to successfully complete the setup process.

My Chromecast could not be detected on the network by my devices even though it had successfully connected to my wireless network and I could cast to it through the Youtube Android app.

Google Chromecast

Continue reading

Topshelf – Windows Services Done Right

What is Topshelf?

Many of you probably have experienced the pain of debugging Windows Service applications. A nice alternative is Topshelf Windows Services.

Topshelf allows developers to write Windows Services which can operate as regular Console applications. This is a great open source product that deserves more recognition in the community and that’s why I decided to write a quick post about it. It makes the overall development experience a much, much better one!

Continue reading

Loopback Network Adapters

Why use one?There's no place like 127.0.0.1

In my case I was installing an Oracle database within a self-contained virtual machine environment. I didn’t necessarily want to expose it to my local network, though needed to bind it to the local server IP address.

I created a local loopback network adapter on the local machine.  This adapter provided an IP address for the local server even though it wasn’t connected to the local network (much like the 127.0.0.1 address).

 

Continue reading

Older posts

© 2020 Shane Bartholomeusz

Theme by Anders NorenUp ↑