The goal of the DBA Virtual Chapter is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.
Next Meeting

Wed, Jan 25 2017 12:00 (UTC-05:00) Eastern Time (US & Canada)

Implementing (and cracking) new Security Features in SQL Server 2016, Part 1


Implementing (and cracking) new Security Features in SQL Server 2016, Part 1 – sponsored by Hewlett Packard Enterprise

SQL Server 2016 provides several new data security features like Always Encrypted, Dynamic Data Masking and Row-Level Security. These new features are 'game changer' to developers, DBAs, and above all to architects that need to design applications and Data platforms. These features increase the security and reduce the development time significantly. Features that usually implemented in the application side, now can be implemented in the server side, while encryption keys, which are usually stored in the server side, can be stored in the client side. The lecture will be held in two parts. In part one, we will explore the implementation of Dynamic Data Masking in the server side, using the new built-in feature in SQL Server 2016 and in older versions. We will discuss the benefits and limitations, and we will show some simple tricks to crack (bypass) the new feature and expose the masked data.

Ronen Ariely is a senior consultant, an applications & data architect. He has more than 15 years' experience in variety programming languages and technologies, leading development teams, and software companies, SQL & BI enterprise level solutions. Ronen is active in communities (aka pituach) in the field of Programming, SQL Server, and T-SQL. He serves as Moderator at MSDN and as one of the Microsoft TechNet WIKI communities' leaders. Ronen writes technical blogs, TechNet articles and blogs, and has been awarded as a Microsoft Most Valuable Professional.

Future Meetings

February 8 Noon Mountain

February 22 Noon Eastern



The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line.

Interested in Presenting to the DBA VC?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley,