how-to build binaries on Unix / Linux as non-root account from rpm's

         #how-to extracts rpm packages contents

         export ins=foo-bar.rpm

         rpm2cpio $ins | cpio -idv

         #how-to extract *.tar.gz 

         gzip -dc foo-bar.tar.gz | tar xvf –

         cd foo-bar-dir

         # how-to extract tar.gz packages in the cwd

         export file=foo-bar.tar.gz

         # gotcha xovf - switch order matters !!!

         gzip -dc $file| tar -xovf -

         #how-to build binaries as a non-root 

         ./configure --prefix=$HOME && make && make install

how-to compare dates in nzsql

-- how-to compare dates with different formats

-- how-to convert timestamp and date to bigint

-- how-to use if else struct

SELECT CASE 

   when 

      cast (to_char( (current_timestamp + interval '0 days' ) , 'yyyymmddHHMMSS') as bigint)=

      cast (to_char(NOW() , 'yyyymmddHHMMSS') as bigint)

   then 

         'are equal'

   else 

          'are NOT equal'

END

; 

how-to list all the install packages on cygwin

export gen_install_cmd=/cygdrive/C/Data/`hostname`/conf/install/install-cygwin-on-`hostname`.cmd

echo $gen_install_cmd

mkdir -p `dirname $gen_install_cmd`

echo mkdir -p `dirname $gen_install_cmd`

for package in `cygcheck -c | perl -nle 'm/([a-zA-Z\.\-\+_0-9]*)\s+/g;print $1'`; do echo echo "setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P $package" ; done > $gen_install_cmd

Now all you need is : EDIT THE C:\Data\%COMPUTERNAME%\conf\install\install-cygwin-on-%COMPUTERNAME%.cmd add ( by adding new lines ) , enable ( by disabling the echo in front) or disable packages Start - Run - type cmd :: elavate to local admin yourself RUNAS /profile /user:%COMPUTERNAME%\some_local_admin_user cmd.exe ::otherwise your admin will not able to the winnt dir cd C:\Temp C:\Data\%COMPUTERNAME%\conf\install\install-cygwin-on-%COMPUTERNAME%.cmd

how-to list all netezza db sizes

SELECT 'ALL' AS DatabaseName

 , SUM ( UsedSpace_GB ) AS DatabaseName

 , SUM ( AllocatedSpace_GB ) AS UsedSpace_GB

 , current_timestamp as CurrentTime

 FROM (

      SELECT ORX.database::nvarchar(64) AS DatabaseName ,

      case when sum(SOD.used_bytes) is null then 0 else SUM(SOD.used_bytes)/1073741824 end AS UsedSpace_GB,

      case when sum(SOD.allocated_bytes) is null then 0 else SUM(SOD.allocated_bytes)/1073741824 end AS AllocatedSpace_GB,

      current_timestamp as CurrentTime

      FROM _V_SYS_OBJECT_DSLICE_INFO SOD INNER JOIN _V_OBJ_RELATION_XDB ORX ON ORX.objid = SOD.tblid

      GROUP BY CurrentTime, DatabaseName

) AS ALL_DB_SIZES

UNION ALL

      SELECT ORX.database::nvarchar(64) AS DatabaseName ,

      case when sum(SOD.used_bytes) is null then 0 else SUM(SOD.used_bytes)/1073741824 end AS UsedSpace_GB,

      case when sum(SOD.allocated_bytes) is null then 0 else SUM(SOD.allocated_bytes)/1073741824 end AS AllocatedSpace_GB,

      current_timestamp as CurrentTime

      FROM _V_SYS_OBJECT_DSLICE_INFO SOD INNER JOIN _V_OBJ_RELATION_XDB ORX ON ORX.objid = SOD.tblid

      GROUP BY CurrentTime, DatabaseName

      ORDER BY UsedSpace_GB DESC

;