Getting Started with SQL Server 2008 R2 - Microsoft SQL Server 2008 R2 Administration - page 28

F Organizations that are implementing SQL Server as a service that is expected to be
available to multiple business units
F Organizations that are upgrading an existing SQL Server implementation by migrating
to new hardware

How to do it...

The following set of processes is involved in designing and adopting specific SQL Server 2008
R2 solutions:

1. In a typical application fetching data from a database server approach, the SQL

Server infrastructure is designed to support a specific application.

2. This approach involves gathering the requirements about the application, determining

which SQL Server roles will be required, and optimizing the server design for those
specific applications.

3. Another approach is to design Database as a Service that makes the easy availability

of new features for general platform usage.

4. Now the important aspect of design: Before proceeding to the implementation of

database infrastructure, the aspect of storage and performance requirements will
need to be gathered.

5. So the core service for storing, processing, and securing data is catered through the

database engine that supports both relational (OLTP) and analytical (OLAP) methods
for desktop requirements to data warehouse databases.

6. If the application being implemented requires one or more OLTP databases, then the

same process of collection of performance requirement must be repeated.

Other services that may be selected in later tasks could determine the need for the Database
Engine, such as:

F Reporting Services: It requires access to SQL Server-based database server to store
metadata; this metadata database can be on the same server as Reporting Services,
or on another database server. Integration Services can store packages in the msdb
database-which is the system database-or on the filesystem.
F Storage location: It will be determined by the outcome of the decision of whether
or not a database may be required for Integration Services. The inner process of
Integration Services are required, such as:

Merge data from heterogeneous data sources
Populate data warehouses and data marts
Cleanse and standardize data
Automate administrative functions and data loading