The Database Engine Tuning Advisor helps the administrator to analyze the data and modify the server performance. The following snapshot demonstrates the data reporting in the application.
The following image shows the analysis service added in the SQL Server.ģ) Data reporting: The reporting service allows the user to build reports in various formats. 2) Data analysis: The analysis services helps to analyze the data present in the warehouse. The following snapshot shows the window for the business intelligent projects. They following solutions are provided by the Studio:ġ) Data Integration: The integration services helps to build solutions and integrate data from different sources and store them in the common warehouse. The steps for locating the SQL Server Business Development Studio are as follows:ġ) Click ‘Start’, select ‘Programs’, Click ‘Microsoft SQL Server’.Ģ) Select ‘SQL Server Business Intelligent Development Studio’ from the list.ģ) The studio window will open as shown in the following figure. The data helps in making plans and decisions. They are created by the data generated in the organization. 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.