This article discusses basics of stored procedures and how to create, update, and delete stored procedures in a database.

This article is intended to cover one of the most critical responsibilities of database administrators in order to maintain data integrity.

In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to un...

Here I will discus in the easiest way to connect your asp.net web application with MYSQL Server and also how you can migrate from Microsoft SQL to MYSQL.

SQL wildcards are used for searching data’s in a database, which were used with LIKE operator.

Here are some of the new features added to SQL Server 2008.

This Article shows How to Enable/Disable sa Account in SQL Server.

This article explains about doing bulk DML on SQL Server 2005 using XML datatype

This Article Shows How to Use SQL Server to Export Data from SQL Server to Excel Sheets and Viceversa.

In this article we will look how we can do database operations using SilverLight. We will first try to understand why we cannot call ADO.NET directly from a silverlight application and then we will...

This article demonstrates how to use Table variables in SQL Server instead of temporary tables.

Learn how to work with logins in SQL Server programmatically and via SQL Server Management Studio.

In this article I will explain all steps needed to load tcp dump file into SQL Server 2005.

Process Class Provides access to local and remote processes and enables you to start and stop local system processes.

In this article I will explain the detailed steps to add the product to the user's basket or basket of the anonymous user.

This article lists some of the optimization tips for SQL Server development.

This article will show steps for using report service and Server Business Intelligence Development.

Let's see how we can publish our database in SQL Server.

In this article we will see how to read log file in SQL Server and extract information from it.

In this article you will learn how to Remove duplicate records in SQL Server 2005.