Tag: sql server blogs

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 …

Changes in In-Memory OLTP in SQL Server 2016 Read More

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

Introduction To Dynamic Data Masking In SQL Server 2016 Read More

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

FOR JSON Clause Mode With ROOT Option In SQL Server 2016 Read More

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

FOR JSON Clause With PATH Mode In SQL Server 2016 Read More

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

FOR JSON Clause With AUTO mode In SQL Server 2016 Read More

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

Sysmail_help_principalprofile_sp – Day 19 – SQL Server System Stored Procedure Read More

Hi friends, in this blog of SQL Server system stored procedure series we will continue with another database mail procedure sysmail_add_principalprofile_sp. Sysmail_add_principalprofile_sp stored procedure grants permission to a database user or …

Sysmail_add_principalprofile_sp – Day 18 – SQL Server System Stored Procedure Read More