SQL SERVER MANAGEMENT STUDIO in Visual C#.NET

Drawer Data Matrix in Visual C#.NET SQL SERVER MANAGEMENT STUDIO

Figure 2-8. The View menu options 11. SQL Server has two built-in tools as well as the capability to include other tools when they are launched. These can be accessed through the Tools menu, shown in Figure 2-9, along with the means to customize keyboard commands, show or hide toolbar buttons, etc., as is the case with other Microsoft products such as Word. In particular, note the following options: SQL Server Profiler: There will come a time when you wish to monitor SQL Server s performance. This tool will monitor and log events, running code, etc., that you have informed it to check when they happen within SQL Server. Database Engine Tuning Advisor: It is possible to take a workload of data and process it through your solution. This advisor can suggest ways to improve the performance of this process. Options: This option lets you access different options you can use to set up your SSMS as you like. We will take a look at each of these options in the next section.

Figure 2-9. The Tools menu options 12. The final part of SSMS that we will take a look at is the main SSMS toolbar, as you can see in Figure 2-10. Some of the icons, such as the Save icon, will be instantly recognizable, but let s go through each button so that it is clear what they all do.

Figure 2-10. Main toolbar 13. In the next section, you will see how you can write code to add objects, work with data, and so on. Clicking the New Query button will open up a new query window, which allows you to do this using the connection already made with SQL Server.

14. Similar to the New Query button, the New Database Engine Query button will also create a new query window. However, this will give you the option of having a different connection to SQL Server through which to run your code. This is a good way of testing code with a different connection to ensure that you cannot see data that should be secure, such as wages, via that connection.

15. Data within a specialized database known as an analysis database allows you to interrogate the data and analyze the information contained within. The three New Analysis Service Query buttons allow you to build different types of analysis queries. I include this information here only for your reference, as analysis databases fall outside the scope of this book.

16. SQL Server editions also include an edition called SQL Server Mobile. This allows SQL Server to run on devices such as PDAs. If you have this installed, then clicking the SQL Server Mobile Query button will allow a SQL Server Mobile query to be run. Again, this book does not cover this particular function further.

17. As with every other Windows-based product, it is possible to open and save files. The Open button (the first one shown in the following image) will allow you to search for a T-SQL file. The next two buttons change their function depending on what you are doing, but in the main, the Single Save button will give you the option to save the details of the window that is active in the main documents area of SSMS. The Multiple Save button will give you the option to save all the open tabs in the documents window.

18. The last set of buttons open up explorers and document tabs that we have covered already. From left to right in the following image, these buttons access the Registered Servers Explorer, summary page, Object Explorer, Template Explorer, and Properties window.