• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. SQL Server Basics > Overview of the SQL Server Components

Overview of the SQL Server Components

SQL Server 2000 is composed of several important components. Each plays its own important role in the database management process. The components include:

  • Enterprise Manager— The Enterprise Manager, pictured in Figure 4.1, is a graphical tool that you can use to manage almost every aspect of SQL Server. As you can see in Figure 4.1, the Enterprise Manager provides you with a hierarchical view of your database server. Using the Enterprise Manager, you can create and drop databases, tables, views, stored procedures, and database diagrams. You can also schedule jobs, back up your databases, and perform other management tasks. The section of this chapter titled “Introduction to the Enterprise Manager” and other chapters in this book cover the various aspects of the Enterprise Manager.

    Figure 4.1. The Enterprise Manager is a graphical tool that allows you to manage almost every aspect of your SQL Server.

  • Query Analyzer— The Query Analyzer, pictured in Figure 4.2, provides a graphical environment within which you can interactively create, run, and debug Transact-SQL (T-SQL) statements. The section of this chapter titled “Introduction to the Query Analyzer” and other chapters in this book teach you how to harness the power of this easy-to-use tool.

    Figure 4.2. The Query Analyzer is a graphical tool that allows you to interactively create, run, and debug Transact-SQL statements.

  • Profiler— The SQL Profiler, pictured in Figure 4.3, provides a graphical environment within which you can capture SQL Server events. Using the Profiler, you can diagnose performance and locking problems, perform security audits, and troubleshoot various other problems with your server. The section of this chapter titled “Introduction to the Profiler” and other chapters in this book cover the various aspects of the Profiler.

    Figure 4.3. The Profiler is a graphical tool that allows you to capture SQL Server events.

  • Analysis Services— In previous versions of SQL Server, Microsoft referred to Analysis Services as OLAP Services. The standard installation process does not install Analysis Services. The Analysis Services allow you to perform online analytical processing, data warehousing, and data mining. This text does not cover Analysis Services; they are covered in SQL Server 2000 books such as Microsoft SQL Server 2000 DBA Survivor Guide, available from Sams.

  • English Query— English Query is a powerful tool that allows you to design applications that enable users to enter queries in English rather than T-SQL. Like Analysis Services, the standard installation process does not include English Query. This text does not cover English Query; it is covered in SQL Server 2000 books such as Microsoft SQL Server 2000 DBA Survivor Guide, available from Sams.

  • Client Network Utility— Primarily, network administrators use the Client Network Utility. This graphical tool allows you to start and stop the SQL Server service, as well as to manage the client Net-Libraries and to define server alias names. Using this tool, you can also set the default options used by DB-Library applications. Figure 4.4 shows the Client Network Utility. It is covered in SQL Server 2000 books such as Microsoft SQL Server 2000 DBA Survivor Guide, available from Sams.

    Figure 4.4. The Client Network Utility is a graphical tool that allows you to start and stop the SQL Server service and to perform other administrative tasks.

  • Configure SQLXML support in IIS— This utility (shown in Figure 4.5) assists you with the process of setting up a virtual directory on your Internet Information Server (IIS). Chapter 21, “XML Support in Microsoft Access,” covers this utility.

    Figure 4.5. The Configure SQLXML support in the IIS utility assists you with the process of setting up a virtual directory on your Internet Information Server (IIS).

  • Import and Export Data— The Import and Export Data option launches the Data Transformation Services Import/Export Wizard. Using this tool, you can easily import OLE DB data into or export OLE DB data from SQL Server 2000. This powerful tool also provides a sophisticated means for transforming data (modifying the data as it is imported). The “Data Transformation Services” portion of this chapter covers the Import and Export Data feature in more detail.

  • Server Network Utility— The Server Network Utility, pictured in Figure 4.6, provides a graphical user interface for managing the server Net-Libraries that SQL Server uses. This tool is necessary only if you want to modify the options that you designated when you installed SQL Server. It allows you to designate the network protocol stacks on which an instance of SQL Server listens for client requests and the order in which the SQL Server evaluates network libraries when establishing connections. It also allows you to create new network addresses that SQL Server listens to. The Server Network Utility is covered in SQL Server 2000 books such as Microsoft SQL Server 2000 DBA Survivor Guide, available from Sams.

    Figure 4.6. The Server Network Utility is a graphical tool for managing the server Net-Libraries that SQL Server uses.

  • Service Manager— You use the Service Manager to start, stop, and pause the SQL Server components. Figure 4.7 shows the Service Manager. You can launch it by double-clicking the appropriate icon in the system tray or by selecting Programs, Microsoft SQL Server, Service Manager from the Start menu.

    Figure 4.7. The Service Manager allows you to start, stop, and pause the SQL Server components.

  • Books On-line— Books On-line is the help system for SQL Server 2000. Within this comprehensive help system, you can easily obtain help on any aspect of SQL Server or the T-SQL language.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint