1. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

  2. T-SQL Tuesday #56: Assumptions

    6

    July 8, 2014 by Kenneth Fisher

    I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
    Continue reading

  3. Argenis and the unicorn hoodie

    1

    July 2, 2014 by Kenneth Fisher

    Early yesterday Kirsten Benzel(b/t) announced something very exciting, at least exciting to me. Argenis Fernandez(b/t) has agreed to wear a …
    Continue reading

  4. Make BOL your friend

    2

    June 30, 2014 by Kenneth Fisher

    One of the most powerful tools we have as users of SQL Server is Books Online (BOL).  Whether you work …
    Continue reading

  5. Dealing with a long string

    4

    June 25, 2014 by Kenneth Fisher

    Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the …
    Continue reading

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

  7. Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.

    17

    June 18, 2014 by Kenneth Fisher

    Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager …
    Continue reading

  8. I don’t want to grant permission to all the tables in the database at once.

    1

    June 16, 2014 by Kenneth Fisher

    A couple of weeks ago I did a post on granting or denying permissions to all the tables within a …
    Continue reading

  9. What is this default trace you speak of?

    4

    June 12, 2014 by Kenneth Fisher

    I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge …
    Continue reading

  10. MJ Swart offers free technical editing

    1

    June 9, 2014 by Kenneth Fisher

    A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me …
    Continue reading

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

Join 3,975 other subscribers

Follow me on Twitter

Archives

ToadWorld Pro of the Month November 2013