Tag Archives: problem resolution

  1. Start with stupid

    Leave a comment

    March 17, 2014 by Kenneth Fisher

    True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked …
    Continue reading

  2. Check your SQL Agent history settings before it’s too late!

    3

    February 10, 2014 by Kenneth Fisher

    A little while back I was doing some research into a failed job and ran into a slight problem. The …
    Continue reading

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

  4. Why you should know how to script as well as use the GUI

    Leave a comment

    October 14, 2013 by Kenneth Fisher

    Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out …
    Continue reading

  5. I’ve refreshed a test database from prod but now the users can’t access it.

    3

    October 9, 2013 by Kenneth Fisher

    This happens to me all the time. I get a request from a developer to overwrite the test copy of …
    Continue reading

  6. Brad Shultz’s blog on reviewing your database

    1

    September 17, 2013 by Kenneth Fisher

    This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
    Continue reading

  7. A T-SQL query to get current job activity

    Leave a comment

    September 5, 2013 by Kenneth Fisher

    I recently had the task of collecting job activity for the purposes of turning it into a report for some …
    Continue reading

  8. The most important skill to practice when preparing for any certification exam!

    4

    August 28, 2013 by Kenneth Fisher

    I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an …
    Continue reading

  9. Notes on debugging Database Mail problems

    4

    July 29, 2013 by Kenneth Fisher

    I’ve had to debug database mail problems several times over the last year or so. Below is a collection of …
    Continue reading

  10. EXECUTE, not required, but advisable.

    1

    February 6, 2013 by Kenneth Fisher

    The other day one of the developers I work with gave me a script similar to this: He was getting …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 163 other followers