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

    Category: Auditing, Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: , ,

  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

    Category: Auditing, Microsoft SQL Server, SQLServerPedia Syndication | Tags: ,

  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

    Category: Auditing, DBA Humor, Microsoft SQL Server, SQLServerPedia Syndication | Tags: , ,

  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

    Category: Auditing, Microsoft SQL Server, SQLServerPedia Syndication | Tags: , ,

  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

    Category: Auditing, Microsoft SQL Server, Security, Settings, SQLServerPedia Syndication | Tags: , ,

  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

    Category: Auditing, Blogging, Documentation, Extended Events, Microsoft SQL Server, Security, Speaking, SQLServerPedia Syndication | Tags: , , , , , ,

  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

    Category: Auditing, Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: , ,

  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

    Category: Auditing, Extended Events, Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , , ,

  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

    Category: Auditing, Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, SSMS | Tags: , ,

  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

    Category: Auditing, Microsoft SQL Server, Settings, SQLServerPedia Syndication, SSMS | Tags: , , ,

« Older Entries

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Join 3,975 other subscribers

Follow me on Twitter

@sqlstudent144