SQL Server Education (by the geeks, for the geeks)
In SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced to work with memory-optimized tables rather than working with disk based …
Read MoreHi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL Server 2016 CTP 2.0. This is a very useful feature for …
Read MoreHi friends, today we will learn another new feature Live Query Statistics which gets introduced in SQL Server 2016. It’s a common scenario in our day-to-day life that queries takes longer …
Read MoreIn release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking. Using Dynamic data masking we can provide the security to our restrictive data …
Read MoreHi friends, we will continue with FOR JSON clause in this blog and today we will learn formatting of query using FOR JSON clause mode with ROOT option in SQL Server …
Read MoreHi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016. As we seen in previous blogs that when we used FOR …
Read MoreIn previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we will learn formatting of query output using FOR JSON clause with …
Read MoreHi friends, in release of SQL Server 2016 CTP2 one of the feature that introduced is JSON clause. So first question that comes in everyone’s mind is What is JSON? JSON …
Read MoreHi friends, today we will discuss about new performance monitoring system Extended Events which gets introduced in version SQL Server 2012.In previous versions we were using SQL Trace for capturing events …
Read MoreHi friends, in this blog of SQL Server system stored procedure we will continue with another database mail stored procedure sysmail_help_principalprofile_sp. Sysmail_help_principalprofile_sp stored procedure list the information about associations between database …
Read More