Script to Connect to FTP by passing username/password thru txt file

AccountInfo.txt
-------------------
user username password
prompt
binary
mget *.*
quit

ConnectFTP.cmd
-------------------
C:
cd C:\Temp
ftp -n -s:C:\Temp\AccountInfo.txt FTPHost
exit

Shell Script to connect to SFTP

Then connect to your machine and type

$ sftp username@HostName
Connecting to Host...
username@Host's password:
sftp>

if you already created a key pair to not promt for password then you would directly connect to SFTP with out prompting for the password

$ sftp username@HostName
Connecting to Host...
sftp>

Shell Script to connect to SFTP and upload/download files

#vi SFTPupload.sh will open a vi editor to edit/create the shell script
vi SFTPupload.sh
sftp username@hostname EOF
#sftp -b /dev/stdin username@hostname EOF
mput *.*
quit

then enter :wq it will save and comeout of the vi editor

Connect to SFTP with out prompting for Password (passwordless)

To script connecting to SFTP with out prompting for a password ,you would need to generate key pairs to do authentication. To do passwordless SFTP follwo the steps to create a key on your machine:

$ /bin/ssh-keygen -t dsa

Keep the default values for the all the prompts just by clikcing on enter.

$ /bin/ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/home/username/.ssh/id_dsa):
Created directory '/home/username/.ssh'.
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/username/.ssh/id_dsa.
Your public key has been saved in /home/username/.ssh/id_dsa.pub.
This will generate the key pairs (id_dsa & id_dsa.pub)


The file called id_dsa.pub is the public_key and id_dsa must be private.
Copy the publick key to authorized_keys in your remote machine

You would find the file in .ssh directory in the remote machine.

If authorized_keys file not already there in remote machine , Place it in the .ssh directory on the remote machine and call it authorized_keys. You may have more than public key in the authorized_keys file.one for each remote machine.

Filename with out extension using Shell Script

#!/usr/bin/sh

MYFILENAME="/xyz/abc/myfile.txt"

echo "File Path: ${MYFILENAME%/*} o/p :/xyz/abc"
echo "FULL Filename: ${MYFILENAME##*/} o/p :myfile.txt"
echo "File Extension: ${MYFILENAME##*.} o/p :txt"
echo "Filename with out extension: ${MYFILENAME%.*} o/p:myfile"

Select Nth row from a table

Retrieve only the Nth row from a tableSELECT * FROM empWHERE rowid = (SELECT rowid FROM emp WHERE rownum <= 5 MINUS SELECT rowid FROM emp WHERE rownum ‹ 5); SELECT * FROM empWHERE rownum=1 AND rowid NOT IN (SELECT rowid FROM emp WHERE rownum ‹ 5);

Retrieve only the x to yth row from a table


SELECT *FROM emp
WHERE rowid in (
SELECT rowid FROM emp
WHERE rownum <= 7
MINUS
SELECT rowid FROM emp
WHERE rownum ‹ 5);


To get every Nth row from a table.

SELECT * FROM emp
WHERE (ROWID,0) IN (SELECT ROWID, MOD(ROWNUM,4)
FROM emp);


SELECT *
FROM ( SELECT rownum rn, empno, ename
FROM emp ) a
WHERE MOD(a.rn,4) = 0;

Got certified in MS SQL Server 2005 (70-431)

Today I got certified in MS SQL server 2005(MCTS 70-431).

If any body appering for this exam and want to know more about the exam and simulations , leave your comment.

I will try to help you guys to make good score.

All the very best.

To know more about Microsoft exams Click Here

Donate for 2008 Sichuan Earthquake Victims

On May 12, 2008, a 7.9-magnitude earthquake struck central. Over 40000 (still counting) people lost their lives and 3.5 million homes have been destroyed. Please help to support relief efforts for a disastrous situation that's still unfolding.

How to donate:
1. Online donation with credit card: http://www.mercycorps.org/
2. Online donation with Paypal, Google Checkout or Wire Transfer: http://tsinghuafoundation.org/earthquake08/index.html
3. Donate by check:
SVTN
Attn: China Earthquake Relief
P. O. Box 1295
Fremont, CA 94538-0129

Mobile Phones on the Plane

You can talk with your loved ones during flight in the near future, click here to know more.

Check your eligibility amount you can get for fiscal year 2007-2008

To find out if you are a nonresident alien or resident alien Click here and see page 5.

Click here to check your eligibility amount you can get for the fiscal year 2007-2008.

Thousand Islands in New York

Small Island that connects US & Canada.


Boldt Castle Power House

Bold Castle

Lord Sri Hanuman Temple in Trinidad and Tobago - West Indies

Great Niagara Falls in India

Vazhachaal in kerala

GNUPG Encryption & Decryption

