A big challenge with implementing security is just being able to keep track of the different tables and columns where the data is located. This features in SQL 2019 or SSMS specifically makes the task much easier. We cover how to automatically and manually classify sensitive information, we then explore how to audit SQL Server setup for security best practices. The tool allows DBA to quickly summarize important information like which tables contain information that needs to be secure and the type of data. The template can then be imported to other systems.
We then cover Vulnerability assessment which evaluates the SQL installation for Security Best practices and recommend remedies to address any potential flaws.
Want to know more SQL Server stuff? Need more information?
To know more about Jayanth Kurup visit http://www.jayanthkurup.com Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years’ experience. He has worked with companies like Microsoft, IBM, HCL , Wipro , WellFargo , Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community. In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc
You can reach Jayanth on https://in.linkedin.com/in/jayanth-kurup
Please consider subscribing !