Log in | Register

Security and Encryption Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Security and Encryption Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Security and Encryption


SQL Server 2016 – USE HINT without having SA permission

Hello Friends,

Trace Flags are really important considerations in SQL Server where we wants to change some default behavior at instance level or query level. If we want to enable the trace flag globally then we can enable it for the instance level. We can also use the trace flags at specific query level as […]

New Security Features In SQL SERVER 2016 – PART 1

Data Security in any application is vital. Different business or application  has their own security policy.  SQL Server 2016 provides three new security features which helps to protect data.

Below there are new security features added in SQL Server 2016.

Row-Level Security (RLS)
Dynamic Data Masking (DDM)
Always Encrypted

In this part of blog, we will see use case […]

SQL Server 2016 – Row Level Security

Dear Friends,

In conjunction to my previous blog, picked up another most awaited feature Row Level Security in short RLS. Current database world many RDBMS are emphasizing towards security as some or the other DB holding sensitive data. So far this kind of solution is available in SQL Server through T-SQL VIEWS/FUNCTION but restricting access […]

SQL Server 2016 – Always Encrypted

Dear Friends,

As SQL 2016 going to be launched very soon, I’m taking an opportunity to talk about interesting feature SQL Server 2016 – “Always Encrypted” & some of you would be looking for years (honestly speaking I was for sure).

Either its physical data security, logical data security OR fetching data by DBAs, developers and […]

ADMIN? – A Tale of Seven Wonders – Wonder 2

Hello Geeks,

Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]

SQL Server Security Audit – A (time consuming) task for DBA simplified

Many DBAs need to perform SQL Server security audit and save the permissions for each account at server level and database level. This will be done time to time and verified so that no elevated permissions are provided to any user than required. But to collect data of database roles and server roles of […]

SQL Server Using Powershell to Fix Orphan Users

One of the major migration activities is to fix orphan users.  Though, it can be easily fixed by sp_change_users_login procedure, however what if you need to do this for multiple servers. A powershell script comes in handy in this case.

Let’s start by creating a server and database object.

The next step is to iterate through […]

SQL Server Transparent Data Encryption

Transparent Data Encryption is introduced in SQL Server 2008. This feature has been introduced to provide more security to the data stored at the database level. It has the most valuable features which will help secure data by help of exploiting multiple CPUs and less increase in the disk space used to save encrypted […]

SQL Server 2012 User Defined Server Roles

Hi Friends,

Today, I want to focus on a very helpful feature SQL Server 2012 User Defined Server Roles (Denali).

In SQL Server 2005 and SQL Server 2008, there are only nine fixed server roles to grant the permissions. These nine fixed server roles are shown below in figure:

Now with SQL Server 2012 we can create […]