Database Tutorials

This SQL Server how to configure SQL Server to listen on a specific port.

When SQL Server 2005 or SQL Server 2008 Developer Edition, Express Edition, or Evaluation Edition is running on Windows XP Professional or Windows 7 and Developers want to connect to this instance from another computer, they must open a communication port [...]

This SQL Server how to enable TCP/IP connections from another computer.

If Developers plan to connect to the Database Engine from another computer, they have to enable a protocol, such as TCP/IP. In this case Developers should follow the next steps:

1. Start SQL Server Surface Area [...]

This SQL Server tutorial explains how to connect to the Database Engine.

Developers are already done steps described in the articles How to determine the name of the instance of the Database Engine and How to verify that Database Engine is running. Now they should follow the next steps:

1. On the [...]

This SQL Tutorial explains how to verify that Database Engine is running.

If developers know how to determine the name of the instance of the Database Engine they can follow the next steps:

1. In Registered Servers, if the name of their instance of SQL [...]

This SQL Tutorial explains how to determine the name of the instance of the Database Engine.

Developers should follow the next steps:

1. Log into Windows as a member of the Administrators group, and open either Management Studio or Management Studio Express Edition

This SQL Server tutorial explains how to show column names in the Diagram Pane in SQL server.

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to show column names, they should follow the next steps:

1. Right-click the table in the Diagram Pane of [...]

This SQL Server tutorial explains how to hide column names in the Diagram Pane in SQL server.

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to hide column names, they should follow the next steps:

1. Right-click the table [...]

This SQL Server tutorial explains how to use a User-Defined Function in Place of a Table in SQL server.

In Microsoft SQL Server 2000 or higher, developers can create a user-defined function that returns a table. Such functions are useful for performing complex or procedural logic. Developers can write a query that uses the fn_GetSomeData [...]

This SQL Server tutorial explains how to use a View in place of a Table in SQL server.

Developers can select rows from a View. For example, suppose the database includes a view called “LargeLCD,” in which each row describes a PC monitor which diagonal exceed 19 inches. The view definition might look like this:

SELECT [...]

This SQL Server tutorial explains how to use a Query in place of a Table in SQL Server.

Developers can select rows from a query. For example, suppose they have already written a query retrieving patents and identifiers of the coinventorred patents — the patents with more than one inventor. The SQL might look like [...]