1.Generate a key-pair:
 In order to generate key pair, first we need to create a public key (which is used for signing)
 and then a sub-key to encrypt files. Unless we create a sub-key we cannot encrypt a file.

 a) Create a public key:

  F:\temp>gpg --gen-key
  
  gpg (GnuPG) 1.4.7; Copyright (C) 2006 Free Software Foundation, Inc.
  This program comes with ABSOLUTELY NO WARRANTY.
  This is free software, and you are welcome to redistribute it
  under certain conditions. See the file COPYING for details.

  gpg: keyring `C:/Users/srini/AppData/Roaming/gnupg\secring.gpg' created
  gpg: keyring `C:/Users/srini/AppData/Roaming/gnupg\pubring.gpg' created
  Please select what kind of key you want:
     (1) DSA and Elgamal (default)
     (2) DSA (sign only)
     (5) RSA (sign only)
  
  Your selection? 5
  RSA keys may be between 1024 and 4096 bits long.
  What keysize do you want? (2048) 1024
  Requested keysize is 1024 bits
  Please specify how long the key should be valid.
    0 = key does not expire
          = key expires in n days
        w = key expires in n weeks
        m = key expires in n months
        y = key expires in n years
  Key is valid for? (0) 0
  Key does not expire at all
  Is this correct? (y/N) y

  You need a user ID to identify your key; the software constructs the user ID
  from the Real Name, Comment and Email Address in this form:
      "Heinrich Heine (Der Dichter) "

  Real name: Srini
  Email address: cnuusa@gmail.com
  Comment:
  You selected this USER-ID:
      "Srini "

  Change (N)ame, (C)omment, (E)mail or (O)kay/(Q)uit? o
  You need a Passphrase to protect your secret key.

  gpg: DBG: rndw32: get performance data problem
  We need to generate a lot of random bytes. It is a good idea to perform
  some other action (type on the keyboard, move the mouse, utilize the
  disks) during the prime generation; this gives the random number
  generator a better chance to gain enough entropy.
  gpg: DBG: rndw32: get performance data problem
  +++++
  ..+++++
  gpg: C:/Users/srini/AppData/Roaming/gnupg\trustdb.gpg: trustdb created
  gpg: key 783D5846 marked as ultimately trusted
  public and secret key created and signed.

  gpg: checking the trustdb
  gpg: 3 marginal(s) needed, 1 complete(s) needed, PGP trust model
  gpg: depth: 0  valid:   1  signed:   0  trust: 0-, 0q, 0n, 0m, 0f, 1u
  pub   1024R/783D5846 2008-03-08
        Key fingerprint = 96D5 0AE1 38E8 4286 978A  6B39 28B4 BC41 783D 5846
  uid                  Srini 

  Note that this key cannot be used for encryption.  You may want to use
  the command "--edit-key" to generate a subkey for this purpose.

 b) Create a Sub-key for encryption:

  F:\temp>gpg --edit-key CNUUSA@gmail.com
  gpg (GnuPG) 1.4.7; Copyright (C) 2006 Free Software Foundation, Inc.
  This program comes with ABSOLUTELY NO WARRANTY.
  This is free software, and you are welcome to redistribute it
  under certain conditions. See the file COPYING for details.

  Secret key is available.

  pub  1024R/783D5846  created: 2008-03-08  expires: never       usage: SC
         trust: ultimate      validity: ultimate
  [ultimate] (1). Srini 

  Command> addkey
  Key is protected.
  You need a passphrase to unlock the secret key for
  user: "Srini "
  1024-bit RSA key, ID 783D5846, created 2008-03-08

  Please select what kind of key you want:
     (2) DSA (sign only)
     (4) Elgamal (encrypt only)
     (5) RSA (sign only)
     (6) RSA (encrypt only)
  Your selection? 6
  RSA keys may be between 1024 and 4096 bits long.
  What keysize do you want? (2048) 1024
  Requested keysize is 1024 bits
  Please specify how long the key should be valid.
    0 = key does not expire
          = key expires in n days
        w = key expires in n weeks
        m = key expires in n months
        y = key expires in n years
  Key is valid for? (0) 0
  Key does not expire at all
  Is this correct? (y/N) y
  Really create? (y/N) y
  We need to generate a lot of random bytes. It is a good idea to perform
  some other action (type on the keyboard, move the mouse, utilize the
  disks) during the prime generation; this gives the random number
  generator a better chance to gain enough entropy.
  gpg: DBG: rndw32: get performance data problem
  ...........+++++
  .+++++

  pub  1024R/783D5846  created: 2008-03-08  expires: never       usage: SC
         trust: ultimate      validity: ultimate
  sub  1024R/5115C601  created: 2008-03-08  expires: never       usage: E
  [ultimate] (1). Srini 

  Command> save

