Search This Blog

2011-04-30

ExcelToHtml 1.3 out now

http://code.google.com/p/exceltohtml/

2011-04-21

A simple minimalistic perl logger out now ...

Download from here

Solaris cheat sheet (revised)

echo Solaris Cheat Sheet
echo this Cheat Sheet contains quick copy paste stuff for Sun's Solaris OS
echo caveat ... some of the stuff has been copied from my Linux Cheat Sheet
echo and you know Linux is not Unix ; )

echo the time now is `date +%Y.%m.%d-%H:%M:%S`
id
uname -a
du -ak . | sort -n | grep csv



echo record the current session via script
script -a /export/home/userName/SCRIPTSLOGS/`date +%Y%m%d%H%M%S`_script.log


echo /usr/bin is for normal user executables, /usr/sbin is for superuser executables, /usr/sfw is for external software (like gnu one), but provided with bundle of OS, /usr/ccs is for development utilities, usually not need for daily tasks like make, lex, yacc, sccs


echo where I have been lately ?
history | grep cd

echo take the last 5 commands for faster execution to the temp execution script

tail -n 5 /root/.bash_history >> /var/run.sh

echo I saw the command cd /to/some/suching/dir/which/was/very/long/to/type
so I redid it and saved my fingers
!345

history >history.txt ---- echo the last 1000 commands into a history.txt file

echo send that file to myself

cat history.txt | mail -s "test file sending" -c mail1@com
yordan.georgiev(boom)gmail.com

echo remove all trealing spaces from the history file works for TextPad

^([ ]*)([0-9]*)(.*)$

\3 --- replace with the pure commands

history | gawk -F1 'BEGIN {FS=" "};{print $2 , $3}' | less

echo display the history withouth the line numbers ...

history | perl -i -pe 's/^([ ]*)([0-9]*)(.*)$/$3/gi'





vi fileName anotherFile

echo how to deal with command outputs
command | filtercommand > command_output.txt 2>errors_from_command.txt

echo Hint after the less filter pressing s will prompt you for saving the
output to a file ...

echo  find all files and folders containing the word toFind and pipe it to the less for easier viewing
find / -name "*toFind*" 2>/dev/null | less



echo  find the files having os somewhere in their names and only those having linux
find . -name '*os*' | grep linux | less

echo find all xml type of files and display only the rows having wordToFindInRow
find . -name '*.xml' -exec cat {} \;| grep wordToFindInRow | less

echo The ultimate "find in files"
find / -name '*bash*' -exec grep -nH tty {} \;

echo  or even faster , be aware of "funny file names xargs -0
find / -name '*bak' | xargs grep -nH tty

echo find and replace recursively
find . -name '*.html' -print0 | xargs -0 perl -pi -e 's/foo/bar/g'

echo putty , bash shortcuts
Ctrl + A --- Go to the beginning of the line you are currently typing on
Ctrl + E --- Go to the end of the line you are currently typing on

echo how-to mount an usb stick
echo remember to change the path other wise you will get the device is busy errror

mkdir /mnt/usbflash
mount /dev/sdb1 -t vfat /mnt/usbflash

umount /mnt/usbflash



head -n 20 tooLongFile -- display the first 20 lines of the file

echo change the uggly prompt

vi /etc/bashrc

echo get a nice prompt
PS1="\u@\h \t \w\n\\$ "

echo how to restart a process initiated at startup
/etc/rc.d/init.d/sendmail start | stop | status | restart

echo see all the rules associated with the firewall

iptables -L -v

gunzip *file.zip

echo decompress a tar achive
tar -xvf file.tar

echo add all *.bteq type of files into AllBteqs.tar.gz type of file
for file in *.bteq ; do tar cvf AllBteqs.tar.gz $file ;done;



echo zip all my txt files in the current directory into the zipArchiveName file
for file in *.txt
do   zip zipArchiveName $file
done ;

for file in *.csv ; do rm -f $file ; done ;




To access the server download winscp.exe:

echo start winscp with a stored session from Win box
cmd /c start /max winscp oracle@192.168.255.12

echo To start remote session click on the putty screen , configure putty
settings to pull full screen with alt + Enter

echo right click on the title bar , settings , change the font , copy
paste from and to the terminal window text

echo how to ensure the sshd daemon is running

ps -ef | grep sshd


echo User and group management
echo add user with specifig home directory name and pass
useradd -p winscppass -r winscp -d /home/winscp --- to add a user with
useradd -u 10226425 -c "Yordan Georgiev, EXT, ext-yordan.1.georgiev@nokia.com" -m -d /export/home/userName -s /bin/bash userName
useradd -u -c"NPM platform OS level user" -m -d /opt/npm/npmobi -s /bin/bash -g npmobi npmobi






luserdel winscp --- delete the user

gpasswd: administer the /etc/group file
groupadd: Create a new group
groupmod: Modify a group
groupdel: Delete a new group

useradd: Create a new user or update default new user information
usermod: Modify a user account
userdel: Delete a user account and related files


