Category Archives: Auditing

  1. Creating a Database Audit Specification can create new users & schemas in the background

    2

    June 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

  2. An auditing mind set

    2

    May 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

  3. Quiz & answers for my “Auditing your data and data access” session.

    1

    November 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

  4. Audit Columns

    3

    September 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

  5. Auditing with “C2 Auditing” and “Common Criteria Compliance”

    Leave a comment

    September 7, 2021 by Kenneth Fisher

    I’m going to be fairly high level on these because to be honest, if you are going to use them …
    Continue reading

  6. A new presentation on Auditing your databases

    Leave a comment

    August 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

  7. DDL Trigger to log database level security commands.

    4

    June 24, 2021 by Kenneth Fisher

    In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in …
    Continue reading

  8. SQL Homework – June 2021 – SQL Audits

    Leave a comment

    June 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

  9. Help it takes forever to open the SQL Server Log!

    Leave a comment

    January 24, 2018 by Kenneth Fisher

    Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the …
    Continue reading

  10. Default Instance Reports – Configuration Changes History

    Leave a comment

    July 17, 2017 by Kenneth Fisher

    Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,746 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013