Link to home
Start Free TrialLog in
Avatar of ksfok
ksfok

asked on

SSRS/SSIS/SSAS changes between versions

What are the changes of SSRS/SSIS/SSAS between 4 versions SQL 2000, 2005, 2008  thru SQL2008 R2? Please provide a summary. Thanks.
ASKER CERTIFIED SOLUTION
Avatar of vdr1620
vdr1620
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ksfok
ksfok

ASKER

Thanks. What about SSAS?
Avatar of ksfok

ASKER

Above info for SQL Sever 2008 R2(SQL Server 2010)?
all the above are for 2005 and 2008.. i would suggest to use google a little for many other articles including one's for sql 2008 R2
Avatar of Reza Rad
in 2008 R2 there is no outstanding new feature in these technologies.
maybe sql server 2011 will come with new features
sorry in first post, I meant SSIS only.
and there are new BI evolution going to start with 2008 R2:
http://blogs.msdn.com/b/usisvde/archive/2009/12/23/explore-bi-features-of-sql-server-2008-r2.aspx
http://www.dbta.com/Articles/Editorial/Trends-and-Applications/BI-in-SQL-Server-2008-R2-Empowering-Business-Users-56067.aspx

2008 R2:
New Features for BI (Business Intelligence)
Reporting Service Enhancements

    * Map and spatial data visualization
    * Report Builder 3.0
    * ATOM data feeds
    * AJAX Report Viewer
    * Shared Data Sets
    * Enhanced SharePoint Integration for SharePoint 2007 and SharePoint 2010
    * New 2010 SOAP Endpoint
    * Aggregates of Aggregates and much more

Managed Self Service BI

Power Pivot for Excel

    * Brings analysis service to users desktop
    * Allows IT users to create solutions in Microsoft Excel interface
    * Data will be refreshed periodically

Power Pivot for SharePoint

    * Management dashboard for SharePoint administrators
    * Power Pivot health information, hardware resources and data refreshes will be available



Master Data Services

    * Helps an organization to manage master data
    * Data will be standardized, streamlined, and organized into relationships for analysis