RSS Feed

‘Handy Scripts’ Category

  1. Handy Query: Is LPIM Enabled?


    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 …
    keep reading

  2. Handy Query: When Did My Instance Start?


    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 …
    keep reading

  3. Handy Script: Testing Database Mail Configurations


    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 …
    keep reading

  4. Handy Script: Confirming Objects Modified


    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 …
    keep reading

  5. Handy Script: Find Running SQL Agent Jobs


    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. …
    keep reading