‘Handy Scripts’ Category
-
Handy Query: Is LPIM Enabled?
11April 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 readingCategory Handy Scripts | Tags:
-
Handy Query: When Did My Instance Start?
30April 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 readingCategory Handy Scripts | Tags:
-
Handy Script: Testing Database Mail Configurations
2April 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 readingCategory Handy Scripts | Tags:
-
Handy Script: Confirming Objects Modified
0April 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 readingCategory Handy Scripts | Tags:
-
Handy Script: Find Running SQL Agent Jobs
4April 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 readingCategory Handy Scripts | Tags: