Tag Archives: dynamic sql

  1. Using Table Valued Parameters with sp_executesql

    3

    September 13, 2018 by Kenneth Fisher

    Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to …
    Continue reading

  2. Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties

    3

    August 20, 2018 by Kenneth Fisher

    Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours …
    Continue reading

  3. Variables in Dynamic SQL

    1

    November 16, 2017 by Kenneth Fisher

    I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. …
    Continue reading

  4. Dynamic SQL and the joys of QUOTENAME

    5

    May 11, 2017 by Kenneth Fisher

    I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even …
    Continue reading

  5. sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

    5

    March 27, 2017 by Kenneth Fisher

    It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, …
    Continue reading

  6. Queries with optional parameters

    11

    February 27, 2017 by Kenneth Fisher

    These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
    Continue reading

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

  8. Generating a restore script

    8

    August 18, 2014 by Kenneth Fisher

    In order to speed up our backups on a large database our team decided to stripe the backup files. In …
    Continue reading

  9. sp_SrvPermissions & sp_DBPermissions V5.0

    2

    June 23, 2014 by Kenneth Fisher

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

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

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

Join 2,461 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013