Resetting networking on RedHat 6.5

Networking on my work RHEL6.5 desktop got hosed recently and the following set of commands helped recover from the issue.

service nfs restart
service rpcbind restart
service sshd restart
service nscd restart
service network restart
service nslcd restart
service autofs restart

In addition to this I found that the /etc/resolv.conf was getting edited during reboot preventing the NFS server from working properly. While trying to find a solution to this problem I learned how to access non-responsive computers via grub login and then check the status of various services using /service xxx status/ and verify the on/off schedule of various services using chkconfig (or systemctl). It was quite a trip.

Edit: Apr 10, 2017
The same issue showed up again and this time also the /etc/resolv.conf file was being overwritten. Changing its attributes using
chattr +i /etc/resolv.conf
fixed the issue.

Drag down a formula to the end of sheet in MS Excel

After spending a decade in the Linux/Unix environment I am increasingly finding myself using MS tools at work - especially Excel. Before I get around to posting about Macros and Pivot Tables I wanted to document as much mouse-free experience as possible. This post is about mouse-free dragging of a formula across the sheet.

1. Ctrl+Down will tell you the last row in the sheet.
2. Select cell with the formula
3. In the Name box enter the column alphabet:row start to end (d2:d2000 for example)
4. Hit enter
5. Ctrl+D for (drag till end)


[Source: http://blog.contextures.com/archives/2011/08/31/quickly-copy-excel-formula-down/]