2). Encrypt and decrypt a file: Now we are ready with our keys.

 a) Encrypt a file:

  F:\temp>gpg -r Srini -e readmore.txt

  F:\temp>dir
   Volume in drive F has no label.
   Volume Serial Number is 664F-1775

   Directory of F:\temp

  03/08/2008  05:43 PM              .
  03/08/2008  05:43 PM              ..
  03/03/2008  09:02 PM               207 readmore.txt
  03/08/2008  05:43 PM               350 readmore.txt.gpg
          2 File(s)            557 bytes
          2 Dir(s)  21,445,525,504 bytes free
b) Decrypt a file: Initially, copy the file to another location say test.


  F:\temp>cd test

  F:\temp\test>gpg -o readmore.txt -d readmore.txt.gpg

  You need a passphrase to unlock the secret key for
  user: "Srini "
  1024-bit RSA key, ID 5115C601, created 2008-03-08 (main key ID 783D5846)

  gpg: encrypted with 1024-bit RSA key, ID 5115C601, created 2008-03-08
        "Srini "

Amazing Diamond Mine

This amazing diamond mine located in Russia

It is 525 meters deep and 1.25 km in the diameter.



Reported so many air crashes here because of the suction.

IE 8.0 beta version launched by Microsoft.

Microsoft launched beta version of IE 8.0 (Internet Explorer) with great feature like WebSlices & Activities.

WebSlices :- A feature allowing Web sites to connect to their users by subscribing to content directly within a Web page.

Activities :- which are contextual services for accessing a service from any Web page.Activities are designed to make copying and pasting between Web pages easier to do.

more.

IT companies decided to cut allownce of abroad IT staff

With the recent dollar hurdles all the IT firms decided to cut allownces of IT abroad staff.

According the news magazines the big Indian IT service providers like Tata Consultancy Services , Infosys Technologies and Wipro have launched independent studies to arrive at the revised "per diem" (daily rate of payment) for onsite employees in a bid to cut costs. The move follows IT majors like IBM, TCS and Yahoo weeding out staff for "poor performance".


more

Blu-ray Disc the latest Buzz in the World

Blu-ray Disc (BD), is the name of a next-generation optical disc format.

While current optical disc technologies such as DVD, DVD±R, DVD±RW, and DVD-RAM rely on a red laser to read and write data, the new format uses a blue-violet laser instead, hence the name Blu-ray. This allows data to be packed more tightly and stored in less space, so it's possible to fit more data on the disc even though it's the same size as a CD/DVD. This together with the change of numerical aperture to 0.85 is what enables Blu-ray Discs to hold 25GB/50GB.

more..

Panasonic Launches High Speed 32 GB SD Card.

Panasonic has unveiled the world's fastest SDHC (Secure Digital High Capacity) card, with 32 GB of memory.The new card, to be released April, will comply with the Class 6 speed specification of the SD Card Association.

In January, Toshiba released a 32 GB SD card and SanDisk unveiled a 32 GB SD card.

However, both the Toshiba and SanDisk cards are Class 4 cards, which means they're slower than Panasonic's.

more...

World's Thinnest Notebook

Apple MacBook Air Is World's Thinnest Notebook and is nearly as thin as your index finger.


Click on the image to enlarge


Click on the image to enlarge

Technical specs

• .16 to .75-inch thickness on top
• 12.8 x 8.94 inches
• 3 pounds
• 5 hours of battery life with everything running

• Intel Core 2 Duo Processor at 1.6 or 1.8GHz, motherboard the length of a pencil.
• 800MHz frontside bus.
• 2GB RAM 667MHz DDR2 standard.

• 13.3-inch screen, LED backlit.
• 1,280 x 800 pixels
• Micro-DVI adapter (for DVI, VGA, composite and S-Video output)
• Intel GMA X3100 Graphics processor with 144MB RAM shared

• 1.8-inch 80GB HD or 64GB Solid State Drive (no moving pieces, but for a stunning $1,300 price increase!)
• Multitouch trackpad with gestures. Pans, zooms, rotates, etc.
• 802.11n and Bluetooth 2.1.
• Optional external HD for $99, USB-bus powered.
• Full backlit keyboard.
• One USB 2.0, one audio port, one Micro-DVI
more
CNET reviews

I feared

I feared being alone
Until I learned to like Myself .
**************

I feared failure
Until I realized that I only Fail when I don't try .
***************

I feared success
Until I realized That I had to try In order to be happy With myself.
***************

I feared people's opinions
Until I learned that People would have opinions About me anyway.
***************

I feared rejection
Until I learned to Have faith in myself.
***************

I feared pain
Until I learned that it's necessary For growth ..
***************

I feared the truth
Until I saw the Ugliness in lies.
***************

I feared life
Until I experienced Its beauty .
***************

I feared death
Until I realized that it's Not an end, but a beginning ..
***************

