Dude … that sounds like a broad question, so apologize in advance. The word "audit" seems to have some depth in the DBA world, and I may not be asking the right question when I google.
I'm trying to figure out how to do it Easy "audit" in SQL Server. I have a subset of user tables for which I want to track changes (INSERTS, UPDATES and DELETES). I want to know who makes the change, when, and what the before and after results were (in the case of UPDATES).
I have done this in the past with triggers that would write to an "audit" table, and this provided me with a basic but intuitive way to quickly focus on any changes to the database. data.
For some licensing and support reasons, creating triggers to capture this information will not work in my current case. I am studying other options (SQL Server functionalities and commercial applications). I am running SQL Server on AWS RDS, and it looks like SQL Server auditing is supported. Is the release of SQL Server Audit suitable for quick and easy consumption? For example, can I easily query the ABC table, when / who / when was the last time a certain ROW was changed? Or is what I am describing more in line with a commercial product (like Apex SQL)?