In this article, I will cover on distribution of SQL queries where each system manages a single copy of data, and uses distributed transaction mechanisms to access local and remote data.

There are two ways to assign a value to a local variable created previously: SET and SELECT. We can usually use SET and SELECT alternatively without any effect.

In this article you will learn about Common Table Expression (CTE) in SQL Server.

In this article you will learn about Normalization in SQL Server.

Here, we will take a look at how to use Ranking Functions in SQL Server 2012. Learn ROW_NUMBER, RANK, DENSE_RANK, NTILE.

In this article, I describe schemas in SQL Server 2012. A SQL schema is like a container that contains database objects like tables, views etc. So let us learn about schemas, creation of schemas, h...

In this article I’m going to start a series on topic called SQL Server Integration Services (SSIS).

In this article, we’ll discuss the deployment models available in SQL Server Integration Services (SSIS).

In this article, we are going to see how to use a For Loop container task in SSIS packaging.

This article familiarizes you with implementing column level encryption/decryption in SQL Server 2016.

In this article, I will discuss the difference between Stored Procedures and Functions and their usage.

In this article, you will see the SQL aggregate function count in two forms, Count All and Count Distinct.

In this article, you will learn about SQL Server 2008 End Of Support.

This is part 60 of the series of article on SSIS. In this article we are going to see how to use the OLE DB Command Task in SSIS packaging.

PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any ...

In this article, you will see how to create a duplicate table with a new name using a script in SQL Server.

Here, we will see how to change the password visually and programmatically in SQL Server 2012.

This article will give you an idea of how to add columns of two tables into one column and also defines how to handle a null value in SQL Server.

In this article, I would like to show how to get the name of all columns of a table in SQL Server.

In this article, I will explain SQL full outer join and SQL cross join in SQL Server.