Datasheet

❑ Extensible Markup Language (XML) — This is fully supported in SQL Server 2005, as well as lan-
guage extensions to XML that enable the retrieval and modification of data by utilizing XQuery
syntax or native XML methods.
❑ The Multidimensional Expressions (MDX)—This language is used to query against multidimen-
sional objects in SQL Server 2005 Analysis Services.
❑ Data Mining Expressions (DMX)—This is a an extension of Transact-SQL that enables the cre-
ation of queries against a data mining model implemented in SQL Server 2005 Analysis
Services.
❑ Extensible Markup Language for Analysis (XMLA) — This can be used to both discover metadata
from an instance of SQL Server 2005 Analysis Services and to execute commands against an
instance of SSAS. XMLA commands are generally limited to the creation or modification of
SSAS objects. Actual retrieval of SSAS data is done with MDX queries.
SQL Server Programming Object Models
Most of the administrative activity that must be done on SQL Server 2005 can be done using the pro-
vided tools, but sometimes it may be necessary to build custom administrative tools, or to be able to pro-
grammatically build and manipulate database objects. Three new object models have been created to
support this need:
❑ SQL Management Objects (SMOs)— SMOs enable developers to create custom applications to man-
age and configure SQL Server 2005, SQL Server 2000, or SQL Server 7.0 Database Engines. It is an
extensive library that provides full support for virtually all aspects of the relational store. The SMO
library makes it possible to automate administrative tasks that an administrator must perform
through custom applications, or with command-line scripts using the SMO
scripter class.
❑ Replication Management Objects (RMOs) — RMOs can be used along with SMOs to implement
and automate all replication activity, or to build custom replication applications.
❑ Analysis Management Objects (AMOs) — AMOs, like SMOs and RMOs, represent a complete
library of programming objects. AMOs enable the creation of custom applications or automation
of Analysis Server management.
SQL Server 2005 Services
SQL Server runs as a service. In fact, it runs as several services if all the different features of the product
are installed. It is important to know what service is responsible for what part of the application so that
each service can be configured correctly, and so that unneeded services can be disabled to reduce the
overhead on the server and reduce the surface area of SQL Server.
MSSQLServer (SQL Server)
The MSSQLServer service is the database engine. To connect and transact against a SQL Server 2005
database, the
MSSQLServer service must be running. Most of the functionality and storage features of
the database engine are controlled by this service.
The
MSSQLServer service can be configured to run as the local system or as a domain user. If installed
on Windows Server 2003, it can also be configured to run under the Network System account.
9
Introducing SQL Server 2005
04_047046 ch01.qxp 10/18/06 12:18 AM Page 9