Tag Archives: microsoft sql server

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

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

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

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

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

Follow

Get every new post delivered to your Inbox.

Join 768 other followers