Blogs/Websites to Follow - ASP.NET

This is part of the new series I have started on my blog where I will list out some useful blogs or websites to follow for all ASP.NET people...Not in any order just randomly...
The names have been linked to their Twitter profile so anybody can follow them if they like.

1. Scott Gutherie - Corporate Vice President, .NET Developer Platform, Microsoft - http://weblogs.asp.net/scottgu/
2. Scott Hanselman - Principal Program Manager, Microsoft - http://www.hanselman.com/blog/
3. Scott Mitchell - Founder, 4GuysFromRolla.com - http://scottonwriting.net/sowBlog/
4. Steve C. Orr - Microsoft MVP in ASP.NET - http://steveorr.net/Default.aspx
5. Nikhil Kothari - Software Architect, .NET Developer Platform, Microsoft - http://www.nikhilk.net/
6. Joe Stagner - Senior Program Manage,  Microsoft Corporation’s Developer Tools and Platform Group - http://misfitgeek.com
7. Rick Strahl - Founder, WestWind.com - http://www.west-wind.com/weblog/
8. Scott Allen - Founder and Principal Consultant with OdeToCode LLC - http://odetocode.com/blogs/scott/
9. Phil Haack - Principal Program Manager, Microsoft - http://haacked.com/
10. Jeff Atwood - StackOverflow - http://www.codinghorror.com/blog/
11. S. Somasegar, Senior Vice President, Microsoft Developer Division - http://blogs.msdn.com/b/somasegar/
12. Harish Ranganathan - Developer Evangelist, Microsoft India - http://geekswithblogs.net/ranganh/Default.aspx 
13. Mike Brind - Microsoft MVP - http://www.mikesdotnetting.com/
14. Imar Spaanjaars - Microsoft MVP, Founder - http://imar.spaanjaars.com/
15. Maarten Balliauw - .NET Technical Consultant at RealDolmen - http://blog.maartenballiauw.be/
16. Kazi Manzur Rashid - ASP.NET MVP & Co-Founder, dotnetshoutout.com - http://weblogs.asp.net/rashid/
17. Elijah Manor - ASP.NET MVP, ASPInsiders - http://elijahmanor.com/webdevdotnet/

I will keep on adding new sites to this list.

If anyone of you like to share a ste then feel free to post it as comment will add to the list.
  

New Thing A Day Series - Day 2

From today, I have started this new series of posting about a new thing that I have learnt everyday.
So guys keep watching for new things everyday....

(1.) OUTER APPLY & EXCEPT in SQL 2005 + - 1st June 2010

Today I have learned about the OUTER APPLY & EXCEPT keywords that have been added in SQL SERVER 2005 & later editions, whic is useful to return data from one table which is not in another table.

Lets see an example.

CREATE TABLE testnulls (ID INT)

INSERT INTO testnulls VALUES (1)

INSERT INTO testnulls VALUES (2)

INSERT INTO testnulls VALUES (null)

CREATE TABLE testjoin (ID INT)

INSERT INTO testjoin VALUES (1)

INSERT INTO testjoin VALUES (3)

OUTER APPLY:  is something that got added to SQL 2005

SELECT j.*

   FROM testjoin j

   OUTER APPLY (

      SELECT id

      FROM testnulls n

      WHERE n.ID = j.ID

   ) a

WHERE a.ID IS NULL

EXCEPT: was added in SQL 2005. It returns everything from the top table which is not in the bottom table. 

SELECT * FROM testjoin

EXCEPT

SELECT * FROM testnulls

Feel free to post ur comments..

(2.) How to make ur ASP.NET/HTML Websites Indic Aware - 2nd June 2010

I knew ASP.NET provides Localization support which means we can change the language of the website, but I didnt know that we can even now accept input in Indic languages like Gujarati, Tamil, Telugu, Hindi, etc, until I came to know about it through one of the Microsoft guys - http://geekswithblogs.net/ranganh/archive/2010/03/15/making-your-asp.nethtml-websites-indic-aware-ndash-accepting-tamil-telugu.aspx 

Microsoft have released the scripts so that the Indic input feature can be encapsulated into your own websites.  For example, if you are having a web page where you collect user information, you can pretty much make your site indic aware i.e. accept inputs in Gujarati, Tamil, Telugu, Kannada, Hindi etc.,  All you would need to include would be a bunch of scripts onto your web pages and you are ready to make it, like I said, “indic aware”.

NOTE: This is not translation but transliteration where as the users type in English and use one of the delimiters (space etc.,) the word converts into the Indic language word.  So, if you type Gujarati, it converts to ગુજરાતી 

You can get the scripts released by Microsoft for adding the Indic Language feature from this link : http://specials.msn.co.in/ilit/Gujarati.aspx

I myself tried it by making a small webpage that accepts FirstName, LastName, Address & an additional field. I have set to accept Gujarati as input, you can select the language of ur choice.

Except the additional field which I have set to accept English, rest will accept Gujarati. 

The code for it as follows: 

I have taken a screenshot as well so all can see how it works.

So now you can now add the Web Version of Microsoft Indic Language Input Tool (ILIT) to your website so that your visitors can easily enter Indic language text on the site. This facilitates easy search, form-filling and discussions in any Indic language on your site by anyone who visits it.

Currently the languages supported are : Bengali, Gujarati, Hindi, Kannada, Malayalam, Marathi, Oriya, Punjabi, Tamil & Telugu.

This service is provided free for non-commercial use only.

So go ahead & use it in your websites & tell me the feedback..

Useful (Difficult) SQL Scripts

Here you will find a library of some very useful & difficult SQL scripts.

1. http://stackoverflow.com/questions/197369/library-of-useful-difficult-sql-scripts
This a StackOverFlow article which has some of the best links.  A must visit for all SQL guys...

http://wiki.lessthandot.com/index.php/Category:Microsoft_SQL_Server - This is by far the best site I have found for SQL Server scripts.
2. http://wiki.lessthandot.com/index.php/SQL_Server_Programming_Hacks_-_100%2B_List
3. http://wiki.lessthandot.com/index.php/SQL_Server_Admin_Hacks
4. http://vyaskn.tripod.com/code.htm
5. http://www.nigelrivett.net/
6. http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=27
7. http://stackoverflow.com/questions/197111/fastest-get-duplicates-sql-script 
8. http://bit.ly/aHoHxD - Joe Celko's SQL puzzles & answers ebook


I will keep on adding links to this list & if anyone of you have some useful links then feel free to share it here by adding comments, you can even ask any Q's regarding SQL here.

So keep scripting....