SQL Server includes multiple features that focus on data security, privacy and developer productivity. In this session we will review the best features from a database designer's and developer's point of view.

We'll look at new features, why you should consider them, where they work, where they don't, who needs to be involved in using them, and what changes, if any, need to be made to applications or tools that you use with SQL Server.

This session will cover

• The pros and cons of implementing each feature
• How implementing these new features may impact existing applications
• 10 tips for enhancing SQL Server security and privacy protections

You will learn:

• Understand new features in SQL Server and Azure SQL DB
• Understand how and when to use these new features
• Understand modern database design approaches