- The new administrator features in SSMS include a beefed-up Activity Monitor, a new Object Search option, a customizable Object Explorer Details window, and a new manage- ment tool named SQL Server Utility that was added with SQL Server 2008 R2. - The Object Search option allows you to search for database objects by name while changes to the Object Explorer Details window significantly expand the amount of available informa- tion and allow the user to change the information that is displayed. - Finally, the new SQL Server Utility allows for the capture of resource information across multiple servers and provides one unified view for the display of this information.. - Enhancements that are focused on the developer include IntelliSense in the Query Editor, an integrated Transact-SQL (T-SQL) Debugger, and a Multiserver Query execution option.. - This feature was much anticipated for SQL Server 2005, but it never made it to the released code. - That anticipation continued with SQL Server 2008, and fortunately, Microsoft has delivered.. - You can set breakpoints, evaluate variables, and step through the code line by line. - This debugging capability applies to all T-SQL in the query editor window.. - Multiserver queries is the last standout feature offered with SQL Server 2008. - Next, it looks at the administrative tools and what changes have been made to help you better manage your SQL Server environment. - Finally, this chapter looks at the devel- opment tools available with SSMS and changes made to improve your SQL Server develop- ment experience.. - If you have been working with SQL Server for a long time, you may remember the SQL Enterprise Manager that came with SQL Server 6.5. - Like the SQL Server 6.5 Enterprise Manager, SSMS provides an integrated environment where developers and DBAs alike can perform the database tasks they need. - Say goodbye to Query Analyzer, Analysis Manager, and a number of other desparate tools used in SQL Server 2000 and say hello to SSMS, which provides “one-stop shopping” for most of your database needs.. - FIGURE 4.1 The SSMS main display.. - Figure 4.1 shows the document window area displaying the Object Explorer Details page. - The Object Explorer Details page is the default, but other pages, such as a query editor window, can take the focus in this tab-oriented section of the SSMS display.. - The dialogs that form the rest of the SSMS display are referred to as components and include the Registered Servers and Object Explorer windows shown in Figure 4.1, as well as a number of other components that can be displayed via the View menu found at the top of the SSMS display. - You can configure each of the component windows in a number of ways. - for example, you can have them float, or you can hide, dock, autohide, or display them as tabbed documents in the document window area.. - The configuration that you choose for your SSMS display depends on the type of work you do with SQL Server as well as the type of person you are. - When you mouse over the tab, the window automatically expands and stays expanded as long as the mouse cursor remains in the component window area. - Auto Hide helps maximize the working real estate available in the document window for query development and the. - You can reposition the component windows by dragging and dropping them to the desired locations. - When you are in the middle of a drag and drop, rectangular icons with arrows are displayed at different locations on the SSMS window surface. - In SQL Server 2000, the Enterprise Manager users were forced to open another instance of the application during many administrative tasks to be able to continue with other work. - With SSMS, you can launch a backup with the Back Up Database dialog and then continue working with the Object Explorer or other components in SSMS while the backup is running. - For example, the SQL Server 2000 Enterprise Manager Restore dialog had a fixed size. - The Restore dialog in SQL Server 2008’s SSMS can contain a slew of information related to the backup sets available for restore. - If desired, you can change the environment from a tabbed display to multiple-document interface (MDI) mode. - The MDI mode manages windows like the SQL Server 2000 Query Analyzer and may be more user-friendly for some people. - You can. - One particularly useful window that can be displayed in the document window is the Object Explorer Details page. - This new window displays information relative to the node selected in the Object Explorer and includes options to produce detailed reports and graphs. - The Object Explorer Details page is displayed in the document window by default when SSMS is launched, but you can also display it by pressing F7 or choosing Object Explorer Details from the View menu.. - The Object Explorer Details page has been vastly improved in SQL Server 2008. - If you’re familiar with the previous version, you can see in Figure 4.1 that there is much more information displayed in SQL Server 2008 than there was in 2005. - The nice part is that you can customize the information that is displayed and save those changes so that they are used the next time you open SSMS. - The columns that are available depend on the type of object selected in the Object Explorer window.. - You can copy some or all of the information shown in the Object Explorer Details win- dow and paste it into another application such as Excel for a quick and easy report.. - For example, you can select the Databases node in Object Explorer, highlight the data shown in the Object Explorer Details page, press Ctrl+C to copy the data, and then paste it into Excel. - Another significant change in the Object Explorer Details page is the Object Search box.. - The Object Search box, located at the top of the Object Explorer Details page (next to the Search label), allows you to search for objects by name. - You can use wildcards (for example, Product. - or you can type a specific name you are looking for. - The results are displayed in the Object Explorer Details page. - Keep in mind that the objects that are searched depend on what is selected in the Object Explorer window. - For example, if you highlight the Databases node, you search all the databases on your SQL Server instance. - In SQL Server 2000, you could select multiple objects for scripting by selecting the items from the Object Explorer tree in Enterprise Manager. - You cannot use the Object Explorer tree to perform this operation with SQL Server 2008, and this has generated some confusion. - The solution is the Object Explorer Details page, which provides a means for performing multiple selections of the objects it displays. - You can hold down the Ctrl key and click only those items you want to script. - This method also works with scheduled jobs displayed in the Object Explorer Details page. - SQL Server 2000 did not offer this capability.. - Local help includes the local SQL Server Books Online resources. - Questions—The Questions option allows you to search the forum archives for answers to questions that others have already asked. - You can choose to search online resources first, followed by local help, or you can choose an option that searches local help resources first, followed by online resources. - You can also choose specific Codezone online resources to search, or you can eliminate the search of all online resources. - you can access by simply clicking on that area. - If you are working in the Object Explorer, it displays Help topics related to the Object Explorer.. - Dynamic Help is one of the component windows that you can dock or position on the SSMS surface. - Figure 4.4 shows an example of the SSMS environment with the Dynamic Help window docked on the right side of the window. - The Dynamic Help topics in this example are relative to the SELECT keyword that is typed in the query editor window in the middle of the screen.. - FIGURE 4.5 The Registered Servers window.. - The tools available with SSMS can be broadly categorized into tools that are used for administering SQL Server and tools that are used for developing or authoring new SQL Server objects. - SSMS comes with an expanded set of tools to help with SQL Server administrative tasks. - It builds on the functionality that was available in SQL Server 2005 and adds some new tools and functionality to help ease the administrative burden.. - Registered servers is a concept in SQL Server 2008 that represents a division between managing servers and registering servers. - With the SQL Server 2000 Enterprise Manager, the Microsoft Management Console (MMC) tree was displayed on the left side of the Enterprise Manager screen, and it contained servers that had been registered via that tree.. - Any registered servers or groups were listed in the tree, along with any of the associated objects.. - Registered servers are managed and displayed in the Registered Servers component window. - Figure 4.5 shows an example of the Registered Servers window, with several server groups and their associated registered servers. - You can add new groups or servers any time so that you have a handy way of organizing the servers you work with.. - conventional SQL Server instances, like those you could register in the SQL Server 2000 Enterprise Manager. - You can also register several other types of servers. - In addition to Database Engine servers, you can also register servers for Analysis Services, Reporting Services, SQL Server Mobile, and Integration Services. - The Registered Servers window gives you one consolidated location to register all the different types of servers available in SQL Server 2008. - You simply click the icon associated with the appro- priate server type, and the registered servers of that type are displayed in the Registered Servers tree.. - The SQL Server 2008 Registered Servers window enables you to register servers that are running SQL Server 2005, SQL Server 2000, and SQL Server 7.0. - You can manage all the features of SQL Server 2005 and SQL Server 2000 with SQL Server 2008 tools. - You can also have both sets of tools on one machine. - The SQL Server 2000, SQL Server 2005, and SQL Server 2008 tools are compatible and function normally together.. - Management tools from prior SQL Server versions cannot be used to manage SQL Server 2008 instances. - For example, the SQL Server 2000 Enterprise Manager cannot be used to manage SQL Server 2008. - You can connect the Query Analyzer to a SQL Server 2008 instance and run queries, but the Object Explorer and other tools are not compatible with SQL Server 2008.. - You can right-click the server in the Registered Servers window to start or stop the related server, open a new Object Explorer window for the server, connect to a new query window, or export the registered servers to an XML file so that they can be imported on another machine.. - You can export all the servers and groups registered on one machine and save the time of registering them all on another machine. - For example, you can right-click the Database Engine node, select Export, and then choose a location to store the XML output file. - FIGURE 4.6 Multiple server types in Object Explorer.. - Object Explorer. - The Object Explorer window that existed in the SQL Server 2000 Query Analyzer was inte- grated into SSMS in SQL Server 2005. - SQL Server 2008 continues to use an integrated Object Explorer that behaves like SQL Server 2005.. - The most significant feature for those folks managing a large number of database objects is the capability to populate the Object Explorer tree asynchronously. - This may not hit home for folks who deal with smaller data- bases, but it can be a real time saver for those that are dealing with many databases on a single SQL Server instance or for those that work with databases that have a significant number of database objects. - The Object Explorer tree in SSMS displays immediately and allows navigation in the tree and elsewhere in SSMS while the population of the tree is taking place.. - The Object Explorer is adaptive to the type of server it is connected to. - For a Database Engine server, the databases and objects such as tables, stored procedures, and so on are displayed in the tree. - Figure 4.6 shows an example of the Object Explorer with several different types of SQL Server servers displayed in the tree. - The objects displayed in the Object Explorer tree can be filtered in SQL Server 2008. - For example, you can filter the tables displayed in Object Explorer based on the name of the table, the
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt