Back To Schedule
Wednesday, October 3 • 11:30 - 12:30
New SQL Server 2016 Security Features for Developers

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
With the release of SQL Server 2016, the database engine has been greatly enhanced for security, with three new features that you’ll learn about in this demo-packed session. With dynamic data masking (DDM), you can fully or partially conceal sensitive columns from query results. Masking does not modify data on in the table, it simply hides data from users that don’t have permission to see it. Row-level security (RLS) also hides data from unauthorized users, but at the row level. With RLS, you can create your own security policy to control which users can read or write specific rows in the table. Finally, Always Encrypted (AE) uses client-side encryption to ensure that data is encrypted in flight, not just at rest. Furthermore, the encryption keys are accessible only to the client. This guarantees that data cannot be decrypted on the server, easing the migration path to the cloud for users with highly sensitive data.

avatar for Leonard Lobel

Leonard Lobel

CTO, Sleek Technologies, Inc.
Leonard Lobel (Microsoft MVP, Data Platform) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National... Read More →

Wednesday October 3, 2018 11:30 - 12:30 CEST
Room 5