i50729 Tech Freak

We are moving to a newer site: rhub.in

2012-12-02T16:33:00.000+05:30

Hello Readers,

Thanks for your following and reading. Now we are moving to a whole new site of our own. It is http://rhub.in. Hope to see you there too, with greater enthusiasm.

Keep reading.

View file names in two rows in Notepad++

2012-11-23T22:59:00.000+05:30

Notepad++ is one of favorite tools of many programmers and script writers. Many a times we are in such a situation wherein we have to keep many files open at some common time. In such a situation, we have to rely on [Ctrl][Tab] or < and > arrow on the row of filename tabs in Notepad++.

Alternatively, we can have multiple rows of filenames in Notepad++. For this, we have to make this setting:
Settings -> Preferences -> General -> Tab bar -> Multiline

Ensure that 'Multiline' chekbox is checked. When it is checked, filenames are displayed in 1, 2, 3 or as many rows as required for currently opened files, based on number of files and lengths of their names.

Enjoy coding this time!

"TABLE" keyword and SQL statements

2012-10-22T00:24:00.001+05:30

We are many a times confused about whether TABLE keyword appears in a SQL statement. Here I present a handy trick. It says:

Read below sentences in sequence-
Beside others, there are two types of SQL statements- DDL and DML.
DDL deals with creating, altering and dropping data structures such as tables.
DML deals with inseting, updating and deleting data within tables.

As DDL deals with main furniture of database, i.e., tables (similar to wooden tables) and they can drop your tables (on the ground to destroy them), they expect use of TABLE word explicitly.
e.g.,
CREATE TABLE t1(...);
ALTER TABLE t1 ...;
DROP TABLE t1;

As DML deals with data within tables, they do not use the word TABLE. In DML statements, table name appears directly (without use of keyword TABLE).
e.g.,
INSERT INTO table01 ...; -- TABLE keyword not used here
UPDATE table01 ...; -- TABLE keyword not used here
DELETE FROM table01 ...; -- TABLE keyword not used here

The above find is my own. In the beginning, even I had also been confused with the use of TABLE keyword. But, as it is rightly said, "Need is the mother of Discovery," I have finally come out of this trauma.

[If you like posts, do share their links.]

Oracle database default setup Users and their Passwords

2012-10-17T23:29:00.003+05:30

When you install Oracle database engine using default installation configuration, few superusers are created.

Two such users are:

SYS
SYSTEM

Users SYS and SYSTEM are:
– created automatically during database creation,
– granted the DBA role.

• User SYS
– Owner of the database data dictionary
– Default password: change_on_install

• User SYSTEM
– Owner of additional internal tables and views used by Oracle tools
– Default password: manager

Hope you won't again be depressed if you forget to check or change default passwords of these users while setting Oracle database engine up!

Did you know:
You can easily find i-tech-freak.blogspot.com listed on first page of Google search results by querying for "i-tech-freak". Enjoy reading.

Fix Your Broken Outlook Personal Folders (PST) File

2012-06-14T16:24:00.000+05:30

If you use Outlook and you’ve noticed it being excessively slow or just having errors, you should probably scan and repair your Personal Folders file for any problems. It’s sorta like checkdisk for your email.
Repairing Your PST File
To repair your PST file, you’ll have to open the Scanpst.exe utility that’s included by default with Outlook. The only problem is that there’s no shortcut to it, so you’ll have to find it in the Outlook folder.
Open up explorer and then browse down to the following folder for Outlook 2007:

C:\Program Files\Microsoft Office\Office12

Or one of these folders for Outlook 2003 and earlier (thanks to Mike in the comments):

C:\Program Files\Common Files\System\Mapi\1033
C:\Program Files\Common Files\System\MSMAPI\1033

Once you open up the utility, you’ll have to find the location of your PST file by clicking the Browse button. If you don’t know the location, there are instructions for figuring out the location further down in this article.

Click on the Start button to start the scan…

It will take a while to scan the file, and you’ll get a report at the end telling you whether you have errors in the file.

Click on the Repair button, and after a while you’ll finally get the “Repair complete” message.

If you are curious what was actually repaired during the process, you’ll find a text file in the same directory as your PST file with the same name as the PST file.

Most of the information in the file is pretty cryptic… so I’m not sure reading it will help all that much.

Find Your Outlook PST File Locaton
If you just have a single PST file created automatically by Outlook, there’s a standard location under your user profile directory. Open up an explorer window, and then paste in the following into the address bar:

%appdata%\Microsoft\Outlook

