Category Archives: Dynamic SQL

  1. sp_SrvPermissions & sp_DBPermissions V4.0

    Leave a comment

    January 15, 2014 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
    Continue reading

  2. sp_SrvPermissions & sp_DBPermissions V3.0

    Leave a comment

    November 4, 2013 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
    Continue reading

  3. sp_DBPermissions V2.0

    1

    September 18, 2013 by Kenneth Fisher

    Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
    Continue reading

  4. sp_SrvPermissions V2.0

    1

    September 18, 2013 by Kenneth Fisher

    Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
    Continue reading

  5. sp_SrvPermissions

    Leave a comment

    August 19, 2013 by Kenneth Fisher

    Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
    Continue reading

  6. sp_DBPermissions

    3

    August 14, 2013 by Kenneth Fisher

    Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last …
    Continue reading

  7. Database Permissions Queries

    Leave a comment

    August 5, 2013 by Kenneth Fisher

    Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
    Continue reading

  8. Generic Dynamic SQL Stored Procedure

    3

    July 22, 2013 by Kenneth Fisher

    Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle …
    Continue reading

  9. Writing Dynamic SQL (A how to)

    2

    July 1, 2013 by Kenneth Fisher

    A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions …
    Continue reading

  10. Best practice recommendations for writing Dynamic SQL

    12

    June 12, 2013 by Kenneth Fisher

    Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 163 other followers