Category Archives: System Functions and Stored Procedures

  1. Using T-SQL to populate a Central Management Server

    6

    November 17, 2014 by Kenneth Fisher

    We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
    Continue reading

  2. TSQL Tuesday #60: Something New Learned – What permissions does <username> have?

    7

    November 11, 2014 by Kenneth Fisher

    What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to …
    Continue reading

  3. Changing configuration settings with sp_configure

    5

    September 22, 2014 by Kenneth Fisher

    I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that …
    Continue reading

  4. Triggers are not toys!

    9

    September 17, 2014 by Kenneth Fisher

    For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL …
    Continue reading

  5. What are trace flags?

    3

    September 11, 2014 by Kenneth Fisher

    Trace flags are one of those things that I’ve heard about more and more over the last five or six …
    Continue reading

  6. Two simple commands that can be a big help in performance tuning.

    10

    September 2, 2014 by Kenneth Fisher

    The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
    Continue reading

  7. More than sp_help

    6

    August 14, 2014 by Kenneth Fisher

    If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
    Continue reading

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

  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. Escaping from a runaway Logon trigger

    11

    May 19, 2014 by Kenneth Fisher

    Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
    Continue reading

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

Join 3,746 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013