Category Archives: Microsoft SQL Server

  1. Notes on Presenting

    3

    May 6, 2015 by Kenneth Fisher

    As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of …
    Continue reading

  2. Building a job to monitor other jobs

    4

    May 4, 2015 by Kenneth Fisher

    The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows …
    Continue reading

  3. What SQL version is my SSIS package?

    Leave a comment

    April 27, 2015 by Kenneth Fisher

    When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how …
    Continue reading

  4. Backup before you restore

    3

    April 22, 2015 by Kenneth Fisher

    You should always be recoverable. If you haven’t heard that before, take note of it. It’s important. A while back …
    Continue reading

  5. 3

    April 20, 2015 by Kenneth Fisher

    To be fair it’s not actually hidden, just not so well known. Have you ever wondered how to grant permissions …
    Continue reading

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

  7. Remotely shutting down an instance

    1

    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

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

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

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

Follow

Get every new post delivered to your Inbox.

Join 754 other followers