Have you ever needed to figure out who made a change or when a change was made? Or do you have requirements to log certain activities for compliance purposes?
SQL Server has a range of tools to help you accomplish that. This presentation will show you how to use those tools, including Profiler/trace, the default trace, built in audit, the transaction log and DDL triggers, along with at least one interesting use case for each of them.
At the end of this presentation you will have a good understanding of your options and when to use each of them.
Andy Warren is a SQL Server consultant based in Orlando. A founding member of SQLServerCentral.com, President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.
To access materials please fill out the form below.