1. Multiple Windows Groups with different default databases

    Leave a comment

    May 28, 2015 by Kenneth Fisher

    A question came up at work the other day, mostly as a mind game, but you never know it might …
    Continue reading

  2. Default database

    Leave a comment

    May 26, 2015 by Kenneth Fisher

    What? The default database is one of the options when creating a login in SQL Server. This is the initial …
    Continue reading

  3. Adding new users & groups in windows

    2

    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

  4. Extending your metadata with Extended Properties

    6

    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

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

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

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

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

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

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

Follow

Get every new post delivered to your Inbox.

Join 768 other followers