Free Visual Studio 2008 book

Free Visual Studio 2008 book
Download this free e-book offer. This includes sample chapters from Introducing Microsoft ASP.NET AJAX and Introducing Silverlight 1.0, as well as the entire contents of new publication Introducing Microsoft LINQ.

Microsoft DreamSpark :chase your dreams

Microsoft have its own way of selling his product as a freebies to various kinds of customers. They used to give the software product eval license etc during any Microsoft events. This is a kind of a good marketing strategy and some people named it as "Free Products from Microsoft". Now, if i say, that if you just need to prove yourself as a student by showing your IDs and you are eligible for getting various Microsoft professional-level developer and design tools like Visual Studio 2008 professional edition, Expression studio, windows Server 2003 and many more and at no charge. if you are one of those computer geeks that fall in this category then yes, Microsoft have came up with something called "Microsoft DreamSpark".
Unfortunately, it is presently running in 11 countries but soon more and more countries will chip in to this. for more information
click here

Remove NewLine characters from the data in SQL Server

I found that some string in the database have NewLine characters where they do not required.

To remove them in T-SQL I wrote the following SQL script (TODO: write re-usable SP, also special option to remove NewLine characters from the end of the string)

declare @NewLine char(2)
set @NewLine=char(13)+char(10)
update TableName
set ColumnName =Replace(ColumnName , @NewLine,'')
WHERE ColumnName like '%' +@NewLine +'%'

Note that even if WHERE condition may look redundant, it is important for performance. Without the (ColumnName like '%' +@NewLine +'%')condition all records will be updated,even if actual column value would not be changed.

To identify rows with newLine at the end the following condition can be used.

where ( RIGHT(ColumnName ,2)=@NewLine

Access Modifiers (C# Reference)

http://msdn2.microsoft.com/en-us/library/wxh6fsc7(VS.71).aspx
http://msdn2.microsoft.com/en-us/library/ba0a1yw2(VS.71).aspx