SQL Server Management Studio (SSMS) is an integrated environment for managing a SQL Server infrastructure.
SSMS provides a user interface that interacts with SQL Server. Microsoft first released the product alongside SQL Server 2005, and it has continued to be a part of management for Microsoft SQL Server 2008 and Microsoft SQL Server 2012.
SSMS provides tools to configure, manage and administer instances of Microsoft SQL Server, bringing together a range of graphical and visual design tools and script editors that simplify working with SQL Server. In addition to simplifying SQL Server tasks, SSMS maintains a single, integrated environment for SQL Server Database Engine management and authoring.
Microsoft SQL Server Management Studio's features include Object Explorer, which can view and manage all objects in a SQL Server instance; Template Explorer, which builds and manages files of boilerplate text that can be reused to speed up query and script development; and Solution Explorer, which builds the projects used to manage administration items, such as queries and scripts.