SQL Joins in SQL Server
SQL Joins in SQL Server

A SQL join is combines records from two or more tables in a relational database by using values common to each.

Pivot with Dynamic columns in SQL Server
Pivot with Dynamic columns in SQL Server

Pivot is one the new relational operator introduced in SQL Server 2005. It provides easy mechanisms in SQL Server to transform rows into columns.

Union Example in SQL Server
Union Example in SQL Server

In this article I am going to explain a use of union operator in SQL Server Database with a real life scenario and example.

Many-to-Many and One-to-Many relationship using EF Code First approach
Many-to-Many and One-to-Many relationship using EF Code First approach

In this article, I am going to demonstrate how to configure one-to-may and many-to-many relationship using Entity Framework code-first approach,