Database Reference
In-Depth Information
Notification Services:
These services come in the form
of capabilities for the development and deployment of
applications that can deliver personalized, timely information
updates to a variety of connected and mobile devices.
Integration Services:
These services include data extraction,
transformation, and loading (ETL) capabilities for data
warehousing and enterprise-wide data integration.
Analysis Services:
These services include online analytical
processing (OLAP) capabilities for the rapid and sophisticated
analysis of large and complex datasets using multidimensional
storage.
Reporting Services:
These services provide a comprehensive
solution for creating, managing, and delivering both
traditional, paper-oriented reports and interactive, Web-based
reports from pre-existing databases.
Management Tools:
SQL Server includes integrated management
tools for administering and tuning the database. Two significant
products provided are Microsoft Operations Manager (MOM) and
Microsoft Systems Management Server (SMS).
Development Tools:
SQL Server ships with various integrated
development tools for the database engine, data extraction,
transformation, and loading, data mining, OLAP, and
application development through Microsoft Visual Studio.
18.3 Editions of MS SQL Server
Microsoft markets two server editions (Enterprise and Standard, both in 32 bit and 64 bit
flavors) of SQL Server and several specialized editions of SQL Server. After examining
their requirements and specifications, it should be obvious which one to use. However,
regardless of the edition of SQL Server that one chooses, they are all built on a common
code base (except for the version for Windows CE), so the same rules, conditions, and
administration apply. A brief summary of each edition follows.
SQL Server Standard Edition:
The Standard Edition is what most people mean
when they refer to SQL Server. This version of the product supplies the essential
functionality needed for e-commerce, data warehousing, and line-of-business solutions.
It is intended to run on Windows platforms, starting at Windows Server 2003 (SP2) to
more contemporary versions of the operating system including Windows Server 2008.
Among the prominent features are the following:
•
Support of 16 multiple instances
•
Support of 4 concurrent processors
•
RAM of 3 GB
•
Compliant with 64 bit architecture
