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.
Read the show notes and listen to this podcast episode here:
https://sqldatapartners.com/audit
Show your love for the SQL Data Partners Podcast with your own t-shirt!
https://sqldatapartners.com/tshirt
Support the podcast: https://streamlabs.com/sqldatapartners
Follow us on social media:
Twitter: @sqldatapartners
LinkedIn: SQL Data Partners, LLC
Facebook: SQL Data Partners
Instagram: sqldatapartners
Subscribe on Twitch:
/ sqldatapartners