Description

SQL Server 2016 Advanced Security and Administration Video by Steve Jones

SQL Server 2016 Advanced Security and Administration Video by Steve Jones
MP4 | Video: AVC 1280×720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours 14M | 519 MB
Genre: eLearning | Language: English
SQL Server is a complex and feature rich platform that can requires knowledge and practice to extract optimum performance from an instance. This course will assist a database administrator in understanding the advanced security features that protect data within databases. You will also gain an advanced understanding in how to examine the activity on your system and better tune the database code to run efficiently.

SQL Server is a complex and feature

rich platform that can requires knowledge and practice to extract optimum performance from an instance. This course will assist a database administrator in understanding the advanced security features that protect data within databases. You will also gain an advanced understanding in how to examine the activity on your system and better tune the database code to run efficiently.

In SQL Server 2016 Advanced Security

and Administration, we go beyond the basics of managing and securing a SQL Server instance.

This course will look at the complex world of encryption and how you can enable

this to protect data at rest as well as inside the database. Learn about Always Encrypted,

where the data is always protected outside of the client system. The course will show how Dynamic

Data Masking and Row-Level Security can be used to ensure that your clients only

view the data they should be allowed to view. Since performance is

important to all clients, the course covers the ways in which an administrator can determine

what activity is taking place on a database through Extended Event

s and how to analyse and improve performance of queries using execution plans and the Query Store.

In the end you will learn how to ensure predictable performance by analysing

activity to find any performance problem, use detailed execution

plans to tune query code, and use Query Store to prevent plan regressions.

About the Author

Steve Jones has been working with SQL Server since 1991.

He has worked with all versions of SQL Server as a developer and DBA, in a variety of industries and companies.