Next Meeting: Thu, Aug 10 2017

Richmond - August Meeting 2017

RSVPURL: http://rva.pass.org/Home/tabid/13075/ctl/Details/Mid/23907/ItemID/952/Default.aspx

August monthly meeting.

When

iCal
UTC : Thu, Aug 10 2017 22:30 - 00:00
Event Time : Thu, Aug 10 2017 18:30 - 20:00 Eastern Daylight Time
Your Local Time: Thu, Aug 10 2017 22:30 - 00:00

Where

4600 Cox Road
Glen Allen, Virginia

Direction: None

Featured Presentation

Implementing Row Level Security

Speaker: Louis Davidson, Data Architect drsql.org

Summary: Since the early days of SQL Server, it has been possible to use basic security measures to allow (and disallow) user access to any object in a database, and even limit access to a given column. A more difficult task has been to limit access to the individual rows in a table. This has made application development more complex because whereas most every user may have access to a table like HR.Employee, not every employee will have access to every employee’s data. In this session I will cover several techniques to limit access to rows, from methods that have existed since early versions of SQL Server, to the new Row Level Security feature in SQL Server 2016.

About Louis: Louis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 10 years and has written five books on database design. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Attachments