Microsoft Sql Server Management Studio 2017 [upd] -

While improved, IntelliSense in SSMS 2017 is still hit-or-miss. Compared to tools like Redgate SQL Prompt or even the IntelliSense in Visual Studio proper, SSMS can struggle with large schemas. It occasionally suggests columns that don’t exist or fails to populate suggestions until you backspace and retype. It’s usable, but it can be frustrating when you are flying through a complex script.

| Tool | Use Case | Platform | |------|----------|----------| | | Legacy support & older Windows environments | Windows only | | SSMS 18/19 | Current SSMS line with ongoing updates | Windows only | | Azure Data Studio | Lightweight cross-platform editor (macOS, Linux, Windows) | Cross-platform | | Visual Studio Code + mssql | Developer-focused T-SQL editing | Cross-platform | microsoft sql server management studio 2017