DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.
dbForge SQL Complete is a useful add-in for SQL Server Management Studio and Visual Studio. Free and paid editions of the tool offer the powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense.
ApexSQL Complete can automatically fill in SQL keywords, statements and identifiers. It integrates seamlessly with SSMS and MSVS. ApexSQL Complete helps with object script and description reviews without coding interruption.