technese.com

SQL Server 2012 RC0 Download Link

http://download.microsoft.com/download/5/E/0/5E0F07D5-33E8-4B83-A3DA-10992D669AB6/ENU/SQLFULL_ENU.iso

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!