Undo send in Gmail

March 26, 2009 at 7:35 am (Technical, Tips and Tricks) (, , )

Gmail has another feather in its cap. Gmail has introduced a new funtionality in web mail to undo send email. Eventhough, I have seen this in email client application, Gmail is the one having this functionality in web application. Its a great advantageous feature. Click here to know more in detail about the functionality.

Whats next??? Undo Past events in Life ๐Ÿ™‚

Permalink 4 Comments

CutomValidator to validate email address ignoring space at the end in .NET

March 19, 2009 at 8:13 am (.NET, ASP.NET, Technical) (, , )

We have compare validator in .NET to Compare the value entered by the user in an input control with the value entered in another input control, or with a constant value. Click here explore more on CompareValidator.

I had a unique requirement to validate the Email address in the two controls ignoring space at the end. I explored more and found a solution using the CustomValidator. Click here explore more on CustomValidator.

I have mentioned the code below

Added the following CustomValidator in the page:

<asp:CustomValidator ID=”CompareEmailAddress” runat=”Server” ClientValidationFunction=”CompareEmailAddress” ErrorMessage=”*” EnableClientScript = “true” ></asp:CustomValidator>

Read the rest of this entry »

Permalink 1 Comment

DateDiff function in SQL Server

March 17, 2009 at 3:13 pm (SQL, Technical, Tips and Tricks) (, )

I frequently used to calculate date difference between two dates. I use to open the calendar and calculate the difference. But now I have found a easier way to calculate the date difference using the SQL DateDiff function

DateDiff returns the number of date and time boundaries crossed between two dates.


DateDiff(datepart, startdate, enddate)

Read the rest of this entry »

Permalink 4 Comments

Importing/Exporting mails from Thunderbird to Windows Live Messenger

March 17, 2009 at 2:46 pm (Softwares, Technical, Tools) (, , , )

I used mozilla thunderbird for nearly a year now as my Email client. But after the release of Windows Live Messenger, I used both concurrently and finally settled for Windows Live Messenger. I had stored nearly thousands of mails using Thunderbird and was bit worried on importing the mails from Thunderbird to Windows Live Messenger. Finally, I googled and found few solutions.

First I tried the following solution prescribed here. I downloaded Thunderbird add-on from http://nic-nac-project.de/~kaosmos/mboximport-en.html and installed the add-on in Thinderbird. Then upon first try I found that I had to export all the folders one by one manually to eml format. I was bit tensed as I thought that the other solutions too could be quite similar.

Then I tried another solution mentioned here. It also mentioned about a add-on in Thunderbird namely SmartSave which can be used to export mails retaining the folder structure. It worked quite well for me. Please follow the instructions which is mentioned in the above link.

Permalink 1 Comment

KeyBoard shortcuts in Microsoft SQL Server

December 18, 2008 at 6:20 am (Technical, Tips and Tricks)

I was wondering for long days the keyboard shortcut for switching between Query and Result panes or windows, whatever you call them. Finally I moved a step forward to get the shortcut. Here is the shortcut to switch between Query and Result pane or window.

Switch between query and result panes -> F6

You can also find more keyboard shortcuts here.

Permalink 3 Comments

Manually register a dll in Windows

February 28, 2008 at 9:33 am (Technical, Tips and Tricks)

There will be a need to manually register a dll on few occasions. For example if you are generating a dll from a COMย  application, you need to register it before using it. To register the DLL in Windows, you need to run a command. Click start -> Run. Enter regsvr32 “pathdllname.dll”.

Where path = the path where the dll is located and dllname is the dllname.

For Example if a dll say example.dll is located in c:projects directory then run regsvr32 “c:projectsexample.dll”. This will register the dll. By register i mean a entry will be made in the operating system registry .

Permalink 15 Comments

WITH (NOLOCK) IN SQL Server to improve performance

February 27, 2008 at 8:57 am (SQL, Technical, Tips and Tricks)

I used to see my senior developers use WITH (NOLOCK) when querying in SQL Server and wonder why they use. Now i explored it and found that its useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is currently being updated in the Table ie Without lock protection, you cannot be guaranteed that the data isnโ€™t changing during the time that the query is running. I reffered this link and found it prettu useful.

Permalink 12 Comments

MCTS Exam 70-536 completion

February 20, 2008 at 6:28 am (.NET, Certification, MCTS, Technical)

Hurray!!! After a great preparation i finally completed the 70-536 exam. I got 2 weeks delay because of two reasons. One is that i had to recall all the concepts i learnt. And the other one i had a problem with booking. I booked to take exam on 17th of feburary(Sunday) through online and went to attend the exam. There i learnt that prometric is closed on sundays. Then why prometric make the slots available on sundays when booking through online … found a bug ๐Ÿ™‚ Finally i attened on 19th of feburary and cleared the Exam. Now i have to start planning for the second exam(Exam 70-528) after a weeks rest ๐Ÿ™‚

Permalink 4 Comments

Creating own run command in Windows

December 7, 2007 at 11:51 am (Technical, Tips and Tricks)

Many tech guys would be thinking of creating their own run command. Yes !!! we can create our own run command.

Step 1: Create the shortcut for the folder or tool for which you need to create the shortcut.

Step 2: Open the run command and goto \Windows

Step 3: Paste the shortcut to that folder and change the name of the shortcut to run command as we want.

Now we can open the folder or tool from run command using the name we have given for the shortcut.

Permalink 19 Comments