good article

"In one of the meetings, he articulated beautifully the importance of maintaining proper work-life balance. He opined that simple attributes such as prior planning and prioritising could help achieve the right balance. In another, he talked about the importance of investing time and resources on research."



http://getahead.rediff.com/report/2010/jan/19/career-taking-meetings-with-narayana-murthy.htm

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

--Error code
DECLARE @dt VARCHAR(10)
SET @dt = '12012009'
SELECT CAST(@dt AS DATETIME)

--Working code
DECLARE @dt VARCHAR(10)
SET @dt = '20091201'
SELECT CAST(@dt AS DATETIME)

convert float to varchar nvarchar

When we import Excel data into SQL table it will create columns with 'Float' data type.
Here is the little trikey to convert float value to varchar/nvarchar


select top 1 convert(varchar,cast(floatNumber as decimal)) n from dbo.Mytable

hardest interview question job site

1 Hardest Job Interview Question

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=10692981&gid=40717&trk=EML_anet_qa_ttle-cDhOon0JumNFomgJt7dBpSBA

Top 100 Niche Job Sites
http://newgradlife.blogspot.com/2009/12/top-100-niche-job-sites.html

sql server with TB how to manage data

good article, worth to read when you have large amount of data (TB)

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=10740201&gid=59185&trk=EML_anet_qa_ttle-cDhOon0JumNFomgJt7dBpSBAjavascript:void(0)

Using Timer in Windows Services

http://www.developer.com/net/net/article.php/3335731/Using-Timers-in-a-Windows-Service.htm

Using Google Map API in your Web application

http://aspsnippets.com/post/2009/04/15/Using-Google-Maps-API-in-ASPNet.aspx