Tag Archives: security

  1. What you can do is based on more than your direct permissions.

    1

    October 6, 2022 by Kenneth Fisher

    What you have access to is not just what you have direct permissions to. The other day I needed to …
    Continue reading

  2. Viewing errors with extended events

    1

    September 27, 2022 by Kenneth Fisher

    A little while back I came across this post: Identifying failed queries with extended events. It has a script to …
    Continue reading

  3. Creating a SERVER ROLE created a LOGIN as well.

    1

    September 6, 2022 by Kenneth Fisher

    One of my co-workers came to me the other day and told me that they found their network id as …
    Continue reading

  4. Why is security important in a dev environment?

    6

    August 23, 2022 by Kenneth Fisher

    I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve …
    Continue reading

  5. New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

    Leave a comment

    August 18, 2022 by Kenneth Fisher

    I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in …
    Continue reading

  6. EXECUTE AS USER vs EXECUTE AS LOGIN

    Leave a comment

    July 26, 2022 by Kenneth Fisher

    I use impersonation a lot. It’s a really easy way to check if someone has the permissions they are supposed …
    Continue reading

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

  8. I’m writing a SQL Server security presentation and I need your help.

    5

    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

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

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

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013