You should see your PST file in the list, usually called Outlook.pst at least in the later versions of Outlook. If you’ve created a new personal folders file, it might be in a different location.
Find Location of Outlook PST in Non-Standard Location
Sometimes your PST file will be in a different location, for a number of reasons.. for instance if you created a second PST you would have been prompted to save it somewhere.
If you can actually open Outlook, right-click on your personal folders location, and then choose Properties.

On the properties screen, click the Advanced button.

Now you’ll see the location of the file in the Filename field. As a bonus, you can also compact the folders from here (although you shouldn’t compact it until it’s repaired first)

It’s well worth it to scan your PST file every so often so you don’t lose data. Of course… you should be backing up your files as well.
Courtesy: HowToGeek

Google Drive: Online Office Suite

2012-06-12T15:35:00.000+05:30

Did you know that you store a lot of your personal and official information on a cloud? Where do you think all the attachments in your web mail accounts are stored? However, when it comes to consciously storing data and accessing it, most of us prefer a USB flash drive or, if the data is sizeable, a portable hard disk drive (HDD). Now, Google Drive aims to change this since it is not just a warehouse, but also offers a bunch of applications.

An office suite

At first glance, Google Drive seems just another storage service; all you see is a series of files that you would want to share. However, when you visit the Google Drive website ( drive.google.com), you will also see a 'create' option, which lets you use Google's online office suite, Google Docs. This allows you to create and edit documents, spreadsheets, drawings, even presentations, providing you with an online office suite. It's almost like having a computer in your browser.

To use Google Drive, all you need is a Google ID. If you have a Gmail account, it will suffice. You can also download the Google Drive app on your computer, be it a PC or a Mac, as well as Android phone and tablet. Though you can create and edit documents through the app on your Android phone, this facility isn't available offline if the app is downloaded on to your computer.

Google Drive offers 5 GB of storage for free. If you need more, you will have to shell out a monthly fee, which starts at $2.49 (Rs 137) a month for 25 GB, and goes up to $800 (Rs 44,000) a month for 16 TB. Upgrading to a paid account will also expand the storage of your Gmail account and Picasa web albums as the storage is shared among these.

Share and sync

The search feature is very good as you can hunt not just for document names but also terms used in them and, in a neat touch, even for words used in scanned documents. In fact, you can upload PDFs and scanned documents and Google Drive will translate them into Google Docs using optical character recognition. However, this aspect requires some fine-tuning. Google Drive keeps most of Google Docs' sharing options intact. So you can share documents and files from Google Drive either by sending them as attachments or simply by sharing links.

This is where we discovered another impressive feature of Google Drive. If you share a document with someone else, they will be able to view it even if they do not have the software you used to create it. For instance, if you share an image you created using Photoshop, it can be seen by recipients even if they do not have Photoshop. What's more, they will be able to comment on it.

The best part is that all the files you store on your Google Drive will be synchronised automatically across different devices, allowing you to access the same files from different computers, phones and tablets. You can even see live updates of changes made by you or anyone you have shared a file with. All you need is an Internet connection, so you don't have to worry about carrying your pen drive.

Is it RIP, thumb drive?

Does the plethora of sky drives mean that it's time to ditch the traditional thumb drive? If you don't carry loads of data, and your portable needs are less than 5 GB, Google Drive is suitable for you. However, if you have high storage needs, this can prove to be an expensive proposition. Even at the lowest subscription of $2.49 a month, you will end up paying about Rs 1,650 for using 25 GB for a year, which is more than the cost of most 32 GB flash drives. Another problem is that network access is erratic in many places in the country. If you do manage to get hooked up, the speed could be very slow and downloading or uploading large files could take hours.

A good option is to upload important or frequently used files to Google Drive and store the ones that are rarely used on an HDD. This will save you the effort of having to plug a thumb drive in and out of multiple USB ports in computers. Another advantage is that unlike a thumb drive, cloud storage won't get damaged or become unreadable, which minimises the chances of losing valuable data.

Courtesy: Tech Gig

Get converted - pdf to doc, and doc to pdf

2012-03-24T10:12:00.003+05:30

Mail @ rishi.raj.88@gmail.com.

get your printed or written material typed

2012-03-24T10:12:00.000+05:30

If you need soft copy of your notes, books or other kind of material on paper, then mail @ rishi.raj.88@gmail.com.

2011-09-12T00:51:00.002+05:30

Shut down and Restart Windows Computer Faster

2011-09-12T00:21:00.003+05:30

