2017-10: Encryption in SQL Server (Basel)

Encryption in SQL Server Michał Sadowski

An application that you administer stores sensitive data in the database and you would like to keep them safe in Microsoft SQL Server - how do you approach this issue?

What type of encryption should you use in your environment?

In this session we will walk through available options in Microsoft SQL Server and show when to use encryption, how to identify threats and countermeasures by using options like Transparent Data Encryption, SSL certificates, Always Encrypted, etc.

After this session, you will know a set of best practices that you can apply in your environment.

Agenda

15:45 - 16:00 : Arrival and Registration
16:00 - 17:15 : SQL Server for Windows Administrators - tweaks
17:15 - 17:30 : Coffee Break
17:30 - 18:45 : Encryption in SQL Server
18:45 - 19:15 : Q&A and Quiz