Thursday, August 10, 2017

Electricity plans are just like Mobile phone plans from the early 2000's when data came along

Here you go, for the next 3 months use as much electricity as you want and then we'll send you the bill (and only give you 2 weeks to pay it). What if I want to see how much electricity I'm consuming per day? You can't do that.

Seems a little unfair to me.

I can look up my mobile data plan at any time and see how much data I have left. Why can't we do the same with our electricity plans?

If you find this article useful please leave me a comment.

How to calculate percent increase

Increase = New Number - Original Number

% Increase = Increase / Original number * 100

For example;

So if your train journey takes 26 minutes and a slower train takes 42 minutes

Increase = 42-26
Increase = 16 / 26*100
Increase = 61%

If you find this article useful please leave me a comment.

Friday, August 04, 2017

How to fix Google Nexus 6P microphone issues

People were complaining that I sounded very distant or muffled when on calls on my  Google Nexus 6P a quick google search found many posts with similar issues and various solutions that didn't work for me. Funny thing was that speaker calls were fine it was only when using the handset against my ear people complained.

On the first visual inspection I couldn't see anything wrong with the mic. It wasn't until I put the mic under a strong magnifying glass and a bright LED light that found there are 2 very slender slots that were very clogged with gunk.

The 2 slots (each side of the mic bar located 5mm from the right side of the mic area) are roughly 1 -2 mm across and could only be cleaned with a thin sewing needle. Once properly cleaned a few test calls showed that people thought I had bought a new phone.

I'll try to source some high res photos to explain what slots I mean.

If you find this article useful please leave me a comment.

Thursday, July 27, 2017

Steps to improving the MS SQL Agent


1. Allow for better error handling in SQL agent jobs

For example Error 12 may not mean a complete failure. don't make me have to create a wrapper to take of this.. Allow me to set success and error flags (and what to do)

2. Allow for If X = THIS THEN DO THAT ELSE SKIP

3. Allow us to disable steps. sometimes we just want to skip a step without having to remove the step completely

4. Allow the Error log to be included /attached in the e-mail notifications

If you find this article useful please leave me a comment.

Tuesday, July 04, 2017

SSRS list view bug in Internet Explorer 11 with SQL 2016 SP1 CU3 update

Issue: 
If you happen use SSRS with IE 11 and you have SQL 2016 SP1 with CU3 installed and then try to switch to 'list view' you'll get an error message about could not load folder contents


Workaround:
Go back and just use 'Tile View' or  switch to Chrome (doesn't seem to be affected) or Uninstall CU3 and go back to CU2.

I have reported this to Microsoft but no response yet.

More info:
https://social.technet.microsoft.com/

https://connect.microsoft.com

If you find this article useful please leave me a comment.