tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P14

Microsoft SQL Server 2008 R2 Unleashed- P14:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 84 CHAPTER 4 SQL Server Management Studio FIGURE Managed Instances. FIGURE Utility Administration. Download from Development Tools 85 The Policy tab is one of three tabs available on the Utility Administration window. You can see in Figure that there are also Security and Data Warehouse tabs. The Security tab allows you to manage permissions for logins that can administer or read from the UCP. Logins can be assigned to the Utility Reader role on this screen which allows them to connect to the SQL Server Utility and read information from the Utility Explorer in SSMS. The Data Warehouse tab allows you to adjust the amount of time data will be retained in the UCP data warehouse. The default time period is one year. Over time the amount of data collected in the UCP data warehouse can be substantial. By default each managed instance enrolled in the UCP sends configuration and performance data to the UCP every 15 minutes. Consequently the space used by the utility management data warehouse UMDW needs to be monitored. The UMDW database named sysutility_mdw is listed as a user database in the Object Explorer. Development Tools SSMS delivers an equally impressive number of features for database developers. Many of the features were available with SQL Server 2005 but SQL Server 2008 has added some new ones as well. T-SQL Debugging IntelliSense in the Query Editor and multiserver queries are a few of those new tools for developers found in SQL Server 2008. These new tools and the other essential developer tools from SSMS are discussed in the following sections. The Query Editor The Query Editor sits at the top of the list for development tools in SSMS. The Query Editor as its name indicates is the editing tool for writing queries in SSMS. It contains much of the functionality that was contained in SQL Server 2000 s Query Analyzer. The capability to write T-SQL queries execute them return results generate execution plans and use many of the .

TỪ KHÓA LIÊN QUAN