Tag Archives: problem resolution

  1. Why am I getting a primary/unique key violation?

    Leave a comment

    July 23, 2014 by Kenneth Fisher

    This may seem like a question with a simple answer but there is a bit more to it than you …
    Continue reading

  2. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

  3. T-SQL Tuesday #56: Assumptions

    6

    July 8, 2014 by Kenneth Fisher

    I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
    Continue reading

  4. Who has the DAC open?

    Leave a comment

    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

  5. Start with stupid

    1

    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

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

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

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

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

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

Follow

Get every new post delivered to your Inbox.

Join 293 other followers