SQL Server Management Studio Offline Installer Overview SSMS (SQL server management studio) is integrated environment for managing any SQL infrastructure. It provides tools to configure, administer and monitor instances of SQL. You can build queries and scripts and update data tier components used by applications.