Category Archives: Auditing

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. Event storming! It’s raining emails!

    5

    March 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

  9. Administrative Logins and Users

    3

    November 2, 2015 by Kenneth Fisher

    If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this: Please …
    Continue reading

  10. Keep an eye on those Audit files!

    1

    October 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

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

Join 3,581 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013