This article explains the OUTPUT keyword including the basic advantages of it.

Microsoft has introduced some significant enhancements for SQL Server 2014, especially with In-Memory OLTP. Here are 10 new features in SQL Server 2014.

How to sort numbers in SQL Server. It's not a difficult task but not an easy way. In the front end are many functions that for sorting values but SQL Server has no predefined function available.

In this article you will learn how to configure the SQL 2012 Reports Services Server.

This article explains how to create a new SQL Server job, how to schedule a job and how to set an alert for a job.

In this article I explain how to configure and send mail from SQL Server.

This article provides some basics of SQL Server Integration Services.

Here you will see how to create a database when the MDF is compressed.

In this article you will learn how to write a Stored Procedure in SQL Server.

In this article we learn about joins in SQL Server.

This article explains the main differences among SQL Server 2000, 2005 and 2008.

In this article we learn how and why we use the stuff, replace and Substring functions in SQL Server.

In this article we will study how to automate a databases release to SQL Server using the Microsoft Release Management tool and Data-tier applications in Visual Studio.

In this article you will learn how to use a builtin Template in SQL Server

This article describes how to get column values in one comma separated value in SQL Server.

This article gives you an overview of working with XML in SQL Server.

This article gives you an overview of working with XML in SQL Server.

This article explains the System databases in SQL Server 2012.

This article explains the over clause in SQL Server.

This article describes the Coalesce Function in SQL Server 2008.