Tag Archives: microsoft sql server

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


    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. Add them to ALL the roles!


    July 21, 2014 by Kenneth Fisher

    I seem to get a lot of permissions questions these days and one of the more frequent ones goes along …
    Continue reading

  3. What does it mean that a value is NULL?


    July 14, 2014 by Kenneth Fisher

    Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be …
    Continue reading

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

  5. Make BOL your friend

    Leave a comment

    June 30, 2014 by Kenneth Fisher

    One of the most powerful tools we have as users of SQL Server is Books Online (BOL).  Whether you work …
    Continue reading

  6. Dealing with a long string


    June 25, 2014 by Kenneth Fisher

    Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the …
    Continue reading

  7. sp_SrvPermissions & sp_DBPermissions V5.0


    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

  8. Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.


    June 18, 2014 by Kenneth Fisher

    Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager …
    Continue reading

  9. I don’t want to grant permission to all the tables in the database at once.


    June 16, 2014 by Kenneth Fisher

    A couple of weeks ago I did a post on granting or denying permissions to all the tables within a …
    Continue reading

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


Get every new post delivered to your Inbox.

Join 293 other followers