How do I clear my passwords in Picasa?

Find a file named catdata_info.pmp stored in your personal profile area and delete it. That will clear any passwords you have set for collections in Picasa.

Make sure Picasa is closed before proceeding with these instructions.

Run a search for: catdata_info.pmp

1. Click "Start."
2. Click "Search."
3. Click "All Files and Folders."
4. Make sure the search is set to "Look in:" Local Hard Drive (C:).
5. Click "More Advanced Options" to check the "Search Hidden Files and
Folders."
6. In the "All or part of file name" field, enter: catdata_info.pmp
7. Click "Search."

Windows will find "catdata_info.pmp." Just right-click it to select
"Delete", then click "Yes." When you open Picasa again, none of the
Collections including Hidden folders will require a password to access.

Or traverse the folders in your profile on windows. Complete path can be like C:\Documents and Settings\'your profile id'\Local Settings\Application Data\Google\Picasa2\db2>. Delete the file catdata_info.pmp and the password for hidden folders will be cleared from Picasa.

Wirelss connection Unavailable

If your Wireless Connection Icon shows "Unavailable" go the the network connections and disable the wireless connection and enable again.

This problem occurs because the media connect action is not sent to the Wireless service correctly. Resetting the device by disable-enable action fixes the problem.

How do you know diskspace used by tables in a SQL database?

Use the following stored procedure to view space used by every table:

exec sp_spaceused

Or you can use the undocumented foreachtable function in combination with that.


exec sp_MSforeachtable 'exec sp_spaceused ''?'';'

How to reclaim the diskspace from SQL log file (.LDF)?

To reclaim disk space from SQL log file

- Detach the database using Enterprise manager or Stored procedure.
- Delete the log file physically
- Attach the database using Enterprise Manager which will create a new log file for the database

Windows XP STOP Error 0x0000023

Recovery from this error is done with following process.

• Boot from Windows XP installer disk and choose Recovery console,
• login to Windows XP installation giving problem and
  
• Run 'Chkdsk' with '/r' option

0x23 error is because of FAT problems, checkdisk (chkdsk) recovers from problem.

Images not shown on MS Access form

Problem: Your MS Access form/report has a BoundObjectFrame control to display images but it is not showing images. It just shows a icon with image file name.

Solution:Install Microsoft PhotoEditor application from office CD. It is not availbale with office 2003, you have to install it from earlier versions like Office XP or Office 2000. It should solve your problem.
It is the problem with the association of image viewer application with image file types.

Processor zone temperature exceeds limit

If your system flashes the alert "Processor zone temperature exceeds limit", that is surely the problem with Heat Sync not in touch with the CPU properly. Get it cleaned and fixed properly, this should solve the problem.

Adjusting natural elevation appearance in Google Earth

While panning terrain on google earth one feels that earth looks very flat, and it doesn't give a real feel of the elevation of the region. To set it right get a natural elevation set the Elevation Exaggeration setting to 1.5. The value more than this and limited by 3, would make elevation to appear more pronounced.

To do this, click Tools > Options > 3D View from the Tools menu (for the Mac, choose Google Earth > Preferences > 3D View) and change the Elevation Exaggeration figure. You can set it to any value from 1 to 3, including decimal points.

Combo box on form from master table

While displaying a combo box on form from master table, it is necessary to bound primary key of master table to the control while display is mapped to description of the item. This is achieved using following properties

Data property Row Source : SQL string with necessary data elements,
Data property Bound Column : Number of return element in SQL string
Format Property Column Count : set it to number of columns returned in SQL string
Format Column Width : Set the width for display only column and rest as 0

Sleeping tips

From sleepybed.com

For some lucky individuals getting to sleep is taken for granted, you go to bed and go to sleep. Unfortunately getting to sleep is not so easy for many people. However, there are plenty of ways to hack your sleeping habits so that you can get a good night's sleep under your belt.

Simple things like developing a schedule, organizing your life and having a routine go a long way in terms of improving your quality of sleep. Listening to some soft background music, switching off the television and computer, turning off the lights and maybe even having a cup of herbal tea are all legitimate examples of ways to improve your pre-sleep ritual and sleep better.

Alter your lifestyle

It stands to reason that what you do during the day is going to affect your sleep, either positively or negatively. These tips are broad in nature, but they are intended to provide a structure on top of which you can hack and find the perfect balance for your sleeping pattern.

1. Schedule sleep
   Your body clock needs a routine, which takes discipline. Try to get to bed at the same time every day of the week, including weekends. If you have missed your set time for bed, don't try to make up for lost sleep by staying in bed for an extra hour in the morning as this can easily reset your body clock and make it hard to sleep.
2. Develop a bedtime routine
   A good bedtime ritual will prompt your body to slow down and prepare itself for sleep. If you are struggling to sleep now, then you are going to have to start hacking your routine into shape.
3. Get organized for tomorrow
   Are you going to a meeting early? Do you have to do a presentation or hand in an essay? Planning your day out helps to de-clutter your mind, and a clearer mind means you can get over to sleep much easier. So make sure you have your suitcase / briefcase and stuff ready for tomorrow.
4. Take time to relax
   Find a place in your home where you can relax and calm down. Use this time wisely and read a book, meditate or do some breathing exercises to prepare your body for sleep.
5. Clear out your thoughts
   If you are anxious about something your brain will trigger your adrenal glands, which will make you more alert. You can ease anxiety prior to sleep by simply talking to someone or writing down the problem and solution. Get it off your chest before you go to bed!

Adjusting work habits

