Tag Archives: microsoft sql server

  1. Add them to ALL the roles!

    Leave a comment

    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

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

    8

    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

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

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

  5. Dealing with a long string

    4

    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

  6. sp_SrvPermissions & sp_DBPermissions V5.0

    2

    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

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

    12

    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

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

    1

    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

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

  10. 15 years of experience with Identity columns

    25

    June 4, 2014 by Kenneth Fisher

    An identity column is an auto incrementing column An identity column is typically used as a primary key A primary …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 290 other followers