Polybase SQL Server 2016

Introduction To Query Store In SQL Server 2016 – Part 2

Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...

Introduction To Query Store In SQL Server 2016 – Part 1

Hi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL...

Live Query Statistics In SQL Server 2016 CTP 2.0

Hi friends, today we will learn another new feature Live Query Statistics which gets introduced in SQL Server 2016. It’s...

Introduction To Dynamic Data Masking in SQL Server 2016

In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking.  Using Dynamic...

FOR JSON Clause Mode With ROOT Option In SQL Server 2016

Hi friends, we will continue with FOR JSON clause in this blog and today we will learn formatting of query...

FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016

Hi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016....

FOR JSON Clause With PATH Mode In SQL Server 2016

In previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we...

FOR JSON Clause With AUTO mode In SQL Server 2016

Hi friends, in release of SQL Server 2016 CTP2 one of the feature that introduced is JSON clause. So first...

SQL Server – Extended Events in SQL Server 2012

Hi friends, today we will discuss about new performance monitoring system Extended Events which gets introduced in version SQL Server...