CMS(Content management system)

List of content management systems

http://en.wikipedia.org/wiki/List_of_content_management_systems

Beer House CMS

http://thebeerhouse.codeplex.com/releases/view/33900

Convert SQL Server 2008 to SQL Server 2005

1.)Convert SQL Server 2008 to SQL Server 2005

http://www.hyper-v-mart.com/HowTo/Convert_SQL_Server_2008_to_SQL_Server_2005.aspx


2.)With data:


1) Right click the database in sql 2008 which you want to do with
2) Choose Task and Generate script
3) Make sure select "script all objects in the database"
4) In the Script Option, choose the item Script for SQL server version to SQL2005
and Script data to be true! Those two are the key steps!
5) Here you go to check the generated script. You should find out insert statement for inserting the data


3.)Debugging Stored Procedures in Visual Studio 2005
http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

4.)Call Stored procedure from within another stored procedure, return values
http://www.aspfree.com/c/a/ASP.NET-Code/Call-Stored-procedure-from-within-another-stored-procedure-return-values/

5.) Differences between varchar and nvarchar in SQL Server

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1266201,00.html


6.) Calling functions in sql.
http://www.functionx.com/sqlserver/functions/create.htm

Shortcut keys

1.)Remote desktop connection::
click ’start’ -> ‘Run…’ -> type ‘mstsc‘ in and click OK-> then you have it –

2.)Asp.net::
http://nerdfortress.s3.amazonaws.com/visual-studio-2008-keyboard-shortcuts.html

godaddy

http://www.godaddy.com/

Multiple file upload like gmail with jquery

http://www.aspsnippets.com/Articles/Multiple-File-Uploads-Gmail-Style-using-JQuery-and-ASP.Net.aspx

MVC(Model–view–controller)

http://www.asp.net/(S(d35rmemuuono1wvm1gsp2n45))/mvc/

Ports

http://www.iana.org/assignments/port-numbers