if your observe that you computer is slow to shut down and takes several minutes just to shut down, you do need to make this setting to fix the problem.

Making this setting will make your computer to shut down as quickly as in 2-3 seconds (depends from time to time). This is how it goes:
1. Start>> Run
2. Type in regedit and press OK.
3. In Registry Editor, go to left side pane. In that, navigate to:
My Computer
+ HKEY_LOCAL_MACHINE
+ SYSTEM
+ CurrentControlSet
+ Control
4. On right side, set value of WailToKillServiceTimeout to 1000 following way:
a. Double-click on WailToKillServiceTimeout .
b. Under value data, type in 1000 .
c. Press OK .
d. Close Registry Editor (regedit).
e. Next time you shut your computer down, the effect is visible and clear.

"Enjoy life to its fullest. Utilize time to its optimum." - Rishi Raj

Removing previous installation of Oracle from Windows box

2011-08-21T21:20:00.004+05:30

Suppose you have deleted folders of previous Oracle installation from your Windows box. Now you run Oracle installer to install Oracle again, but the installer is saying that Oracle is installed and asks you whether you want to uninstall (deinstall) that. You choose to unistall previous Oracle installation, but fail to find one and ultimately fail to install Oracle anew.

If you are facing this problem, then you should think of stopping Oracle-related services and remove Oracle-related registry entries. To know how to do this, follow this:

Stop Oracle-related processes and services. Steps are:

Run Task Manager and go to Processes tab of that.
Now look for services with names containg ora or oracle.
End those processes.

Delete Oracle installation folder.

If you could not have deleted C:\oracle or D:\oracle or wherever you had installed Oracle previously and C:\Program files\Oracle, then try deleting that folder now.

Remove Oracle-related registry entries.

Start --> Run --> type in regedit and hit OK.
Delete the following keys (some may have slightly different names in your registry):
HKEY_CURRENT_USER\SOFTWARE\ORACLE
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\Oracle.oracle
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleDBConsole
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle10g_home
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OraclService

Now restart your computer and try installing Oracle afresh.

Enjoy!!!

Shut down computer in less than five minutes

2011-08-10T23:21:00.000+05:30

Have you ever come across a situation when your Windows box has refused to shut down quickly enough or shut down at all?

If your answer is "Yes", then follow these simple steps to make your computer shut down really quickly:
1. Run task manager (by pressing key combination Ctrl+Alt+Delete or any other way you may like :-) ) .
2. In menu bar, choose Shut Down.
3. Press and hold Ctrl key.
4. While holding Ctrl key pressed, click on Turn Off menu item.
5. Release Ctrl key.

Computer now shuts down within 2-3 seconds.

Running multiple instances of GTalk (Google Chat Messenger)

2011-08-10T23:11:00.000+05:30

Steps to enabling multiple instances of GTalk:
1. Create or locate a shortcut to your installed GTalk executable
file.
By default, the executable file is
"C:\Program Files\Google\Google Talk\googletalk.exe"

2. To Target value of this shortcut, add
/nomutex
[Method to implement step 2.:-
shortcut file --> right-click --> Properties --> Target]

See the screenshot below:

Now every time you launch GTalk with this shortcut, you get a new
instance of GTalk launched. Sign in with a different email id on
the same computer and enjoy GTalking! :-)

Set Gmail as your default email client in Firefox

2011-08-09T23:51:00.001+05:30

If you like to auto-reply using your Gmail account by clicking on a mailto: link, follow this:

