• Change SQL Server Name

    Rename SQL Server


  • How to delete DTA Tables

    This script will remove the database tuning advisor tables in the MSDB database on a SQL Server.


  • Windows VPN Stops working

    Sometimes this can be caused by the IKE and IPSec services. Try the following,


  • SQL Server Alerts eMail

    This query will setup email Alerts for severity levels 19 to 25 and errors 823 to 825. It will also create an SQL Agent Operator for you. Reused from http://databasehealth.com/server-overview/quick-scan-report/quick-scan-report-alerts/


  • Gravitar