SQL Server Management studio is now can be installed separately not part of SQL Server package.
with this enhancement SSMS has several features and version is getting updated and new versions getting release which we can install separately.
in addition to this SQL Server is available for Azure and with Linux and machine learning enhancement it has to go beyond SSMS to use multiple languages and features which cannot be accommodated in SSMS, SSMS is a great tool for In premise system but for others recently Microsoft has introduced a tool called “Azure Data Studio” it will has almost all the feature SSMS is having with addition to that it can have
“Notebook” like Jupyter
can include multiple Languages: Python, R Powershell integrated, also allow to include more as needed..
and SSMS query intellisense with wonderful chart feature
Highly recommended for Future SQL Server DBA’s
**November 2019 version is released last week.
Reference: