-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Kapil Blogs

Hi friends, I am Kapil Singh Kumawat and I am from Jaipur in Rajasthan, India. I have been working with SQL Server for the last four and a half years and am currently working with Cognizant Technology Solutions as an SQL Server Developer. I have experience in performance tuning, SSIS, data migration, database designing and writing queries. My other interests include travelling, watching football and listening to music.

Archives: July 2015

SQL Server 2016 Blogs

Hi friends, As you all know that SQL Server CTP2 has released with new great features. Here is the list of …

Continue reading Read more

1 comments, 567 reads

Posted in Kapil Blogs on 26 July 2015

Change in sys.dm_exec_query_stats in SQL Server 2016

Sys.dm_exec_query_stats is most commonly used DMO used by DBA and developers to find out the information about queries involving query …

Continue reading Read more

0 comments, 526 reads

Posted in Kapil Blogs on 25 July 2015

Changes in In-Memory OLTP in SQL Server 2016

In SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced …

Continue reading Read more

0 comments, 605 reads

Posted in Kapil Blogs on 23 July 2015

Introduction To Temporal Tables In SQL Server 2016

Hi friends, today I will get you introduced with another new feature of SQL Server 2016 i.e. Temporal Tables. SQL …

Continue reading Read more

0 comments, 2,894 reads

Posted in Kapil Blogs on 20 July 2015

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 …

Continue reading Read more

0 comments, 949 reads

Posted in Kapil Blogs on 17 July 2015

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 …

Continue reading Read more

0 comments, 604 reads

Posted in Kapil Blogs on 16 July 2015

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 …

Continue reading Read more

0 comments, 581 reads

Posted in Kapil Blogs on 14 July 2015

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 …

Continue reading Read more

0 comments, 483 reads

Posted in Kapil Blogs on 9 July 2015

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 …

Continue reading Read more

0 comments, 241 reads

Posted in Kapil Blogs on 6 July 2015

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. …

Continue reading Read more

0 comments, 246 reads

Posted in Kapil Blogs on 3 July 2015

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 …

Continue reading Read more

0 comments, 277 reads

Posted in Kapil Blogs on 2 July 2015