Administrating the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 70

There's more...
The new functionality within SQL Server 2008 R2 version allows the System Administrators
and DBAs to obtain significant control over the SQL Server instances that will have
varying workload requirements with limited system resources. The Microsoft SQL Server
documentation refers to a simple flow chart described as follows:
F The Session 1 of n is an incoming connection (workload), which is related to a
Classification (user-defined classifier function)
F Session 1 of n workload is routed to a workload group
F The workload group uses the resource pool; it is associated with User-defined pool
F The resource pool provides (and limits) the resources required by the Application 1,
Application 2 and Application 3
Designing SQL Server Agent scheduled jobs
for ETL processes
Extracting, Transforming, and Loading (ETL) are key processes for any data management.
ETL activities include an import and export of data from various data sources into an SQL
Server table format. The data volume will vary from one row to billions of rows. To handle such
import/export active ETL operations, a tool is essential. SQL Server Business Intelligence tools
provide a strong foundation by the way of services (SSA) & tools (BIDS).