Tag Archives: Auditing
-
Creating a Database Audit Specification can create new users & schemas in the background
2June 28, 2022 by Kenneth Fisher
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on …
Continue reading -
An auditing mind set
2May 31, 2022 by Kenneth Fisher
I little while back I presented at Pass Data Community Summit. Specifically the presentation was Auditing your data and data …
Continue reading -
Quiz & answers for my “Auditing your data and data access” session.
1November 16, 2021 by Kenneth Fisher
I was honored to speak at Pass Summit last week (Thanks again Redgate), and if you’ve ever been to one …
Continue reading -
Audit Columns
3September 28, 2021 by Kenneth Fisher
One of the easiest ways to collect information about table activity is to add a series of audit columns to …
Continue reading -
A new presentation on Auditing your databases
Leave a commentAugust 19, 2021 by Kenneth Fisher
I’m giving a presentation at the PASS Data Community Summit 2021 being put on by Redgate! It’s going to be …
Continue reading -
SQL Homework – June 2021 – SQL Audits
Leave a commentJune 1, 2021 by Kenneth Fisher
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. …
Continue reading -
Event storming! It’s raining emails!
5March 1, 2017 by Kenneth Fisher
One of the most common ways to get an event notification is by email. So what happens when you get …
Continue reading -
Keep an eye on those Audit files!
1October 13, 2015 by Kenneth Fisher
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server …
Continue reading -
Do you want to build an Audit?
1December 29, 2014 by Kenneth Fisher
So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql …
Continue reading -
Intro to Auditing in SQL Server on SQL Shack
Leave a commentOctober 1, 2014 by Kenneth Fisher
I had an article published yesterday on http://www.SQLShack.com. Intro to Auditing in SQL Server. It’s worth reading if I do …
Continue reading
SQL Studies 