Nipun Tomar's contributions

A database schema is a set of relation schemas. Changes to a schema or database schema are expensive. So, careful thought must be given to design of a database schema.

There sre several rules that must be applied naming the tables and Feilds also designing the database feilds.

The following are steps that are involved in a database design:

In SQL Server, by using UNION and UNION ALL we can combine multiple datasets into one comprehensive dataset.

Try the below sample code to load multiple “DataTable” objects in one “DataSet” object.

As Between both ADO and ADO.Net XML is the most important leap.

The data management provided by .Net are as follows:

Server.Transfer and Response.Redirect both are used to send the user from one page to another as both are the objects of ASP.Net.

The Configuration system first searches settings in (machine.config) file & then looks in application configuration files (web.config)

If your setup allows NetBIOS over TCP/IP, you have a security problem: Firstly, Your files can be shared all over the Internet And Secondly, Your logon-name, computer-name, and workgroup-name are visible to others.

HTML is a markup language used for displaying information, while XML markup is used for describing data of virtually any type.

A Query String is information sent to the server appended to the end of a page URL which means that Query String is way to transfer information from one page to another through the URL.

Frequently asked question in .Net Interview “What is the difference between Assembly and a Namespace?”

The System.Windows.Controls.SpellCheck class provides real-time spell-checking functionality for text-editing controls.

You receive the following error message when opening a TFS report: An error has occurred during report processing. (rsProcessingAborted)

Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change.

An error occurred when loading the Team System cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Team System.1428.cub.xml'.

Expression Blend 4 launched with new features that are very mush interesting and simpler to use.

DELETE Table is used to delete the rows from the table, TRUNCATE Table is used to delete the entire rows of the table

The Global.asax file is derived from the HttpApplication class, and it maintain a pool of HttpApplication objects.

UDDI stands for Universal Description, Discovery and Integration, WSDL stands for Web Service Description Language and DISCO is the abbreviated form of Discovery.

Boxing is a process in which object instances are created and copy values in to that instance, whereas Unboxing is vice versa of boxing operation