Category Archives: Security

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

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

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

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

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

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

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

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

  9. SQL Homework – August 2021 – Security Standards

    1

    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

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

    2

    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

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

Join 3,709 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013