Category Archives: Handy Scripts

  1. Handy Query: Is LPIM Enabled?

    6

    April 27, 2015 by Mike Hillwig

    My counterpart in our R&D department is a strong believer that enabling Lock Pages in Memory is required for our …
    Continue reading

  2. Handy Query: When Did My Instance Start?

    Leave a comment

    April 24, 2015 by Mike Hillwig

    My company has a rule. We must reboot each of our Windows servers at least quarterly in order to ensure …
    Continue reading

  3. Handy Script: Testing Database Mail Configurations

    Leave a comment

    April 16, 2015 by Mike Hillwig

    In my environment, we enable database mail on every instance. While we have very few clients or applications that use …
    Continue reading

  4. Handy Script: Confirming Objects Modified

    Leave a comment

    April 15, 2015 by Mike Hillwig

    One of the things my team does frequently for clients is moving objects between environments. We have to migrate a …
    Continue reading

  5. Handy Script: Find Running SQL Agent Jobs

    1

    April 13, 2015 by Mike Hillwig

    One of the things SQL Server doesn’t make all that easy is to know what SQL Agent jobs are running. …
    Continue reading