<P> Microsoft Visual Studio includes native support for data programming with Microsoft SQL Server . It can be used to write and debug code to be executed by SQL CLR . It also includes a data designer that can be used to graphically create, view or edit database schemas . Queries can be created either visually or using code . SSMS 2008 onwards, provides intellisense for SQL queries as well . </P> <P> SQL Server Management Studio is a GUI tool included with SQL Server 2005 and later for configuring, managing, and administering all components within Microsoft SQL Server . The tool includes both script editors and graphical tools that work with objects and features of the server . SQL Server Management Studio replaces Enterprise Manager as the primary management interface for Microsoft SQL Server since SQL Server 2005 . A version of SQL Server Management Studio is also available for SQL Server Express Edition, for which it is known as SQL Server Management Studio Express (SSMSE). </P> <P> A central feature of SQL Server Management Studio is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server . It can be used to visually observe and analyze query plans and optimize the database performance, among others . SQL Server Management Studio can also be used to create a new database, alter any existing database schema by adding or modifying tables and indexes, or analyze performance . It includes the query windows which provide a GUI based interface to write and execute queries . </P> <P> SQL Server Operations Studio (Preview) is a cross platform query editor available as an optional download . The tool allows users to write queries; export query results; commit SQL scripts to GIT repositories and perform basic server diagnostics . SQL Server Operations Studio supports Windows, Mac and Linux systems . </P>

Microsoft sql server 2012 express localdb management studio