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.
Thursday, August 10, 2017
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.
% 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
My friends had been complaining that I sounded very distant or muffled when on calls on my Google Nexus 6P. A quick google search later I 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 inwards 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.
Update: 16/12/2017 I am no longer able to take photos of my Nexus as it was returned for warranty and has since been swapped to a new phone. If someone could take a photo and leave it in the comments that would be great.
I still maintain that the nexus 6P was one of the best android phones I've had so far. only let down by a crap manufacturer warranty.
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 inwards 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.
Update: 16/12/2017 I am no longer able to take photos of my Nexus as it was returned for warranty and has since been swapped to a new phone. If someone could take a photo and leave it in the comments that would be great.
I still maintain that the nexus 6P was one of the best android phones I've had so far. only let down by a crap manufacturer warranty.
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.
Labels:
SQL
,
SQL Agent Jobs
Tuesday, July 11, 2017
New in SQL 2008 : Transparent Data Encryption Part I - sqldbatips.com blog
New in SQL 2008 : Transparent Data Encryption Part I - sqldbatips.com blog:
'via Blog this'
If you find this article useful please leave me a comment.
'via Blog this'
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.
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.
Thursday, June 29, 2017
60% of electric vehicle drivers don't have solar at home.
Yeah 40% do or 60% don't.
Report finds home solar panels linked to EV ownership:
'via Blog this'
If you find this article useful please leave me a comment.
Report finds home solar panels linked to EV ownership:
'via Blog this'
If you find this article useful please leave me a comment.
Subscribe to:
Posts
(
Atom
)
