T-SQL Code Analyzer for Visual Studio 2015 CTP6 - alpha version, limited functionality.
Based on the Microsoft.SqlServer.TransactSql.ScriptDom NuGet package.
Image showing the T-SQL Analyzer in action.
Get the latest version on NuGet now: TSqlAnalyzer
PM> Install-Package TSqlAnalyzer -Pre