Tag Archives: security

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

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

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

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

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

  6. What account is xp_cmdshell using?


    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

  7. What is the CONTROL permission?


    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

  8. Adding a user to an Azure SQL DB


    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

  9. Permissions script for Azure Synapse


    October 15, 2020 by Kenneth Fisher

    I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for …
    Continue reading

  10. As a DBA, am I a gatekeeper?


    August 27, 2020 by Kenneth Fisher

    TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and …
    Continue reading

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

Join 3,746 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013