Mladen Prajdić is a Data Platform MVP from Slovenia. He's been programming for 20 years, developing diﬀerent types of applications in .Net (C#), SQL Server and Swift, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He's a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
Getting To Know SQL Server Encryption Capabilities
With stricter EU privacy laws like GDPR, the need to encrypt data is greater than ever. In this session we'll look at what SQL Server offers in this area: 1) symmetric and asymmetric server encryption which lets the server encrypt table data and control the keys, 2) Always Encrypted (AE) which works similarly to server encryption but the client control the keys meaning server can't decrypt the data 3) Transparent Data Encryption (TDE) which encrypts your data at rest making getting data from stolen drives useless 4) creating secure SSL/TLS communication channels between your apps and the server to prevent clear text network traffic which can be observed