technese.com

Archive for November, 2011

FreeBSD – systat network statistics

using systat command with ifstat at 1 second intervals $ systat -ifstat 1

vSphere Datastore Location

VMWare vSphere : Datastores located at /vmfs/volumes/datastoreName

Transact-SQL: select distinct columns

T-SQL Syntax: SELECT DISTINCT Column FROM TableName SELECT COUNT(DISTINCT ColumnName) FROM TableName

using awk to print columns from a file

1st column $ awk ‘{ print $1 }’ < file> newfile 2nd column $ awk ‘{ print $2 }’ < file> newfile nth column $ awk ‘{ print $n }’ < file> newfile

Add Linux swapfile as virtual memory

Add a 1 GByte swapfile: $ dd if=/dev/zero of=/swapfile bs=1M count=1024 $ mkswap /swapfile $ swapon /swapfile to make it available on boot, edit /etc/fstab file and include: /swapfile swap swap defaults 0 0

Hello world, this is technese.com!

All things technical!