Tag Archives: code language

  1. More than sp_help

    1

    August 14, 2014 by Kenneth Fisher

    If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
    Continue reading

  2. SchemaBinding – What & Why

    5

    August 6, 2014 by Kenneth Fisher

    What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
    Continue reading

  3. Deny vs Revoke

    1

    August 4, 2014 by Kenneth Fisher

    Quick quiz. Which of these two commands is the opposite of GRANT? DENY REVOKE   Well lets start with some …
    Continue reading

  4. What is ANSI_NULLS and why will I be glad when it finally goes away?

    9

    July 28, 2014 by Kenneth Fisher

    Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and …
    Continue reading

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

    3

    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

  6. Yes, Virginia, you can have too much white space.

    21

    July 16, 2014 by Kenneth Fisher

    When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch …
    Continue reading

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

    11

    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

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

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

  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 334 other followers