security Archives

Dynamic data masking is yet another feature of Microsoft to ease your life and provide you out of the box capabilities

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,

The first thing you must do after creating your Azure SQL Database is to configure Firewall rules. To help protect

Before we even start discussing about this feature we must have an idea about Azure Storage accounts and how the

Scenario: Auditors need a list of Users who have DBOwner Database role on any of the database which are hosted

Few months ago I started a series where I explained all about Execution Context & Context switching, you can use

In first part we discussed, what is Execution Context, different types of Tokens available and what all information goes into

Execution context is maintained by the login that is connected or executing the query, then it checks the permissions of

Principals are entities who can request access on SQL Server Resources on different levels, in other words the entities to

As discussed in earlier Login Impersonation Blog Technically SQL Server and windows both can be configured to authenticate to another