Uncategorized

SQL SERVER – Random function in Dynamic Data Masking in SQL Server 2016 CTP 3

Hi friends, With new CTP version of SQL Server 2016 many new functionality are added and modified. As with introduction SQL 2016 new functionality Dynamic data masking get introduced which helps in protecting the confidential data from users who do not have access to view it. In earlier CTP version data masking were of three… Continue reading SQL SERVER – Random function in Dynamic Data Masking in SQL Server 2016 CTP 3

Development · Uncategorized

SQL Server – DROP IF EXISTS in SQL Server 2016

Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets introduced which can be used with the existing DROP statement. Previously, within IF clause we were checking whether the object is exist or not. Here is the syntax that we were using in previous versions… Continue reading SQL Server – DROP IF EXISTS in SQL Server 2016

Performance Tuning · Uncategorized

How Client Statistics helps in improving performance in SQL Server

Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received from server to the client side. In other words, client statistics helps in analyzing the traffics load like packets/bytes sent and received at client – server side. When we run a script or query in… Continue reading How Client Statistics helps in improving performance in SQL Server

Uncategorized

Sysmail_configure_sp – SQL Server Database Mail Stored Procedure – Part 1

Hi friends, from today we will discuss about database mail stored procedures. In next few days you will learn how to configure database mail, how to add mail accounts, how to add profile, and how to send mail. Today, we will discuss about configuration setting for database mail using stored procedure sysmail_configure_sp. Sysmail_configuration_sp stored procedure… Continue reading Sysmail_configure_sp – SQL Server Database Mail Stored Procedure – Part 1