MS-SQL-Server

Microsoft SQL Server add-ons:
SSIS SQL Server Integration Services,
SSRS SQL Server Reporting Services and
SSAS SQL Server Analysis Services.

6 SQL Server 2008 R2 editions:
Datacenter,
Enterprise,
Standard,
Web,
Workgroup,
Express

Integration Services    in Datacenter and Enterprise editions.
Reporting Services      in all editions of SQL Server 2008 R2.
full reporting services in Standard, Web Workgroup and Express editions.
Analysis Services       in Datacenter, Enterprise & Standard editions w/advanced anal
Standard edition does not include SQL Server PowerPivot for SharePoint (part of the basic Analysis Services package)

SSIS SQL Server Integration Services
the data-warehousing arm of the SQL Server 2008 R2 suite -- (ETL) capabilities.
move data from different data sources to another and changing the data, if necessary.
3 components:
Import/Export Wizard, -transfers data from source to destination (NO transformation capabilities!!)
SSIS Designer         -part of BI Dev Studio to dev/maintenance of integration services packages.
SSIS API Programming  -code SSIS packages using any number of programming languages.

SSRS SQL Server Reporting Services are Web interfaces:
reporting mechanisms:
Report Builder,
Report Designer,
Report Manager ..web admin tool controls reporting services
Report Server


SSAS SQL Server Analysis Services
multidimensional OLAP analysis tool
powerful data mining capabilities, and
deeper dimensions to BI w/relational DB.

Multidimensional analysis is an OLAP technique that produces the ability
to analyze large quantities of data
by storing data in axes and cells
instead of the traditional relational two-dimensional view in rows and columns.

places predictive analytic capabilities in the hands of information workers by creating
an instant connection to backend data using Excel, SharePoint for analysis,
visual presentation and collaboration.