1. Adding, altering or removing multiple columns from a table

    2

    April 16, 2015 by Kenneth Fisher

    I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing …
    Continue reading

  2. Remotely shutting down an instance

    Leave a comment

    April 14, 2015 by Kenneth Fisher

    This month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t) …
    Continue reading

  3. Make sure you back up the Service Master Key

    3

    April 8, 2015 by Kenneth Fisher

    I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master …
    Continue reading

  4. What is a CTE

    1

    April 6, 2015 by Kenneth Fisher

    CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade. …
    Continue reading

  5. Microsoft buys the dictionary

    3

    April 1, 2015 by Kenneth Fisher

    It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as …
    Continue reading

  6. Port numbers and SQL Server

    Leave a comment

    March 30, 2015 by Kenneth Fisher

    I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are …
    Continue reading

  7. Clean out all bad characters from a string.

    10

    March 25, 2015 by Kenneth Fisher

    I have a customer who is having a problem with a load. He is getting a fair number of bad …
    Continue reading

  8. 0 to Speaker

    10

    March 23, 2015 by Kenneth Fisher

    Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I …
    Continue reading

  9. Why not NOLOCK?

    4

    March 18, 2015 by Kenneth Fisher

    Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
    Continue reading

  10. There are #temp tables and then there are ##temp tables.

    Leave a comment

    March 16, 2015 by Kenneth Fisher

    Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 719 other followers