Jun 022016
 Posted on: June 2, 2016  Posted by  No Responses »
AT Time Zone – Convert timezone directly using SQL

Globalization brings new opportunities and enhance economic growth to any business, but along with all the goodness it also brings complexity to manage different time zones. One has to be always on toes to match different times. but what if you’ve got an application\code where you have to convert timezone within SQL Server data? If [Read More]

May 272016
 Posted on: May 27, 2016  Posted by  No Responses »

RLS (Row Level Security) is a brand new feature which has been introduced in Azure, SQL Databases (v12) and SQL Server 2016. This feature provides you access control on rows of tables for users\logins querying the data. Basically, it filters the rows based on certain characteristics of Users\Logins. After getting this feature it becomes very [Read More]

May 132016
 Posted on: May 13, 2016  Posted by  No Responses »
Must know facts before configuring Dynamic Data Masking

Dynamic data masking is yet another feature of Microsoft to ease your life and provide you out of the box capabilities which decrease the overall time to market for your applications. You don’t have to code the way you had to do it earlier to achieve it. But there are things you must know before configuring [Read More]

May 102016
 Posted on: May 10, 2016  Posted by  No Responses »
All about Dynamic Data Masking security

If you are not aware about Dynamic Data Masking, I would recommend you to first read Dynamic Data Masking Intro, How to configure Dynamic Data Masking using Azure SQL Database portal or Using T-SQL. Reading these links will help you understand this feature better. let’s see All about Dynamic Data Masking security.   All about Dynamic [Read More]

May 062016
 Posted on: May 6, 2016  Posted by  No Responses »
Right Azure storage replication for SQL Data Log file

As we know starting SQL Server 2014 we can easily place our SQL Data and log files in Azure, it is indispensable to choose Right Azure storage replication for SQL Data & Log file – to know more click here to know about the feature to place SQL Data & Log Files on Azure, click here [Read More]

May 032016
 Posted on: May 3, 2016  Posted by  No Responses »
Configure Dynamic Data Masking using T-SQL

In last few blogs about Dynamic Data Masking we got the basic understanding of the topic & how to configure Dynamic Data Masking using Azure SQL Database portal. In this blog we’ll configure Dynamic Data Masking using T-SQL Scripts on Azure SQL Database. Before we begin anything you must get some basic idea about the [Read More]

Apr 152016
 Posted on: April 15, 2016  Posted by  No Responses »

Dynamic Data Masking is a great new feature introduced in Azure SQL Database and SQL Server 2016 to mask the data in selected columns containing sensitive data with minimum impact to the application. The beauty of the feature is, it masks sensitive data in the result set while the data remains same (unchanged) in the [Read More]

Apr 042016
 Posted on: April 4, 2016  Posted by  4 Responses »

If you want to use SQL Database in Azure you get two options: either deploy it on SQLAzure or SQL Server running in Azure VM, both options provide SQL Database however, there is a lot of difference in feature set, compatibility, manageability & behavior of both. Let’s take a look at some basic difference between [Read More]

error: Content is protected !!