You can configure your Mozilla Firefox to automatically take control of a clicked mailto: link and let you use your Gmail ID to send a mail. The steps for doing this are given here below:
1. Open Firefox.
2. Log in to your Gmail account.
3. Copy-Paste this script in the address bar of Firefox with your Gmail account open.
javascript:window.navigator.registerProtocolHandler("mailto","https://
mail.google.com/mail/?extsrc=mailto&url=%s","Gmail")

4. Click "Add Application", if you are prompted to. Otherwise, follow these menus:-
Tools --> Options --> Applications
5. In the list of content type and applications, locate mailto under Content Type, and choose "use Gmail" from the list of applications suggested for that content type.

6. Save the settings.

Enjoy Gmailing with Firefox.

Delete Locked Files Which Cannot be Deleted Otherwise

2011-08-07T14:22:00.000+05:30

Here you will learn about a utility that enables you to delete those stubborn files that test your frustration level and tempo by not getting deleted. The name of that useful utility is FileASSISSIN.

A file or folder can deny its deletion pertaining to any of the following possible reasons:

The file is in use by another program or user,
Access to that file for you is denied.
Some malware/virus infection or activity.

You may find these messages while you try to delete a file:

Access denied.
Make sure the disk is not full or write protected and the file is not currently in use.
This file is in use by another program or user.

FileASSASSIN is an application that can delete any type of locked files. Whether the files are from a malware infection or just a particular file – FileASSASSIN can delete it for you!

Download FileASSASSIN here.

A WORD OF CAUTION: File ASSASSIN can unlock your system files too and let you delete those, so be extra cautious using the utility when working with system files as deleting those files may cause your system to crash.

contact

2011-08-07T13:55:00.001+05:30

Hi Reader,

I am Rishi Raj, sharing technical stuff with you and trying to solver your day-t-day problems that you might come across while using your computer system (more ofter Windows box). I can help you better if you help me help you. And, you can do so by mailing to me your problems, queries, comments on post and suggestions.

You may also mail to me tips, tricks and solutions that think should be share across. Those will be published with your name. So, please do mail me, if you find something like that. My email id is i50729@gmail.com.
One more thing, spread the name of the blog among your friends, colleagues and all so as to make it a success.

Happy i-tech-freak'ing!

-
Rishi Raj

GeeMail - Desktop client for Gmail Access Gmail without internet browser

2011-08-07T13:42:00.001+05:30

Have you ever wished to check your Google mails without using any internet browser? If yes, then your wish has come true! Yes, you've got an application solely designed for Gmail. This is GeeMail. Using this, you can work with your mail (Gmail only) more efficiently and effectively as compared to as you do with then while with a web browser.

Attractive features of GeeMail:

No configuration required-

GeeMail has everything in place which is required to access Gmail. You don’t need to configure it like traditional email clients.

Offline support-

Even if you are offline, compose your email, click “Send”. GeeMail will send the mail for you the next time it detects Internet connection.

Gmail user interface-

No training or learning required for using GeeMail user interface because GeeMail supports the good old UI of gmail itself. Things just work the way they do in gmail, right down to the keyboard shortcuts!

Cross platform-

GeeMail is truly cross platform. GeeMail works on Windows, Mac and Linux.

Download GeeMail here. Install it and enjoy GeeMail'ing.
You need to have Adobe AIR installed to use GeeMail.

Hacking Windows login password

2011-08-06T02:00:00.001+05:30

Things may go wrong, and they do. You may forget your Windows login password and strive for logging in to your Windows computer.

For this, here is a solution:
EBCD (Emergency Boot CD)
1. Google for it.
2. Download it
3. Install/run it.
4. Create a bootable CD of it.
5. Next you just need to boot your computer with this bootable CD, and follow instructions and take steps.

To boot computer with a CD/DVD:
1. Start/restart your computer.
2. The moment your ketboard lights flash, start pressing Delete key repeatedly to get to BIOS setup.
3. Under boot menu (different systems have different menus), set CD-ROM as primary boot device.
4. press F10 to save and exit.
5. Let the computer boot trom CD. (You will need to press a key for this.)
When the system has booted with CD, you will see EBCD instructions for resetting Windows password.
[you can set your computer to boot primarily with local hard disks similarly.]

To recover deleted file

2011-08-04T00:25:00.000+05:30

There are good times also, and there are bad times also. How bad do you feel when any of your personal and precious pictures is deleted accidentally. It is even more worse when it seems to be impossible to get another copy of it.

Here is a solution for this query. You can recover deleted file. You can also recover files from a formatted disk. One free-of-cost tool available for this is:

PC Inspector File Recovery

This utility lets you select your disk or partition to search for deleted files, select files among them to recover and finally RECOVER THOSE FILES.

Fore more information and download, visit http://www.pcinspector.de.

JOCR -- Reads text out of images

2011-07-30T11:10:00.000+05:30

Have you ever wanted to copy text from images? If not yet, do it now! With JOCR, you can copy text from screenshots and other images.

This utility let you take screenshots and recognizes text out of those screenshots.

This specialised software is JOCR (a.k.a GOCR), a free Optical Character Recognition software. What the software does is read the text on the screen and reproduces it in editable text format. This means that you can easily screenshot and copy all text that is in protected webpages (no right-click option pages), locked PDF documents, error messages, etc. The program does offer several capture modes. It is legally advisable to respect copyrights of concerned parties.

Drawbacks of this freebie:
> The text copied is plain text sans the formatting as you see, so no bolds, italics, or as it appears in a magazine.
> It cannot read your handwriting.

Download JOCR
http://home.megapass.co.kr/~woosjung/Files/JOCR.exe

Shock 3D -- 3D Desktop for Windows --- Amazing!

2011-07-30T10:45:00.000+05:30

Bring Half-life 2 right into your desktop... with Shock 3D

If you thought Windows 7 desktop was cool, wait till you see Shock 3D,
an OpenGL application that is under 3MB. The application turns all
your icons/desktop into 3D, such that you can move them around like
objects. If you've ever played Half-life 2 using Gravity gun to
interact with objects (Havok physics), you'll know what I talking
about.
Some of the selected icons are 2D and others are 3D, while being fully
interactive at the same time
A drawback of this app is that you cannot use your desktop normally as
Shock 3D sits as a layer on top of your desktop, it is not a fully
baked application to replace your desktop. But give the Korean
developer a break, they have created something cool and deserve the
credit. Microsoft if you are listening, steal this idea right away!
Download page:
http://www.docs.kr/entry/Download-Shock-Desktop3D-en

Running an application as a different user without logging off and on

2011-07-30T09:50:00.000+05:30

Have you ever needed to run a program or an application with different user's credentials? For example, you have logged on as a normal user with limited privileges and you want to activate a service or make some other system-level change. To do this, you need not close all your open programs and log off and then log on with an administrator account, make changes and then log out, and login with your normal user account to see the effect.

You can run a program as a different user without logging out in. To see how, read below:
1. Right click the icon of that program or a shortcut to that, select Run As...
2. Enter the user name and password you want to use.

This only applies for that run. The trick is particularly useful if you need to have administrative
permissions to install a program.

Note: For this trick to work, Secondary logon service must be running.
To start this service, follow these steps:
1. Start ->> Run...
2. Type in services.msc and select OK.
3. In the Services window, locate secondary logon, and start that by viewing its properties.
4. Close Services window.

Disabling need for entering username and password while startup

2011-07-25T14:38:00.000+05:30

Many a times you find it inconvenient and time consuming, when you have to log in to you system frequently. It gets even more irritating when you need to enter your username and password for logging in.

You can boot and login without entering user name and password. Just follow these steps:
1. Select Start --> Run...
2. In Run dialog box, type control userpasswords2.
Doing so opens the user accounts application.
3. On the Users tab, clear the box for Users Must Enter A User Name And Password To Use This Computer.
4. Click on OK. An Automatically Log On dialog box will appear.
5. In that dialog box, enter the user name and password for the account you want to use.

Now you can log in to your system without hassling with user name and password.

Enjoy!

- Rishi Raj
Mail | WebAnswers | Google Groups

To get valuable system information, like 'system installation date and time'

2011-07-25T14:15:00.000+05:30

If you want to get operating system and hardware related information about your computer, then you need not download any tool for the same. This information includes details like operating system (OS) version, OS installation date, processor (CPU) type/class among others.

You get retrieve vital system information by following these steps:
1. Run command prompt.
[Hint: you can run command prompt by either of the ways:
a. Start --> Run... --> type
cmd
and hit Enter key.
b. Start --> Programs --> Accessories --> Command Prompt]
2. In command prompt, type systeminfo.

The computer will produce a lot of useful info, including the uptime.

To Save System Information to a File:
If you want to save this information to a file, type
systeminfo > info.txt
in command prompt. This creates a file called info.txt you can view later with Notepad or any other text viewer.

Receiving Mail Alerts for Gmail on mobile phone

2011-07-23T19:10:00.000+05:30

Many a times you might have found it to be troublesome to go to computer for checking your important emails. You find it even irritating, if you have to go to computer (to go to some cafe and pay) just to check whether you have received any new emails.

To avoid this hassle and expense, opt for receiving email alerts right on your mobile phone. It'll be very handy, right?! :-)
To receive email alerts in form of SMS (totally free of charge) on your mobile phone, follow these steps:
1. Visit http://www.way2sms.com and register with your mobile number.
2. Get you email account activated on way2sms.com by clicking on
"Mail" tab.
3. Login to http://mail.google.com and go to "mail settings".
4. Under "Email Forward and IMAP/POP" tab, make settings to forward your emails arriving in your Gmail mailbox to your way2sms email account.
[you make these settings with both gmail and way2sms email accounts.]
4. click on "Mail alerts" link to activate email alerts.

From now on whenever your receive a mail with your Gmail account, the
same email will be received with your way2sms account and your mobile
phone will ring out:"1 New Message!"