echo how to kill process interactively

killall -v -i sshd

echo disk usage of users under the /home directory


echo on Solaris
du -ak /export/home | sort -n -r  | less
du -ak . | sort -n | grep log


echo the most efficent way to search your history is to hit Ctrl R and
type the start of the command. It will autocomplete as soon as there’s
a match to a history entry, then you just hit enter. If you want to
complete the command (add more stuff to it ) use the right arrow to
escape from the quick search box ...

How to install Perl modules

gzip -dc yourmodule.tar.gz | tar -xof -

perl Makefile.PL

make test

make install

How to see better which file were opened , which directories were visited

type always the fullpath after the vi - use the $PWD env variable to
open files in the current directory , thus after opening the file
after:

vi /$PWD , press tab to complete the name of the current directory ,
type the name of the file

thus after

history | grep vi



the full list of opened files is viwed .

of course the same could be seen from the /home/username/.viinfo file /files

where to set the colors for the terminal (if you are lucky to have one
with colors; )

/etc/DIR_COLORS

open a file containing "sh" in its name bellow the "/usr/lib" directory

:r !find /usr/lib -name *sh*

go over the file and gf

uname -a --- which version of Linux I am using

rmp -qa --- show all installed packages

passwd [username] --- change the password for the specified user (own password)



How to copy paste text in the putty window from client to server -
click the right button of your pointing device

How to copy paste text from the putty window from server to client -
right-click the window title and select copy all to Clipboard.

To restart a service

service sshd restart

service --status-all --- show the status of all services



chown -R root:nortel Directory

echo perform action recursively on a set of files

find . -name '*.pl' -exec perl -wc -l {} \;

$ for file in *
> do cp $file $file.bak
> done




$ for file in `ls -R` ; do cp $file $file.bak; done


echo make Bash append rather than overwrite the history on disk:
shopt -s histappend

echo henever displaying the prompt, write the previous line to disk:
PROMPT_COMMAND='history -a'



gpm -- general "cut and paste" server

sh ScriptWithALotOfErrorMessages.sh | tee -a whereToSaveIt.log

echo run first the following command

$ script -a The_Log_File_To_Append_as_well_as_display_diagnostig_messages.log

echo than run the script

sh ScriptWithALotOfErrorMessages.sh

tr '\t' ',' < FileWithTabs > fileWithCommas

df -k --- disk usage

echo Allow access to the box from only one ip address

IPTables=/sbin/iptables
$ IPTables -A INPUT -s <Insert other Origin ip here> -p tcp
--source-port xxx -j ACCEPT
$ IPTables -A OUTPUT -d < Insert other Origin ip here > -p tcp
--destination-port xxx-j ACCEPT

echo has the root logged in over an unencrypted network ?

echo  last | grep “^root “ | egrep –v “reboot|console” | more

echo start command in the background
command1 &

echo start another one
command2 &

echo bring the command in the foreground
fg %1

echo create a backup file based on the timestamp on bash

cp fileName.ext fileName.ext.`date +%Y%m%d%H%M%S`.bak


echo which box I am workign currently
uname -a
echo who am I on this machine
id
echo the current time is( in yyyy.mm.dd HH:MM:SS format )
echo `date +%Y.%m.%d.%H.%M.%S`


find /opt/npm/sfw/oracle/EPM/11.1.1.3 -name "*assembly.dat" | cut -d/ -f9 | sort -u

echo get my IP address
 /sbin/ifconfig -a | less

telnet -e "^g" 10.176.246.138 1025
telnet -e "^g" xldb-prod 1025

echo which process the npmobi user is runnig and sort by process name
ps -fu npmobi | sort +7

echo check whether host in DNS
nslookup hostName

echo show the ports which npmobi user is using
/usr/local/bin/show-ports -u npmobi

echo port forwarding with ssh from one host to another via ssh
ssh -L1423:3esituo08lab:1423 2esituo08lab
ssh -L 1528:2esituo08lab:1528 hecop07lab.ntc.nokia.com


echo how-to setup port forwarding on Unix
ssh -L22:localhost:22 hostToForwardTo.domain.com


