It consists of an environment for developing business intelligent solutions.

SQL Server Business Intelligent Development Studio is provided by the Visual Studio. The window is available from the Help menu of the server.ĥ.2 SQL Server Business Intelligent Development Studio It is used to provide the set of templates of SQL queries to perform the standard database operations It is the window that provides the ability to execute the queries written in T- SQL. It is the window that provides the organized view of your projects and files The window is used to display all the servers registered within the management studio. It is used to provide the detailed description of all the objects in the SQL Server The explorer allows to configure the following components:ġ) Security: It is used to create login users, and to assign permissionsĢ) Replication: It is used to create and manage publishers and subscribersģ) SQL Server Agent: It is used to automate administrative tasks by creating and managing jobs, alerts and operatorsĤ) Management: It is used to configure the distributed transaction Coordinator, Database Mail Service, or SQL Server logs.ĥ) Server Objects: It is used to create and manage backups, endpoints, and triggers

It is a window that provides the ability to register, browse and manage servers. The following table lists the main components of the SQL Server Management Studio. The following image shows the SQL Server Management Studio. The user can view the execution plans in several formats. The user can create and execute the queries. It contains several components such as query editor, solution explorer and object explorer. It gives user an easy and integrated environment for creating and managing SQL Server database objects. SQL Server Management Studio is the tool that is associated with the Server. These tools help the database administrators for server configuration and performance optimization.

There are several other tools provided by the SQL Server which include Database Engine Tuning Advisor and SQL Server Configuration Manager. The SQL Server Business Intellegent Development Studio is used for creating and managing the BI solutions. The Management Studio is a very useful tool for creating and maintaining the SQL server database objects. SQL Server offers several tools to efficiently manage databases.

Sql bi tools