I feared my destiny,
Until I realized that I had the power to change My life.
***************


I feared hate
Until I saw that it Was nothing more than Ignorance.
***************

I feared love
Until it touched my heart, Making the darkness fade Into endless sunny days.
***************

I feared ridicule
Until I learned how To laugh at myself .
***************

I feared growing old
Until I realized that I gained wisdom every day.
***************


I feared the future
Until I realized that Life just kept getting Better.
***************

I feared the past
Until I realized that It could no longer hurt me .
***************

I feared the dark
Until I saw the beauty Of the starlight.
***************

I feared the light
Until I learned that the Truth would give me Strength.
***************

I feared change,
Until I saw that Even the most beautiful butterfly Had to undergo a metamorphosis before it could fly .

Six Steps to Motivate Yourself

Use These Six Steps to Motivate Yourself to Change
By Eve Delunas, Ph.D.

1.Engage Your Imagination. Since motivation always follows imagination, take time to visualize yourself joyfully engaging in your new, chosen behavior. For example, if you want to begin exercising more regularly after work, start envisioning yourself exercising and feeling fabulous. Picture how good it feels to move your body after a mostly sedentary day at the office. Imagine yourself feeling fit and vigorous, brimming with vitality and enjoying the whole experience. The more you practice your new behavior in your mind's eye, the more inspired you will feel to incorporate it into your lifestyle.

2. Take Baby Steps. Begin with little changes that are reasonable. For example, if you are currently a couch potato, don't expect yourself to suddenly begin exercising for an hour a day. That's just a set-up to fail. It's much better to start small, and gradually build up to an hour a day. A reasonable goal might be to begin exercising three days a week for twenty minutes at a time. As this gets easier, you can include more days, and make your exercise sessions a bit longer.

3. Use Positive Self-Talk. Remind yourself that a journey of a thousand miles begins with a single step. Focus on where you are going-not where you have been. Self-criticism is not motivating-rather, it is paralyzing. Speak to yourself in encouraging ways. Pat yourself on the back for being willing to try to establish new, healthier habits. Focusing on how you could have or should have changed sooner is simply a waste of energy. Celebrate the fact that you are making a positive change today!

4. Find a Buddy. You don't have to do this alone. It can be very helpful to team up with someone else who is trying to make the same changes that you are. Join a support group, or find a friend with similar goals. Make a commitment to check in with each other daily by phone or email to hold each other accountable and to offer encouragement.

5. Be Gentle with Yourself. You will, at times, slide backwards, disappoint yourself, and fail to meet your own expectations. Don't let a little backsliding dishearten you. Remind yourself to take it one day at a time. Tomorrow is another opportunity to practice your new, healthier lifestyle.

6. Avoid Comparing Yourself to Others. You will always find someone who is farther along the path than you are. Keep your focus on your own progress, rather than on how you measure up to others. Comparing yourself to others is a waste of time and energy, and only leads to discouragement. It really doesn't matter what anyone else is doing. What matters are the choices you make today to live a better life!

About the Author:
Eve Delunas, Ph.D., psychotherapist, author, speaker, trainer. Download a FREE guided meditation to relieve stress and feel more peaceful. Sign up for a FREE monthly ezine called AWAKENINGS: RESOURCES FOR ENLIGHTENMENT. Go to: http://innervisionresources.com

TCS launches second campus in Hyderabad

Synergy Park will be biggest TCS facility in city with 8,000 seats
Hyderabad, February 11, 2008: Tata Consultancy Services (TCS), a leading IT services, business solutions and outsourcing organization, announced the launch of its second Global Delivery Centre (GDC) in the city. Synergy Park, which is located in Gachibowli will be inaugurated by Honorable Chief Minister of Andhra Pradesh, Dr. Y.S. Rajasekhara Reddy.
Synergy Park will be the second TCS campus and the largest TCS facility in Hyderabad. Built over an area of 50 acres with a capacity of 8,000 people, the campus is being built in two phases; the first phase is already operational while the construction of phase two will commence in April 2008.
Synergy Park is an approved Special Economic Zone and will serve global TCS customers in industry segments like Telecommunications, Media & Entertainment, Government, Healthcare & Life Sciences, Hi-tech, Manufacturing, Retail as well as Banking & Financial Services with a focus on technology areas like enterprise solutions, assurance services and infrastructure services as well as IT services.
Speaking on this occasion, Chief Executive Officer and Managing Director, Mr. S Ramadorai said: “The inauguration of Synergy Park is a significant milestone for our operations in Hyderabad and underlines the importance of the city as a key center in our Global Network Delivery Model. “With a strong education eco-system, plentiful talent and good infrastructure, Hyderabad has emerged as a leading IT destination and the city will continue to play a significant role in our growth plans”, Mr Ramadorai added.
more