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 – 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 […]