Tag Archives: security

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

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

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

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

    1

    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

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

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

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

    3

    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

  8. What account is xp_cmdshell using?

    2

    May 25, 2021 by Kenneth Fisher

    It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. …
    Continue reading

  9. What is the CONTROL permission?

    1

    January 19, 2021 by Kenneth Fisher

    One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: …
    Continue reading

  10. Adding a user to an Azure SQL DB

    1

    November 5, 2020 by Kenneth Fisher

    Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t …
    Continue reading

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

Join 3,576 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013