Pat is Technical Architect at R2C Group, an ad agency in Portland, Oregon that uses custom applications and a reasonably large SQL database to manage the business of buying and evaluating advertising performance. About a year ago they refactored their database and applications so that multiple companies can share the same data. After evaluating several strategies they went with Row Level Security which is available on MS-SQL 2016 This presentation will use the project as a case study. He’ll show us how they did it and what challenges they had. He will show actual code snippets and demonstrate the results.
Regular Session (60 minutes):