Database Reference
In-Depth Information
SQL Server Compact Edition:
The Microsoft SQL Server 2008 Compact Edition is
also a free lightweight version of SQL Server that facilitates a low maintenance, compact
embedded database for single-user client applications for all Windows platforms
including tablet PCs, pocket PCs, smart phones and desktops.
SQL Server
Developer Edition:
The Developer Edition is designed to enable
developers to build any type of application on top of SQL Server 2008. It includes all the
functionality of the Enterprise Edition but with a special development and test license
agreement that prohibits production deployment.
18.4 Main Components of MS SQL Server Suite
In this section, we shall briefly examine the main components of the SQL Server suite.
We shall do so under the following categorizations:
•
Server Components
•
Management Tools
•
Client Connectivity
•
Development Tools
•
Code Samples
•
Optional Components
18.4.1 Server Components
The main server components are as follows:
•
The SQL Server (also known as SQL Server Agent) is the core
database engine and the management support service. This
option is enabled by default.
•
The Upgrade Tools is the database upgrade support, so one can
run the Version Upgrade Wizard to upgrade a SQL Server 6.5
installation. This option is enabled by default.
•
Replication Support should be left enabled (as it is by default) if
you plan to use replication.
•
Full-Text Search uses technology from Microsoft Index Server to
build indexes on textual data. This option is installed by default
and supports full-text search in a fail-over cluster configuration.
•
Debug Symbols, enabled by default, provides debug files should
one ever need to troubleshoot SQL Server with Microsoft Product
Support. This option should be left enabled.
•
Performance Counters should be left enabled (as it is by default)
if one wants the ability to monitor SQL Server's performance with
the performance monitor utility that Windows provides.
