1. Lead Blocker

    4

    January 18, 2017 by Kenneth Fisher

    Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
    Continue reading

  2. What is COPY_ONLY?

    2

    January 16, 2017 by Kenneth Fisher

    You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up …
    Continue reading

  3. Why won’t my SQL Logins work?

    8

    January 12, 2017 by Kenneth Fisher

    I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
    Continue reading

  4. Connect suggestion to add included columns to sp_helpindex

    Leave a comment

    January 10, 2017 by Kenneth Fisher

    I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the …
    Continue reading

  5. A detailed view into your Azure resources

    Leave a comment

    January 5, 2017 by Kenneth Fisher

    I’ve been studying Azure recently and came across a really interesting Azure site. resources.azure.com To give you an idea why …
    Continue reading

  6. sp_refreshsqlmodule_internal – The user does not have permission to perform this action.

    Leave a comment

    December 28, 2016 by Kenneth Fisher

    Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found …
    Continue reading

  7. A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup

    Leave a comment

    December 26, 2016 by Kenneth Fisher

    I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery …
    Continue reading

  8. sp_helptext vs object_definition()

    3

    December 21, 2016 by Kenneth Fisher

    I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I …
    Continue reading

  9. :OUT :OUT darn results!

    2

    December 19, 2016 by Kenneth Fisher

    Years ago I worked for a company that had a rather cool way of handling requests. When we ran the …
    Continue reading

  10. An interview with me

    6

    December 15, 2016 by Kenneth Fisher

    The other day I received an email asking for some help with a school project. Would I please answer some …
    Continue reading

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

Join 1,598 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013