My notes, things I have learned, and documentation I have created.

Source: http://www.ale.org/archive/ale/ale-2005-05/msg00214.html

For the whole file try:

Goto to line one: 1G
Sort from current line to end of file: !Gsort
Or if you want to think of it as one command: 1G!Gsort

Sort a range:
Move Cursor to last line to sort
mark the line with mark ‘a’: ma
move cursor to first line to sort
sort from current line to mark ‘a’: !’asort

Now what does the special chars above mean.

‘!’ is the vi filter command, it is followed by a movement command
that says what is being filtered. That is followed by the actual
filter cmd. The filter cmd can be any executable. In this case sort.
Since vi does not know how long the filter command name is, you have
to hit carriage return to initiate the filter.

G by itself means go to the end of the file

ma means set mark a to this line. (marks a-z exist)

‘a means goto mark a.

egrep ‘[[:digit:]]{1,3}’\.'[[:digit:]]{1,3}’\.'[[:digit:]]{1,3}’\.'[[:digit:]]{1,3}’ filename

egrep “[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}” filename

Note: this will not exclude invalid IP addresses such as 500.500.500.500, but it is something to start with.

If doing a copy an paste, the single quotes need to be typed manually until I figure out how enter them correctly.

Open a command prompt using “Run as administrator” (Right mouse click on “Command Prompt” in Accessories.).

Enter:
netsh firewall set icmpsetting 8 enable

In Windows 7, this command has been deprecated and replaced with the following:

netsh advfirewall firewall add rule name=”ICMP Allow incoming V4 echo request” protocol=icmpv4:8,any dir=in action=allow

In Windows Server 2012 R2, to allow RDP access:

netsh advfirewall firewall add rule name=”RDP Allowed” protocol=tcp localport=3389 dir=in action=allow

Make sure you no other yum update service/process running.

Proxy variable without authentication:

export http_proxy=”http://proxyserver:port”

Proxy variable with authentication:

export http_proxy=”http://username:password@proxyserver:port”

Configure VNC to run at startup

vi /etc/sysconfig/vncservers
…
VNCSERVERS=”1:username”
VNCSERVERARGS[1]=”-geometry 1024×768″
…

Use ntsysv to configure vncserver to run at startup.

Configure vnc session to use GNOME

su – username # if necessary
cd .vnc
cp -p xstartup xstartup.orig

vi xstartup
###Begin file###
#!/bin/sh

# Uncomment the following two lines for normal desktop:
unset SESSION_MANAGER
exec /etc/X11/xinit/xinitrc

[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80×24+10+10 -ls -title “$VNCDESKTOP Desktop” &
startx &
###End file###

Note: Make sure there is not blank line after the startx line.

service vncserver restart

Use your vnc client to connect to hostname:1.

top: Basic system monitoring tool. The following three tools use the same kind of display method.

iptstate: Used to monitor iptables traffic.

atop: Used to monitor overall system. Keeps historical data too.

iftop: Used to monitor network interfaces

Examples:

iptstate -f -L -t

atop 3

iftop -i eth1

top

Backup to a remote file location using tar over ssh:
tar cvzf – /localdirectory | ssh ssh root@remotehostname “dd of=/remotefilename”

Backup to a remote tape device using tar over ssh:
tar cvzf – /localdirectory | ssh ssh root@remotehostname $(mt -f remotetapedevice rewind; dd of=/remotetapedevice)$

Restore from a remote file location using tar over ssh:
cd /
ssh root@remotehostname “dd if=/remotefilename” | tar zxvf –

Examples:
Backup:
tar cvzf – /boot | ssh ssh root@thisis.myserver.name “dd of=/backup/boot.tar.gz”
tar cvzf – /boot | ssh ssh root@thisis.myserver.name $(mt -f /dev/nrst0 rewind; dd of=/dev/nrst0)$
Restore:
ssh root@thisis.myserver.name “dd if=/boot.tar.gz” | tar zxvf –

Note: I do not believe that I have to do all this, but it did work. It did not shrink the log using the DBCC commands below as expected. I will update as learn more, but needed to get this written down, since it did achieve what I had wanted (to reduce the size of the log).

From isql:
DBCC SHRINKFILE(dblogname, size)
BACKUP log dbname WITH TRUNCATE_ONLY
DBCC SHRINKFILE(dblogname, size)

From MSSQL Enterprise manager:

sendmail -bv emailaddress

From the sendmail man page:

-bv Do not collect or deliver a message. Instead, send an email
report after verifying each recipient address. This is useful
for testing address rewriting and routing configurations.

This is where you modify the bind order of network interfaces in Windows XP.

It is best to make sure the Remote connections or VPN interfaces are at the bottom to avoid sending unnecessary traffic over the remote connection.