SQLAzure

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 …

RLS (Row Level Security) basics

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 …

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 …

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 …