New Elements in HTML5

The internet has changed a lot since HTML 4.01 became a standard in 1999.
Today, some elements in HTML 4.01 are obsolete, never used, or not used the way they were intended to. These elements are removed or re-written in HTML5.
To better handle today's internet use, HTML5 includes new elements for better structure, better form handling, drawing, and for media content.

http://www.w3schools.com/html5/html5_new_elements.asp

Diffrence between Sql 2005 and 2008

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107186

Main Features provided in Sql 2008:
Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone
is used.
Table datatype introduced.
Can encrypt the entire database introduced in 2008.
Central Management Server(CMS) is Introduced.  

Diffrence between 3-Tier and mvc-vs-mvp-vs-mvvm

http://nirajrules.wordpress.com/2009/07/18/mvc-vs-mvp-vs-mvvm/

A fundamental rule in a three-tier architecture is the client tier never communicates directly with the data tier; in a three-tier model all communication must pass through the middleware tier. Conceptually the three-tier architecture is linear. However, the MVC architecture is triangular: the View sends updates to the Controller, the Controller updates the Model, and the View gets updated directly from the Model. 

Difference between Function and Stored procedure

The following are the differences between a User Defined Function and a Stored Procedure in SQL Server

1. Stored Procedure support deffered name resolution where as functions do not support deffered name resolution.
2. User Defined Function can be used in a select statement where as you cannot use a stored procedure in a select statement.
3. UDF’s cannot return Image, Text where as a StoredProcedure can return any datatype.
4. In general User Defined Functions are used for computations where as Stored Procedures are used for performing business logic.
5. UDF should return a value where as Stored Procedure need not.
6. User Defined Functions accept lesser number of input parameters than Stored Procedures. UDF can have upto 1023 input parameters where as a Stored Procedure can have upto 21000 input parameters.
7. You cannot use non-deterministic built-in functions in UDF’s. For example functions like GETDATE() etc can not be used in UDFs, but can be used in Stored Procedures.
8. Temporary Tables can not be used in a UDF where as a StoredProcedure can use Temporary Tables.
9. UDF can not Execute Dynamic SQL where as a Stored Procedure can execute Dynamic SQL.
10. User Defined Function does not support error handling where as Stored Procedure support error handling. RAISEERROR or @@ERROR are not allowed in UDFs.