1. Adding new users & groups in windows

    1

    May 20, 2015 by Kenneth Fisher

    I do a lot of testing with security in SQL Server. And of course to do a thorough job of …
    Continue reading

  2. Extending your metadata with Extended Properties

    5

    May 18, 2015 by Kenneth Fisher

    Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on …
    Continue reading

  3. Test first; Mileage may vary;

    2

    May 14, 2015 by Kenneth Fisher

    I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a …
    Continue reading

  4. TSQL Tuesday #66: Monitoring

    1

    May 12, 2015 by Kenneth Fisher

    If a user is going to call me about problem, I’d much rather know about it ahead of time. In …
    Continue reading

  5. Notes on Presenting

    8

    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

  6. Building a job to monitor other jobs

    5

    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

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

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

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

  10. The hidden security of msdb

    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

Follow

Get every new post delivered to your Inbox.

Join 768 other followers