In this article I will be covering the most commonly used new functions in SQL Server 2012.

Entity Framework 5 has been released with .Net framework 4.5 and it now supports user-defined table valued types as a parameter in a Stored Procedure.

SQL Server 2012 introduced the four new conversion functions: TRY_CAST, TRY_CONVERT, PARSE and TRY_PARSE.

This article defines how to use SQL Server built-in functions.

SQL Server 2012 introduces two new logical functions: CHOOSE and IIF.

This article describes the most important Interview question for every DBA.

This article explains 7 new date functions in SQL Server 2012..

SQL Server 2012 introduced two new string functions: Concat and Format.

In this article I am trying to explain the alternatives for Cursors. We shall use a Cursor when there is no other option than Cursor.

This article explains Dynamic Management Views (DMVs) in SQL Server 2008 R2. This provides the current information about the procedures of the service and the server health.

Let’s see how to attach a database or multiple databases in SQL Server.

The purpose of the above mention topic is to keep the track of user activities in the Database Managements System.

This article explains how to install and use SQL Server 2014 step-by-step.

This article explains how to work with In-Memory OLTP in SQL Server 2014.

In this article I explain new dynamic management views and functions in sql server 2014.

This article defines how to insert, update and delete records in a database table using the merge statement in SQL Server.

In this article i am sharing some sql queries that need to maintaining data in sql server for every developer.

This article explains another new feature, support of Non-Unique Clustered and Non-Clustered Indexes for Table Variables, introduced in SQL Server 2014.

This article explains how to optimize temp table caching in SQL Server 2014.

Today I discuss the new features Change Data Capture in SQL Server 2008.