Doing a SQL Server Healthcheck via PowerShell

This article describes a way of checking the health of any number of SQL Server instances and servers. It quickly collates server performance statistics and highlights potential problems such as missing indexes, untrusted foreign keys and database options that aren't set to the default. 

Read More