Monthly Archives: May 2014

  1. Who has the DAC open?


    May 28, 2014 by Kenneth Fisher

    The other day I started seeing the following error in my SQL log. Error: 17810, Severity: 20, State: 2. Could …
    Continue reading

  2. Microsoft’s free virtual labs


    May 26, 2014 by Kenneth Fisher

    If you have spent any time looking around my site, you will notice that I love study materials and in …
    Continue reading

  3. DBA Myths: A table with a primary key is not a heap


    May 21, 2014 by Kenneth Fisher

    Typically when you see a heading like this you know the answer is “No” or “False” but in this case …
    Continue reading

  4. Escaping from a runaway Logon trigger


    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

  5. Granting or denying permissions to all of the tables within a database


    May 15, 2014 by Kenneth Fisher

    When granting or denying permissions to the tables within a database you have two options. You can either add the …
    Continue reading

  6. T-SQL Tuesday #54: Interviews!


    May 13, 2014 by Kenneth Fisher

    It’s T-SQL Tuesday again and this month our host is Boris Hristov (b/t). He has asked us to discuss Interviewing. …
    Continue reading

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


    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

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


    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

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

Join 3,545 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013