+ automatically discovers instances and provides basic management of instances + provides network failure resilience to reduce backup failures + provides dynamic compression to balance backup time against compression – not suitable for extensive backup and restore management + start and stop backups and restores, and displays backup settings and status + analyzes user permissions across database objects + identifies vulnerabilities in SQL Server and Azure environments to harden security policies

– not suitable for extensive security management + displays user activity and manage user access to databases + tracks user activities and data changes + uses lightweight data collection mechanisms that minimize server impact + view user activity and manage user access to databases – not suitable for extensive auditing + performs diagnostics with deep-dive drill-downs

+ displays alerts and summaries of alerts, and send notifications + continuously monitors large SQL Server environments – not suitable for extensive performance management + displays availability and performance metrics

Third-party supplements for SSMS should provide these benefits for environments that run many instances of SQL Server simultaneously as well as single instances. Third-party software offers capabilities such as performance monitoring, security and compliance management, backup and restore management, including instant recovery, and inventory management. Many data professionals are quite familiar with SSMS, and it is a nice tool. Virtually everyone who works with Microsoft SQL Server uses SQL Server’s Management Studio (SSMS), even those with access to similar solutions. Overcoming Limitations of Microsoft SQL Server Management Studio

Microsoft sql manager studio