Monthly Archives: June 2014

  1. Make BOL your friend

    2

    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

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

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

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

    13

    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

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

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

  7. MJ Swart offers free technical editing

    1

    June 9, 2014 by Kenneth Fisher

    A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me …
    Continue reading

  8. 15 years of experience with Identity columns

    32

    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

  9. What is the difference between Money and Decimal(19,4)

    8

    June 2, 2014 by Kenneth Fisher

    One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4). …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,614 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013