Category Archives: Security

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


    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. I’m writing a SQL Server security presentation and I need your help.


    February 24, 2022 by Kenneth Fisher

    I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going …
    Continue reading

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

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

  5. SQL Homework – August 2021 – Security Standards


    August 3, 2021 by Kenneth Fisher

    A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
    Continue reading

  6. How do I unlock a SQL Server Login using T-SQL (without changing the password)?


    July 22, 2021 by Kenneth Fisher

    We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a …
    Continue reading

  7. Another reason I prefer side-by-side SQL Server instance upgrades.


    June 29, 2021 by Kenneth Fisher

    This is a quick non-technical discussion (i.e. not a how to in any way) of some of the benefits of …
    Continue reading

  8. DDL Trigger to log database level security commands.


    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

  9. Why are my permissions missing?

    Leave a comment

    June 22, 2021 by Kenneth Fisher

    You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz …
    Continue reading

  10. #PowershellBasics: Finding a common AD group for a set of users.


    June 17, 2021 by Kenneth Fisher

    A while back (almost 7 years 😲) I wrote a post on finding the common AD groups of a set …
    Continue reading

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

Join 3,696 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013