Here is another popular lab from Hands-On-Lab library: Auditing in SQL Server
SQL Server auditing allows users to audit everything that happens to the server, from the server, setting changes to who modified a value in a specific table in the database. This information is then written to the Windows security log, the Windows application log or to a flat file. SQL Server audit lets us create server audits, which can contain server audit specifications for server level events and database audit specifications for database level events. The first exercise is explaining about how to configure the audits. The second exercise is explaining about how to audit SQL server using policy based management. The third exercise is explaining about importing and exporting audits as policies and conditions.
Exercise 1: Configuring Audits
Exercise 2: Auditing in SQL Server using Policy-based management
Exercise 3: Importing and Exporting the Audits as Policies and Conditions
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.
Happy Learning – The Practical Way.