Category Archives: System Functions and Stored Procedures

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

  2. What is this default trace you speak of?

    Leave a comment

    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

  3. Escaping from a runaway Logon trigger

    Leave a comment

    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

  4. Does SQL Server do a CHECKDB during an instance restart?

    11

    May 7, 2014 by Kenneth Fisher

    When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server …
    Continue reading

  5. Why is there a sysobjects when we already have sys.objects?

    Leave a comment

    May 5, 2014 by Kenneth Fisher

    Once upon a time in a version of SQL far far away we had system tables that were easy to …
    Continue reading

  6. The default autogrowth settings do NOT come from the Model database.

    1

    April 28, 2014 by Kenneth Fisher

    I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed …
    Continue reading

  7. Collation: Temporary objects and variables: Demonstration

    4

    April 21, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading about them. As I read …
    Continue reading

  8. Getting a query plan

    Leave a comment

    February 19, 2014 by Kenneth Fisher

    Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
    Continue reading

  9. Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

    Leave a comment

    January 29, 2014 by Kenneth Fisher

    I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I …
    Continue reading

  10. Negative session_ids

    2

    January 27, 2014 by Kenneth Fisher

    I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 293 other followers