Configure Static IP In Ubuntu Server

1. open the /etc/network/interfaces file.
2. auto eth0
   iface eth0 inet static
   address 192.168.1.100
   netmask 255.255.255.0
   network 192.168.1.0
   broadcast 192.168.1.255
   gateway 192.168.1.1
3. sudo /etc/init.d/networking restart
4. Add DNS in /etc/resource
   

Mount NTFS share folder on Ubuntu

$sudo mount -t smbfs -o username=myusername //192.168.0.10/sharename /media/test

Solution untuk masalah duplicate data dalam table

1. sort by tarikh atau lain
2. select distinct table tersebut jadikan as A
3. select top 1 table tersebut dan sortkan by tarikh, jadikan as B
4. select A.*/B.* from A left outer join B on A.id=B.id*

JOIN boleh pilih ikut suka. LEFT ker RIGHT ker bergantung kepada kehendak.

Masalah Precision Dalam ETL untuk Oracle OLE

1) Cast column to NUMBER(precision, scale) in Oracle select (eg. select CAST(columnName as NUMBER(10, 3)) as columName from ..

2) Cast to string in Oracle select (eg. select TO_CHAR(columnName) as columName from ..

Set Variable Dlm SSIS Command Line

/SET "\Package.Variables[User::gvSourceId].Value";101

String Convert Dlm SSIS

(DT_STR,4,1252) DATEPART(yyyy,date)

Login through ssh using no password

1. a@A:~> ssh-keygen -t rsa local pc
2. cat .ssh/id_rsa.pub | ssh b@B 'cat >> .ssh/authorized_keys' local pc