In today's non-stop world it is possible to work whenever and wherever you want. You boss might love the fact that you are working from home at 10pm, but your body clock is going to be %$&@ed off Guaranteed!

6. Be good, work hard
   Work is draining, especially if you happen to be a bricklayer or writing reports for 8 hours a day. Work hard during work hours so that you are tired at night.
7. GTD
   Get things done. Becoming efficient at work means that you can stay on top of your workload and reduce stress.
8. Laptops can be evil
   If you weren't working hard during work hours then you are inevitably going to find yourself working after hours from home on your laptop, which means late nights and a non-existent pre-sleep routine.
9. Turn off mobile phone
   If someone wants to get in touch with you, they can do it during business hours. Keeping your phone (and / or pager) switched off means that work stays at work and you can unwind at home.
10. Don't discuss work at home
    Anyone who works alongside their partner will testify to how difficult it is to turn work off at home; however, it is something you need to do. Talking about work keeps your brain active and can increase anxiety, which is not conducive to sleeping well.

Creating the right atmosphere

Someone with problems getting enough sleep are obviously going to benefit from a relaxing atmosphere that encourages the body to relax. This can be done very effectively with very little capital investment.

11. Wear loose clothing
    When you come in from work, get changed into your casual clothes. Do not stay in your work suit, it'll remind you of work and you'll probably not be able to get comfortable in it anyway.
12. Clean up stuff
    If there are clothes lying on the floor, made a mess of the kitchen preparing dinner or the kids have trashed the living room then clean it up. Tidying up your home in the evening will stop you from thinking about it, which in turn will reduce the chances of getting over to sleep.
13. Turn down the lights
    Your body will respond to light levels, so lots of light keeps your brain active. Dim the main lights and use some ambient lighting to create a calm and serene atmosphere.
14. Play background music
    Obviously this is going to vary widly depending on your personal taste, but soft background music will help create a chilled out atmosphere. One great tip is to fire up iTunes and hit up one of the many streaming radio stations in the ambient music category.
15. Dump you bedroom television
    Late night television is typically very poor quality and isn't fit for consumption anyway. Some people can fall asleep with the television on, others can't. If you suspect it is adversely affecting your sleeping habits, then get rid of it.

Tweak your diet

There is a ton of scientific evidence that clearly shows that diet has a direct effect on sleep. Again, these are broad tips to help you establish a diet that aids sleep.

16. Avoid large meals
    Make sure you eat your dinner a few hours before you go to bed and try to avoid liquids. A large meal shortly before bedtime may cause indigestion while too many beers will have you running to the bathroom all night.
17. Snack on foods rich in tryptophan
    Tryptophan is an amino acid that assists the brain in the production of serotonin, which helps you calm down and relax. Foods rich in tryptophan include milk, eggs, chicken and turkey among others.
18. Avoid caffeinated products like the plague!
    You all know the score here. Caffeinated products such as coffee and tea are the antithesis of what you should consume before bed.
19. Set meal times
    Eating what you want when you want is very enticing, but it's a really bad plan if you want to establish a sleeping pattern. Changing your meals times from day to day messes up your body clock; therefore, take measures to ensure you eat your meals (especially dinner) at a certain time of the day. Then stick to it!
20. Avoid alcohol?
    Some people will have a very light sleep or no sleep at all after a few glasses of wine, others will become oblivious to all things conscious and experience the most tranquil night of deep sleep.

Get tired

For some strange reason we can find ourselves resisting the urge to lie down and sleep, it's probably come sort of a survival tactic. If daily life has been good enough to leave you with some energy, then try out these tips to get tired.

21. Start early
    If you get up earlier in the morning you'll have the benefit of a more productive morning as well as the knock-on impact of being tired later in the day, perfect conditions for a good night sleep.
22. Read a book
    It doesn't have to be very interesting, in fact, the more boring it is the better. There's nothing like trying to get through a few chapters of Ulysses to drain your will to live.
23. Exercise
    If you can, go to work on a bicycle or walk. If you can't, go for a walk after work or play some sport. Exercise will expend energy and stimulate the release of serotonin. The bottom line is that exercise helps sleep.
24. Spend time outdoors
    Weather permitting, spend some time outdoors. Fresh air contains more oxygen than polluted indoor air, which helps to invigorate you early in the day or compound tiredness later in the day. Going for a brisk walk at night will help you get tired.

Last, but certainly not least

25. Sleep when sleepy
    Who hasn't fought the urge to sleep to stay up late and watch late night television? It's a total waste of time, we know that, but it makes absolutely no sense. You aren't going to get anything from it except a messed up sleeping pattern. If you are tired, then go to bed!

JSP pages not refreshing after save

You have started JSP/J2EE development with installation of Tomcat. Everything looks fine, your code runs well, but all of a sudden you find that your JSP pages doesn't get refreshed as you save them after editing. This is quite frustrating, you search out on GOOGLE and don't find any thing good to solve your problem.

Try these simple tip below :

For development environment of Tomcat 5.5 set following parameters in web.xml file.

Development = true
modificationTestInterval = 0

Things should work for you.

Filtering special characters from FORM inputs

Filtering of special characters in FORM Submit is one of the problems faced by a novice programmer in J2EE/Java/JSP development. Best practice to avoid it and get the special characters filtered automatically is to use JDBC preparedStatements rather than Statements classes of JDBC.

Welcome to Solid Tips

To all the young players and seasoned pros, when in problem always look at this page to find tips.

Not just to get help, bu to help others by sending your own tips to published on this page.