Update from Select MySQL

November 7th, 2016

UPDATE users AS U1, users AS U2

SET U1.name_one = U2.name_colX

WHERE U2.user_id = U1.user_id

Fastest way to delete large folders in Windows

July 23rd, 2016
del /f/s/q foldername > nul
rmdir /s/q foldername

TreeSize Free V3.45

June 25th, 2016


DS18B20 – 1-Wire Temperature Sensors

April 30th, 2016

Power/VCC sensor lead — Orange CAT-5/6 wire (pin 2)
Data sensor lead — Blue CAT-5/6 wire (pin 4)
GND (ground) sensor lead — White/Blue CAT-5/6 wire (pin 5

Feeds updating at incorrect time – Update Time Zone

April 30th, 2016

By default, the emonPi is set to the UTC time zone. You can set the time zone to match your location by connecting to the emonPi via SSH, and running :

Reset Emoncms to factory settings and erase all data

April 29th, 2016

If you want to erase all logged data, input processing and configuration from the local Emoncms on the emonPi, run the ‘factoryreset’ script in the emonpi directory:

$ rpi-rw
$ cd emonpi
$ sudo ./factoryreset
$ rpi-ro


July 1st, 2015


How to Change the Built-in Administrator Account Name in Windows

April 6th, 2015

Computer Configuration > Windows Settings > Security Settings > Local Policies > Security Options


How to get rid of prompts for credentials in Office 2013?

March 19th, 2015

The dword to add with a zero value is below


Resubmit Messages in Queues

March 14th, 2015

Use the Shell to resubmit all messages located in a specific mailbox delivery queue or remote delivery queue

Retry-Queue -Identity “<ServerName>\<Destination>” -Resubmit $true