Git: check if something to pull

git remote -v update

PostgreSQL: see number of connections

select sum(numbackends) from pg_stat_database;

Windows: change desktop icon size

1. Using the left click of the mouse, click on an empty area in the desktop. This step is to make sure that there is no application selected/clicked on. 
2. Using your keyboard, press and keep holding the CTRL button, then using your mouse wheel, roll it upward to make the icons size larger, or downward to set the icon size smaller

Virtualbox centos: Device eth0 does not seem to be present

If, when copying a VM from one computer to another one, you face this error:

service network restart
...
Bringing up interface eth0: Device eth0 does not seem to be present, delaying initialization.

Then ensure first that /etc/sysconfig/network-scripts/ifcfg-eth0 has the same MAC address as in Virtualbox network settings, plus

rm /etc/udev/rules.d/70-persistent-net.rules

and reboot

Cisco AnyConnect - Adding Multiple VPN Devices to the Client

See http://www.petenetlive.com/KB/Article/0001011.htm

• Windows: vi C:\ProgramData\Cisco\Cisco AnyConnect Secure Mobility Client\profile\Profile.xml
• MacOS: vi /opt/cisco/anyconnect/profile/Profile.xml

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

<anyconnectprofile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.xmlsoap.org/encoding/" xsi:schemalocation="http://schemas.xmlsoap.org/encoding/ AnyConnectProfile.xsd">  <clientinitialization>   <usestartbeforelogon usercontrollable="true">false</usestartbeforelogon>   <automaticcertselection usercontrollable="true">true</automaticcertselection>   <showpreconnectmessage>false</showpreconnectmessage>   <certificatestore>All</certificatestore>   <certificatestoreoverride>false</certificatestoreoverride>   <proxysettings>Native</proxysettings>   <allowlocalproxyconnections>true</allowlocalproxyconnections>   <authenticationtimeout>12</authenticationtimeout>   <autoconnectonstart usercontrollable="true">false</autoconnectonstart>   <minimizeonconnect usercontrollable="true">true</minimizeonconnect>   <locallanaccess usercontrollable="true">true</locallanaccess>   <clearsmartcardpin usercontrollable="true">true</clearsmartcardpin>   <autoreconnect usercontrollable="false">true    <autoreconnectbehavior usercontrollable="false">DisconnectOnSuspend</autoreconnectbehavior>   </autoreconnect>   <autoupdate usercontrollable="false">true</autoupdate>   <rsasecuridintegration usercontrollable="false">Automatic</rsasecuridintegration>   <windowslogonenforcement>SingleLocalLogon</windowslogonenforcement>   <windowsvpnestablishment>LocalUsersOnly</windowsvpnestablishment>   <automaticvpnpolicy>false</automaticvpnpolicy>   <pppexclusion usercontrollable="false">Disable    <pppexclusionserverip usercontrollable="false"></pppexclusionserverip>   </pppexclusion>   <enablescripting usercontrollable="false">false</enablescripting>   <enableautomaticserverselection usercontrollable="false">false    <autoserverselectionimprovement>20</autoserverselectionimprovement>    <autoserverselectionsuspendtime>4</autoserverselectionsuspendtime>   </enableautomaticserverselection>   <retainvpnonlogoff>false   </retainvpnonlogoff>  </clientinitialization>  <serverlist>   <hostentry>    <hostname>My entry #1</hostname>    <hostaddress>my_entry1.com</hostaddress>   </hostentry>   <hostentry>    <hostname>My entry #2</hostname>    <hostaddress>my_entry2.com</hostaddress>   </hostentry>  </serverlist> </anyconnectprofile>

PostgreSQL: epoch to date

1	select to_timestamp(1446631729) at time zone 'UTC';

Git: show files not yet pushed

git diff --numstat origin/master