RSS Feed

‘Handy Scripts’ Category

  1. Handy Query: Is LPIM Enabled?

    11

    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?

    30

    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

    2

    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

    0

    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

    4

    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


Search

Pages