Tuesday, February 27, 2007

Cyber Blood Banks

Last week, one of my friend’s friend met an accident and doctors told that he is in great need of AB- blood. Being one of the rare blood groups, hospital did not have this group to be able to exchange it with another group. My friend visited local college at the place but could not locate anyone with this blood group.

We knew quite a few sites which have contact details for a host of volunteer donors. We searched and found contact details for 2 people with same blood group. Very important and amazing was the response we got from each of them. It was really great and I still feel great when I think of it.

My friend tried calling first person. This guy was in Bangalore at that time so was not able to help us immediately but he was ready to fly to our place and donate blood as soon as he could. We told him to hold for some time just to try other person’s contact. Then we called second person, he was about 150 kms away from our place and told us like “I will be there as soon as I can”. After 5-10 minutes, we thought to give him a call just to reconfirm the time when he will reach us. Till the time we called him again, he was already on his way. He reached in approx 2.5 hours and donated blood

It was really good to know that even in today’s busy world there are at least some people who are eager to help just for the sake of humanity without any personal benefit.

Here is the list of some of the sites..

http://www.bharatbloodbank.com/

http://explore.oneindia.in/health/donors/blood/

http://www.indianblooddonors.com

http://www.lionsbloodline.com/

Tuesday, February 20, 2007

Tool to generate script with SQL 2005

Just wanted to share this tool to create script files for any DB changes for SQL 2005 as this feature no longer exist with new version. http://www.sqlteam.com/publish/scriptio/

Here is comprehesive description regarding the same from one of my friends.

From: Ravindra Bisht
Sent: Monday, February 19, 2007 3:38 PM
Subject: Tool to generate script withSQL 2005

Microsoft Sql Server management studio does provide a elaborate Script wizard for generating script but it has only following options

- Script to file (which is one huge file with everything)
- Script to Clipboard
- Script to New Query Window

However two important features from SQL 2000 are missing:

1) One object per file.
2) A script that performs both DROP and CREATE.

Though MSDN documents indicates that this is possible here http://msdn2.microsoft.com/en-us/library/ms191299.aspx

However, it doesn't give any clue on how to accomplish it. Quote from that page:
"The schema for generated objects can be saved in a single SQL Script file , or in several files with each file containing
the schema of just one object."

And these above two features can be accomplish by tool that can be installed from http://www.sqlteam.com/publish/scriptio/

However the extension for all those files is .sql which can easily be modified.

Regards
Ravindra Bisht

Wednesday, February 07, 2007

Yahoooo vs Gmail


Yahoo has finally done some really cool things with its email interface. Its all now using AJAX giving a very fast and rich interface. Sometimes, when my system is running under load, I feel yahoo working much faster than even MS Outlook which is a desktop application. Over that keyboard shortcuts have made life really easy. Gmail had done some marvelous things when it was launched. But now I can see Gmail way behind Yahoo Interface. And funny thing is …Gmail has also come up with keyboard shortcuts but their shortcuts are like

To Send Email –> Tab + Enter

This only works if your focus on the text area containing body of the composed email.

Because Tab shifts your focus to the next control (which is Send Button) and Enter clicks the button. So if someone types “To” address after keying in whole body then he will have to click on the text area to use shortcut for sending email.

Can someone call this a shortcut J