Tag Archives: security

  1. Impersonation can give you the wrong answer

    1

    February 8, 2016 by Kenneth Fisher

    I use impersonation all the time to let me see additional permissions information I can only get that way and, …
    Continue reading

  2. The CONNECT permission

    4

    January 27, 2016 by Kenneth Fisher

    The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at …
    Continue reading

  3. Do you check for TRUSTWORTHY databases as part of your security audits?

    7

    December 30, 2015 by Kenneth Fisher

    I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do …
    Continue reading

  4. Hiding one or more columns

    Leave a comment

    November 12, 2015 by Kenneth Fisher

    This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain …
    Continue reading

  5. Questions from “SQL Server Security for Everyone”

    2

    November 4, 2015 by Kenneth Fisher

    I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by …
    Continue reading

  6. Administrative Logins and Users

    Leave a comment

    November 2, 2015 by Kenneth Fisher

    If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this: Please …
    Continue reading

  7. Zombie AD Groups

    4

    September 21, 2015 by Kenneth Fisher

    I spent something like 2 hours today trying to figure out how a particular user had access to one of …
    Continue reading

  8. Permissions Posters

    3

    July 27, 2015 by Kenneth Fisher

    I’ve been doing a lot of research recently for my permissions session and for a project at work. During said …
    Continue reading

  9. Copying a TDE database from one instance to another

    Leave a comment

    June 22, 2015 by Kenneth Fisher

    I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know …
    Continue reading

  10. Clean up all (most) of the orphans on an instance

    3

    June 3, 2015 by Kenneth Fisher

    Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 847 other followers