security Archives - SQLChamp

Azure Data Platform SQLAzure SQLServer SQLServer on Azure VM

Must know facts before configuring Dynamic Data Masking

May 13, 2016 Sarabpreet Singh Anand Azure SQL Database, DDM, Down level Client, Dynamic Data Masking, limitations, Must know facts before configuring Dynamic Data Masking, not supported, security, sql server, SQL Server 2016, SQLAzure, TDS 7.3 and below, UNMASK

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

Azure Data Platform SQLAzure SQLServer SQLServer on Azure VM

All about Dynamic Data Masking security

May 10, 2016 Sarabpreet Singh Anand All about Dynamic Data Masking security, Alter any mask, alter mask, DDM, Dynamic Data Masking, grant, loopholes, permissions, revoke, security, UNMASK

If you are not aware about Dynamic Data Masking, I would recommend you to first read Dynamic Data Masking Intro,

Azure Data Platform SQLAzure

Azure SQL Database firewall rule Deepdive–Part1

April 25, 2016 Sarabpreet Singh Anand 0.0.0.0, 1433, access, azure, common mistake, connect, Database, deepdive, firewall, firewall rule, gotchas, grant access, IP Address, pitfall, port, restrict access, security, Server, SQL, SQLAzure, TCP, troubleshoot

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

SQL Server data files on Azure | Configure Azure security

August 18, 2014 Sarabpreet Singh Anand Access Level, azure, azure storage, explorer, SAS, security, Shared Access Signature key, Shared Storage Key, SQL 2014, Storage Access Key, windows azure

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

Find Users with DBOwner Database role

October 17, 2013 Sarabpreet Singh Anand all databases, audit, DBOwner, script, security, SQL, sql server 2012, t-sql

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

SQL Tip-9 | Track the Original Login–even if the Execution Context is switched

September 4, 2013 Sarabpreet Singh Anand auditing, CURRENT_USER, Execution context, ORIGINAL_LOGIN, security, SESSION_USER, SQL

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

What do you mean by Execution Context & Context Switching? Part-2

April 8, 2013 Sarabpreet Singh Anand Context Switching, Execute As, Execution context, login token, security, sys.login_token, Sys.User_Token, token, user token

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

What do you mean by Execution Context & Context Switching? Part-1

April 4, 2013 Sarabpreet Singh Anand Context Switching, Execute As, Execution context, login token, security, sys.login_token, Sys.User_Token, token, user token

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

SQL for Beginners

What do you mean by Principals? (with respect to SQL Server)

March 20, 2013 Sarabpreet Singh Anand INFORMATION_SCHEMA, login, principal, security, SQL, SQLServer, user

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

Learn SQL Server User Impersonation

January 17, 2013 Sarabpreet Singh Anand 15517, check permission, Error, Execute As, grant, grant impersonate, granular permission, impersonation, learn, Msg 15517, security, server_principals, SQL, sys.database_principals, user

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

← Previous