I want to discuss today a new feature, Always Encrypted, that was highlighted in the SQL Server 2016.

This article describes SQL data types and operators.

Here you will learn how to create a database in SQL Server 2008.

In this article, we will go through the uses of CTRL + R Key in SQL Server. Here, we will also look at the solutions for when a key stops working in SQL Server.

This article explains how to create a database trigger.

In this article you will learn how to generate scripts of our database.

In this article we will learn about the CONCAT function and NULL values in SQL Server 2012.

In this article we’ll discuss the concept of pages in SQL Server and we’ll also check how data is stored in data pages.

In this article we'll learn how SQL allocates and manages space when storing records in data pages.

In this article we will look at views in the Structured Query Language (SQL).

This article provides some SQL Query Optimization Techniques.

Here I am explaining how to change an existing collation of a database in SQL.

This article explains how to create Memory-Optimized tables and what I have initiated using this new type of table.

This article explains temporary tables with examples in SQL Server.

This article explains Temporary and Transaction tables in SQL Server.

In this article you will learn how to deal with timezones in SSRS Reports.

This article explains the differences between Clustered Tables and Heap Tables in SQL Server.

This article explains the OFFSET-FETCH clause that is a filltering option, like top, that can filter the data based on the number of rows.

This article shows how to search data in a GridView using SQL Server without writing code.

This article explains the Merge statement in SQL Server. With the Merge statement we can merge the data from a source table into a target table.