Who made that change? It is one of those questions that can send chills down the spine of those responsible for databases. In this episode, Josephine Bush talks with us about how we can use a combination of the native tools—auditing and extended events along with some custom reporting to be prepared for questions about change when more environments are subject to regulation.
What is great about the community is their willingness to share and Josephine comes through with a set of her own scripts. What I think is most helpful is the filtering included so you only need to capture the most pertinent changes. This helps you feel confident you capture the most important pieces without all the extra logging you have to muck through when you actually have a question to answer.
The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/03/30/episode-244-extended-events-vs-sql-server-audit. Have fun on the SQL Trail!