Wednesday, February 29, 2012

Mozilla Thunderbird - Share single email profile to multiple PCs

Hi everyone,

Today I faced a problem in my company. Due to some reason, I was shifted to another PC than my regualar PC. Rest all were going well, but I was faing problems regarding my POP email account configured in Mozilla Thunderbird at my regular PC. I was wondering how to get/check my emails from my original PC.

After a lot of surfing finally I got an amazing solution, which I would like to share with you all. Some how I managed to use the same Thunderbird profile on my original PC to another PC thru LAN.

Here are the steps:

Step-1] First of all on your original PC, goto Start -> Run -> "%appdata%\Thunderbird\Profiles\xxxxx.default", which is your profile created by your Thunderbird email client.

Step-2] Share the folder named "%appdata%\Thunderbird".

Step-3] On your another/remote PC goto "%appdata%\Thunderbird\".

Step-4] Open profiles.ini in Notepad.

Step-5] You will find a profile details as :

[Profile0]
Name=default
IsRelative=1
Path=Profiles/xxxxxx.default
Step-6] Now add one more profile details in same format as :

[Profile1]
Name=VHNG_Remote
IsRelative=0
Path=\\<shared profiles folder path on original PC>\xxxxx.default
Default=1
Note: 1] Make sure "IsRelative=0", as it indicates that the path is relative or not.
         2] "Default=1" makes this profile as default profile o load at Thunderbird Startup.


That's it.. Now open your Thunderbird and get your same profile back.. :-) :-)

Saves lot of time na, for import-export data???!!! ;-)

The same tweak you can use to move your profile from "C:\" to another drive for data safety while formaing PC.

Enjoy.... :-) :-) :-D :-D


Thanks,
Vihang Shah.

Step up to the Brainbench Certification challenge!

Step up to the Brainbench Certification challenge!: ALL Brainbench Certifications are free for a limited time for their Bench Games

Tuesday, February 28, 2012

SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function

Note: Tomorrow is February 29th. This blog post is dedicated to coming tomorrow – a special day :)

Q: How can I find leap year in using SQL Server 2012?

There are many functions written to figure out to figure out if any year is Leap Year or not. The same I have written using T-SQL function over here.

CREATE FUNCTION dbo.IsLeapYear (@year INT)RETURNS INT
AS
BEGIN
RETURN
(IIF(DATEPART(dd,(EOMONTH(CONCAT(@year,'0201')))) = 29,1,0
))ENDGO

 
You can validate above query by running following script.
SELECT dbo.IsLeapYear('2011') 'IsLeapYear';SELECT dbo.IsLeapYear('2012') 'IsLeapYear';GO

 
You will get result 1 if the year is leap year and 0 if year is not leap year.


Here is the article Pinal Dave has written which introduces all the new functions in SQL Server 2012 Summary of All the Analytic Functions – MSDN and SQLAuthority and 14 New Functions – A Quick Guide.

Find a cool free stuff everyday

Giveaway of the Day

Hiren Bharadwa's Posts

DotNetJalps