Page 12 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes Embedded (SSEE)

Windows Internal Database is an alternative of SQL Server Express 2005 that is incorporated
with Windows Server 2008 and Windows Server 2008 R2, and is integrated with other free
Microsoft products released after 2007 that need an SQL Server database backend. Windows
SharePoint Services 3.0 and Windows 3.0 both comprise Windows Internal Database, which can
be accessed as an alternative to by means of a retail edition of SQL Server. WID is a 32-bit
application, even as constituent of Windows Server 2008 64-bit, which installs in the path
C:\Program Files (x86)\Microsoft SQL Server. Windows Internal Database is not obtainable as
a separate product for use by end-user applications; Microsoft offers SQL Server Express and
Microsoft SQL Server for this purpose. In addition, it is intended to only be accessible to Windows
Services running on the similar machine.
SQL Server 2005 Embedded Edition is a specially configured named instance of the SQL Server
Express database engine which can be accessed only by certain Windows Services.

Evaluation

SQL Server Evaluation Edition, also known as the Trial Edition, has all the features of the Enterprise
Edition, but is limited to 180 days, after which the tools will continue to run, but the server
services will stop.

Fast Track

SQL Server Fast Track Data Warehouse is a new set of reference architectures used for data
warehousing that will assist eradicate many of the hurdles companies usually face while making
data warehouses. For as small as $13,000 per terabyte, SQL Server Fast Track Data Warehouse
provides customers instant access to pretested, preconfigured industry-standard hardware from
partners Bull, Dell and HP that augments Microsoft SQL Server 2008 scalability up to 32 terabytes,
and helps decrease the time and attempt required to deploy mission-critical projects.

SQL Server Fast Track is specifically for enterprise-scale data warehousing storage and business
intelligence processing, and runs on reference-architecture hardware that is optimized for Fast Track.

Parallel Data Warehouse (PDW)

A massively parallel processing (MPP) SQL Server appliance optimized for large-scale data
warehousing such as hundreds of terabytes.

Self Assessment

Name the following:
1. A database management and analysis system for e-commerce, line-of-business, and data
warehousing solutions.
2. A low-TCO option for Web hosting.

3. The cloud-based version of Microsoft SQL Server.
4. The full-featured edition of SQL Server and is designed for datacenters that need the high
levels of application support and scalability.
5. The SQL Server edition that includes both the core database engine and add-on services,
with a range of tools for creating and managing a SQL Server cluster.

6 LOVELY PROFESSIONAL UNIVERSITY