Month: May 2016

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 …

GA Azure SQL Database elastic pools

Microsoft announced (General Availability) GA Azure SQL Database elastic pools on 12th May 2016. Azure SQL Database elastic pools are ideally suited for SaaS and line-of-business applications that need the performance, availability, and security isolation benefits of provisioning one database for each tenant or application. Each elastic database in the pool gets the resources it needs …

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 …

Compatibility level 130 for new Azure SQL databases

Microsoft announced new compatibility level 130 for new Azure SQL Databases on 10th May 2016. Azure SQL Database runs millions of databases under several different T-SQL versions, preserving backward compatibility for applications. SQL Database implements a versioning technique called “compatibility level.” The compatibility levels are: SQL Server 2008 and SQL Database v11: 100 SQL Server 2012: 110 SQL …

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 …