Free MS tool to optimize SQL Server
Free MS tool to optimize SQL Server
I don't know how I never heard of this tool MS has made but it's one of the top 5 utils I've ever downloaded from their site (hrmm, sounds like I should make a list of them in a future post).
While I was expecting it to do some security scanning, this tool is actually a pure optimization analyzer (although some of the scans will make minor improvements in security).
You can find the tool, called 'SQL Server Best Practices Analyzer' here.