Using the Measure-Command Cmdlet

Here is an example of using Measure-Command to gather the execution time for loading the SQL Error log into a Out-GridView object:

Sapien PowerShell Studio 2014 Notes

Changing the new script header template The path to the new script template is located on this path in Windows:

Change, or…

SQL Server Audit: Resources

I am doing some research on how to implement auditing of schema and security changes and will use this post to track notes…

Finding Suspect Pages

Here is where SQL Server stores any pages it has identified as suspect:

Views – 1125