Category Archives: Security

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

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

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

  4. Multiple Windows Groups with different default databases

    2

    May 28, 2015 by Kenneth Fisher

    A question came up at work the other day, mostly as a mind game, but you never know it might …
    Continue reading

  5. Adding new users & groups in windows

    2

    May 20, 2015 by Kenneth Fisher

    I do a lot of testing with security in SQL Server. And of course to do a thorough job of …
    Continue reading

  6. 3

    April 20, 2015 by Kenneth Fisher

    To be fair it’s not actually hidden, just not so well known. Have you ever wondered how to grant permissions …
    Continue reading

  7. 0 to Speaker

    12

    March 23, 2015 by Kenneth Fisher

    Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I …
    Continue reading

  8. Using sp_DBPermissions and sp_SrvPermissions v6.0

    1

    February 25, 2015 by Kenneth Fisher

    It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
    Continue reading

  9. TSQL Tuesday #63 – How do you manage security: Rollup

    1

    February 12, 2015 by Kenneth Fisher

    When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was …
    Continue reading

  10. TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

    7

    February 10, 2015 by Kenneth Fisher

    So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 799 other followers