Category Archives: Handy Scripts
-
Handy Query: Is LPIM Enabled?
6April 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 -
Handy Query: When Did My Instance Start?
Leave a commentApril 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 -
Handy Script: Testing Database Mail Configurations
Leave a commentApril 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 -
Handy Script: Confirming Objects Modified
Leave a commentApril 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 -
Handy Script: Find Running SQL Agent Jobs
1April 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