Using the DAC (Dedicated Admin Connection) in SQL Server

From Kendra’s blog: There’s always a catch. You many need to get firewall ports opened as well, depending on your environment and…

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…