embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Enterprise Row Level Security in SQL Server 2016 and Azure SQL DB


Jamey Johnston


The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/Azure SQL DB with predicate based RLS. This session will show how organizational & asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/Azure SQL Database without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations. Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS using Power BI as a test application.


Jamey Johnston is a Data Scientist for a large independent Oil and Gas company. He currently works on data gathering, cleansing and statistical/predictive modeling using SAS and R. For the past 20 years he has worked for Fortune 500 companies architecting successful database and BI systems and working on Predictive Analytics. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas A&M. He is active in his local SQL Pass chapter in Houston and speaking and volunteering at SQL Saturdays.

Recorded At:

San Antonio SQL Saturday 2016

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>