Monthly Archives: April 2015

  1. Running Powershell scripts remotely.

    2

    April 29, 2015 by Kenneth Fisher

    I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of …
    Continue reading

  2. What SQL version is my SSIS package?

    22

    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

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

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

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

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

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

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

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

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

Join 1,628 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013