Ta spletna stran hrani piškotke, da bi vam zagotovili boljšo uporabniško izkušnjo in popolno funkcionalnost te strani.

Analitične piškotke uporabljamo s storitvijo Google Analytics, samo z vašo privolitvijo. Sprejemam Zavrnitev Več informacij
Arhiv predavanj

New security features in SQL Server 2016

SQL Server 2016 has quite a few new features and in this session we'll take a look at how security has been improved. We'll look at three different features: Always Encrypted, Dynamic Data Masking and Row Level Security. Always Encrypted enables you to easily encrypt your data so that only the client can decrypt it, meaning the keys don't have to be stored on the server and even the DBA can't decrypt it. Dynamic Data Masking masks the sensitive data in the returning result set from users that don't have enough privileges to see it. This is not encryption, only simple rule-based masking. Row Level Security gives the server ability to limit the returned data to only the result set the application has the permissions to see, without needing to make hard-core modifications to the application code.

Mladen Prajdic

Mladen Prajdic s.p.

Mladen Prajdić is a Data Platform MVP and has been a C# and SQL Server developer for over 15 years developing business, image processing, mobile and data intensive realtime applications. He blogs at http://weblogs.sqlteam.com/mladenp and develops a popular add-in for SSMS called SSMS Tools Pack (http://www.ssmstoolspack.com).