echo scp copy from local to remote host a file
scp /local/host/path userName@hostName.domain.com:/remote/host/path/
echo scp copy from remote to loca host files
scp userName@serverName.domain.com:/remote/host/path/* /local/host/path


echo ksh nice prompt
export PS1=$host.$LOGNAME:$PWD:`echo ``date +%Y.%m.%d-%H:%M:%S`` `:`echo  "\n" $ " "`

export PS1=$host.$LOGNAME:$PWD:$TIME:$($(id) $

export PS1=$host.$LOGNAME:$PWD:`echo ``date +%Y.%m.%d-%H:%M:%S`` `:`echo  "\n" $ " "`
$host.$LOGNAME:$PWD:$

copy a file with timestamp
cp file file_`date +%Y%m%d-%H%M%S`

# tar and compress all csv files
gzip -cd *log | tar -xf - || exit 1

# tar and compress all log files
gzip -cd *log | tar -xf - || exit 1

echo "The script you are running has basename `basename $0`, dirname `dirname $0`"
echo "The present working directory is `pwd`"



#The dir where the script runs ( Note no / at the end !!! )
RunFolder=`dirname $0`
case $RunFolder in
        /*);;
                *)RunFolder=`pwd`/$RunFolder;;
esac

#The dir where the logs are stored( Note no / at the end !!! )
LogFolder=`dirname $0`
case $LogFolder in
        /*);;
                *)LogFolder=`pwd`/$LogFolder;;
esac



 find project -type f -print | \
egrep '(\.[ch]|[Mm]akefile)$' > Include
% tar cvf project.tar -I Include

echo how-to delete entire directory recursively without prompts for confirmation
rm -Rf /path/to/dir/toDelete/Without/Prompt/Recursively

sh shell shortcuts
Alt + K

echo two for loops
for i in `echo A B` ; do for j in `echo C D` ;do echo $i$j;done;done ;

echo mutliple rename of files with sed and regex
for file in *.txt; do mv $file `echo $file | sed 's/\([A-Za-z_]*\)_\([0-9]*\)\([A-Za-z\.]*\)/\1\3/'` ; done ;

2011-04-13

My predictions about electric cars coming true ... (revised)

My predictions about electric cars coming true ... (revised)

I predicted in 2009 that electric cars will be in 10 years the dominating type of cars in ...

http://www.greenoptimistic.com/2011/04/13/dbm-energy-battery/

http://news.cnet.com/2300-11128_3-10005197.html?tag=mncol;txt




Well , that is coming true ... Believe it or not ; )

2011-04-12

how-to get column meta data on sql server 2008



 
/****** Object:  View [dbo].[viewMeta_TableColumns]    Script Date: 05/09/2010 09:13:14 ******/
IF  EXISTS (SELECT * FROM sys.views 
WHERE object_id = OBJECT_ID(N'[dbo].[viewMeta_TableColumns]'))
DROP VIEW [dbo].[viewMeta_TableColumns]
GO
 
/****** Object:  View [dbo].[viewMeta_TableColumns]    
Script Date: 05/09/2010 09:13:14 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
 
CREATE VIEW [dbo].[viewMeta_TableColumns]  
AS   
 
-- Action !!!
SELECT top 100000
 
db_name()                AS 'DataBaseName' 
,isc.TABLE_SCHEMA        AS 'SchemaName'
,SysObjects.NAME        AS 'TableName'
,SC.NAME                AS 'ColumnName'
,isc.ORDINAL_POSITION    AS 'OrdinalPosition'
,st.name                AS 'DataType' 
,sc.is_nullable            AS 'IsNullable' 
,sc.is_identity            AS 'IsPrimaryKey'  
,sc.max_length            AS 'MaxLength' 
,SC.is_computed            AS 'IsComputed' 
,sm.text                AS 'DefaultValue'
FROM dbo.sysobjects  
INNER JOIN sys.all_columns SC ON SysObjects.id = SC.object_id
INNER JOIN sys.types st on st.system_type_id = sc.system_type_id
LEFT JOIN syscomments sm on SysObjects.id = sm.id
-- LEFT JOIN sys.tables stb on sc.object_id = SysObjects.parent_obj
LEFT JOIN INFORMATION_SCHEMA.COLUMNS  isc on 
isc.TABLE_NAME=SysObjects.NAME and SC.NAME = isc.COLUMN_NAME
 
--LEFT JOIN dbo.syscomments SM ON SC.cdefault = SM.id  
--inner join sys.types st
--on sc.xtype = st.system_type_id
WHERE SysObjects.xtype = 'U'  
and st.name <> 'sysname' --to a bug with this one occurs if enabled 
and sc.is_computed = 0 --todo a bug with this one occurs if enabled 
 
--and SysObjects.name = @TableName --uncomment this line while debugging
ORDER BY DatabaseName , SchemaName , TableName , isc.ORDINAL_POSITION
 
 
GO
 
--select * from sys.schemas
select * from [viewMeta_TableColumns]

2011-04-10

How-to define stupidity with BI ?!

Let's admit it. Everybody has done something stupid in their life ... even the most brightest of us. I read somewhere that the wisdom is to avoid the done mistakes and to restrain from doing more than 5 min stupid things per day ...
I still do think that BI should be applied even to the most personal issues ... to draw some meaningful conclusions ...
So my conclusion for today:
If more than 5 min per day stupidity defines a person as stupid ... today I was I very stupid person ... since I did loose more than a month today ...
I hope I will learn something from today. So if I don't manage to become humble and restrict to those 5 minutes ... I will not pass to where I aim to ...

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) git cheat sheet (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) architecture (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) IDEA (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture input output (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy paste (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scala ScalaFmt (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smells (1) smtp (1) software development (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) system design (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List