Category Archives: Microsoft SQL Server

  1. Changing to simple recovery to clear the log.

    3

    February 10, 2016 by Kenneth Fisher

    Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries …
    Continue reading

  2. Impersonation can give you the wrong answer

    1

    February 8, 2016 by Kenneth Fisher

    I use impersonation all the time to let me see additional permissions information I can only get that way and, …
    Continue reading

  3. Blogger questions: What if someone else wrote about the same subject?

    6

    February 3, 2016 by Kenneth Fisher

    I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a …
    Continue reading

  4. Running code on the startup of SQL Server

    1

    February 1, 2016 by Kenneth Fisher

    Every now and again you need to run code when your instance starts up. For example you might want to …
    Continue reading

  5. The CONNECT permission

    4

    January 27, 2016 by Kenneth Fisher

    The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at …
    Continue reading

  6. Reusing schedules in SQL Agent

    1

    January 25, 2016 by Kenneth Fisher

    I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor …
    Continue reading

  7. Start SQL Server without tempdb

    1

    January 20, 2016 by Kenneth Fisher

    tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter. While at …
    Continue reading

  8. To the page and back again

    1

    January 18, 2016 by Kenneth Fisher

    To the page It’s not one of those things you have to do frequently but every now and again you …
    Continue reading

  9. What is RESULT SETS?

    11

    January 14, 2016 by Kenneth Fisher

    I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before …
    Continue reading

  10. Ad-hoc Changes

    4

    January 12, 2016 by Kenneth Fisher

    TSQL Tuesday #74: Be The Change Each month, on the first Tuesday of the month, the announcement for the blog …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 847 other followers