Category Archives: System Functions and Stored Procedures

  1. Pulling data from the error log

    4

    August 17, 2015 by Kenneth Fisher

    The other day I was asked to pull a list of errors from the SQL Server log into a table …
    Continue reading

  2. Which user function do I use?

    Leave a comment

    June 24, 2015 by Kenneth Fisher

    Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you …
    Continue reading

  3. Extending your metadata with Extended Properties

    8

    May 18, 2015 by Kenneth Fisher

    Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on …
    Continue reading

  4. Who’s using that database?

    Leave a comment

    March 9, 2015 by Kenneth Fisher

    A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
    Continue reading

  5. Putting sp_ at the beginning of your stored procedure.

    1

    November 24, 2014 by Kenneth Fisher

    Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So …
    Continue reading

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

    2

    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

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

    5

    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

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

  9. Triggers are not toys!

    8

    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

  10. What are trace flags?

    Leave a comment

    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

Follow

Get every new post delivered to your Inbox.

Join 803 other followers